General Description:

The purpose of this job Class within the organization is to provide active and current support for core ERP and utility management systems and applications within the Information Technology Services Department. This Class job will have the ability to adapt to and learn the city’s Cayenta ERP system and be proficient in all ERP and associated applications, SQL, SQL queries, and database services to facilitate enterprise-wide computer and data services necessary operations.

This class works independently, under limited supervision, reporting major activities through periodic meetings.

Note:

All work in Premises based.

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:SQL, CSA, CCNP, RHCSA preferred.

Essential Job Functions:

• Responsible for managing and maintaining all core data services: Cayenta (CU, CF, HR, PA, CSS, CE, MWM, API’s, Cognos and Power-BI reports IC: Invoice Cloud and IVR: dataVoice / MeterSense / SmartWorks MDM and Tunet: Tantalus AMI.
• Responsible for performance and operational efficiency of assigned systems.
• Primary data services troubleshooting support and vendor liaison.
• Proficiency in SQL, creating SQL queries or any current Database used by city.
• Ability to analyze, extrapolate and deduct complex options and designs to safely and securely manipulate, customize or profile given software environments, operational challenges, or functional needs of the organization.
• Ability to pull proper data and analyze and validate data and reports as required.
• Responsible for SQL, Power-BI and Cognos report structuring, writing and debugging.
• Lead, participate or facilitate technical meetings or services pertaining to ERP and Utility systems and services.
• Responsible for security of data services and the data contained within the DBs.
• After hours technical support on call rotation responsible.
• Liaison for all vendor services required to support Utility and ERP systems.
• Responsible for DR and HA support of all data services.
• Responsible for and supports Core ERP system services, Cayenta and AMI.
• Documents, trains, and supports data services and the customer base served.
• Maintains, upgrades, and troubleshoots associated servers.
• Devise and build complex options or design as required.
• Participates in Evaluating and implementing new technologies.

Desirable Knowledge, Skills and Abilities:

• Proficiency in the English Language, both spoken and written; must be able to speak in front of audience of your peers or customers; must be able to do technical documentation in English.
• Proficient with using Computers & entire suite of Microsoft Office Products.
• Extensive knowledge of all core Microsoft products, SQL, SharePoint, Exchange, Teams, etc.

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.