Software Integration Developer

Job Details

Job Location: Rock Hill, SC 29730

Salary Range: $70,944.00 - $95,000.00 Salary

Job Category: Information Technology Services

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;
  Power Shell 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 (Meter Sense/Smart Works MDM, TUNet/Tantalus AMI)
  • Telephony and IVR systems (e.g., Invoice Cloud, Data Voice)
• 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, Power Shell, 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: