Software Integration Developer (48355)

General Description:

The purpose of this job Class within the organization is to manage, analyze, maintain and fully support the integration of software applications and services within the Information Technology Services Department. This Class job holds High proficiency as a System Administrator / Analyst / Scripting Programmer and works with cross divisional applications systems and services to improve functional utility and data servicing, along with setting and establishing enterprise-wide standards and governance rules in conjunction with the CIO/Director.

Note:

Work hours 8:00AM – 5:00PM, Monday - Friday. Unless required to be adjusted for business needs. Also responsible for on-call after-hours support as required.

Minimum Education and Experience Requirements:

Associates or Bachelor of Science degree preferred, or equivalent Experience & certifications obtained, with 3 years of growth shown in progressive responsibility. Requires progressive responsibility and experience within the job description outlined or a closely related or associated field. The equivalent combination of education, training or related work experience may be considered.

Special Certifications, Clearances and Licenses:

Valid Driver's License. Must obtain FBI / CJIS security clearance and bi-annual certification. MCSA:MCSE; SQL, CSA, CCNP, RHCSA preferred.

Knowledge, Skills and Abilities:

• 50% of the time will be devoted to basic System Administrator supporting and maintaining of the existing diverse city server farm and applications.
• The other 50% of the time will be devoted to helping to design and build out data servicing and integration applications. It will require full understanding of SQL; Power-BI; Power automate; PowerShell Scripting; and Python scripting to maximize integration and exchange between our ERP and Utility management systems. It will require you to learn the ERP system (Cayenta); the Spatial GIS Systems: ESRI and Cityworks; and the Utility management systems.
• Deep understanding of enterprise systems including:
  • ERP systems (Cayenta: CU, CF, HR, PA, CSS, CE, MWM, APIs)
  • Business Intelligence tools (Cognos, Power BI)
  • Database systems (SQL Server, data modeling)
  • SharePoint (data repositories, workflows)
  • Utility systems (MeterSense/SmartWorks MDM, TUNet/Tantalus AMI)
  • Telephony and IVR systems (e.g., Invoice Cloud, DataVoice)
• Knowledge of cybersecurity principles, compliance requirements (e.g., PCI), and vulnerability assessment.
• Skilled in SQL scripting and database querying, Power BI (reporting and dashboards), scripting languages such as Python, PowerShell, Power Automate, etc., permission management, server maintenance, upgrades, and backup infrastructure
• Strong analytical skills to evaluate, extrapolate, and resolve complex technical issues
• Ability to analyze data presentation services for performance and security
• Capability to design, customize, or profile systems and environments for organizational needs
• Ability to oversee upgrades and new technology implementations
• Ability to lead or participate in cross-functional teams and technical meetings
• Ability to document systems, procedures, and workflows clearly
• Ability to deal with people beyond giving and receiving instructions. Must be adaptable to performing under stress when confronted with emergency situations or tight deadlines.
• Ability to maintain positive customer-focused relationships with co-workers, supervisors, agencies, the general public, and all other internal and external customers. Personally demonstrates appropriate customer service skills.
• Ability to manage your time and efforts across multiple disciplines and duties is the core of the job.
• Work is performed onsite. The incumbent must be present at work to perform the essential functions of this job.

Essential Job Functions:

1. Serves as the primary lead for coordinating, maintaining, and supporting all core data services and enterprise systems including SharePoint, SQL, Cayenta ERP (CU, CF, HR, PA, CSS, CE, MWM, APIs), Cognos/BI, Invoice Cloud, IVR, DataVoice, MeterSense/SmartWorks MDM, and TUNet/Tantalus AMI. Ensures optimal performance, integration, and availability across platforms.
2. Responsible for the full lifecycle of assigned systems—from development and configuration through troubleshooting, debugging, and performance optimization. Manages presentation services and ensures enterprise data is accessible, efficient, and secure.
3. Ensures compliance with cybersecurity standards, including PCI regulations. Analyzes system and data vulnerabilities and applies appropriate security measures, including least privileged access control and data loss prevention (DLP).
4. Acts as the primary technical support for ERP and utility-related systems. Provides front-line troubleshooting and issue resolution, including after-hours support on a rotational basis.
5. Designs, creates, and maintains data reports and visualizations from various data sources (e.g., SQL, SharePoint, Power BI). Supports decision-making by gathering and presenting accurate and meaningful data across departments.
6. Manages IT projects and system upgrades. Acts as a liaison with vendors and handles related contract management responsibilities.
7. Maintains detailed documentation for all assigned systems and services. Trains staff and supports users across the organization in data services and technology usage.
8. Supports the security and reliability of server and backup infrastructures. Oversees disaster recovery (DR) and high availability (HA) strategies for operational continuity.
9. Researches and evaluates emerging technologies for potential implementation. Integrates new and existing software into current systems, including imaging and deployment platforms.
10. Performs administrative tasks such as preparing reports, documentation, emails, and spreadsheets. Attends meetings, responds to support tickets, and engages with customers and staff as needed.
11. Participates in citywide committees and initiatives to support organizational goals. Contributes to the enhancement of city services through cross-departmental collaboration.
12. Performs all other duties as assigned to meet organizational needs.

This Notice is not intended to be an all-inclusive list of duties, knowledge, skills and abilities required to do the job. This is intended only to describe the general nature of the job. A more comprehensive list of duties, responsibilities and essential job functions is available on the job description. The City of Rock Hill is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, religion, color, political affiliation, disability, national origin, genetic information, sex (including pregnancy, childbirth, or related medical condition), or age.