ERP Systems Admin Analyst I

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.