ERP Systems Administrative Analyst I, City of Rock Hill
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 period
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 pull proper data and analyze and validate data and reports as required.
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. 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.
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. Valid Driver’s License. Must obtain FBI / CJIS security clearance and bi-annual certification. MCSA:SQL, CSA, CCNP, RHCSA preferred.
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.
Please express interest by submitting your application using the following link: ERP Systems Administrative Analyst I (paycomonline.net).