Job Description

General Description:
The purpose of this job is to provide active and current support for core ERP and utility management systems and applications within the Information Technology Services Department. This 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.
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

Additional Duties:

  • Research new and existing projects for process improvement, new ways of implementation.
  • Proficient or exposure to SharePoint, Power-BI and Powershell.
  • Plus if have exposure to GIS based technologies and Cityworks.
  • Uses knowledge of scripting, Active Directory, SQL to gather data from various sources which is then used as various reporting mechanisms throughout the city; conducts research to discover new methodologies or to find solutions for unresolved problems.
  • Integrates new and existing software products into current imaging and deployments system.
  • Assists with the maintenance and upgrades of server/backup infrastructure and ensures proper upkeep.
  • Performs general administrative and clerical work as required, including preparing correspondence, reports, email, and spreadsheets, entering and retrieving computer data, copying and filing documents, attending meetings, responding to phone calls and emails.
  • Performs related work as assigned.


Apply Now

Job #:
Position Type:
Full Time/Contract
Rock hill, SC

Apply Now