City of University Park: Erp Systems Analyst

Please apply at our City Homepage with the link below:https://www.Governmentjobs.Com/careers/uptexasDutiesPRIMARY DUTIES AND RESPONSIBILITIES:Maintains, manages and updates New World ERP softwareCreates and maintains user accounts using access control settings, including granting users the relevant roles they need to access required processes and dataPartners with other City IT staff and vendors to ensure that the City’s data is protected from a cyberattack or data breachPerforms verification tests with end users on New World ERP software upgrades/updates before migrating upgrades/updates to production environmentPartners with New World ERP technical support and City IT staff to minimize unplanned outagesServes as a technical resource to New World ERP users to address system issues and improvementsProvides technical training for end usersActs as subject matter expert on New World ERP software and business processesCreates and maintains documentation related to the maintenance and usability of New World ERPWorks with other vendors to develop data interfaces to improve data flow between New World ERP and other City applicationsUses knowledge of structured query language (SQL) and New World ERP data structure to create ad hoc reports and/or database applications customized to specific needs of department users QualificationsKEY REQUIREMENTS:Bachelor’s degree in Information Systems or related discipline required3-5 years of experience or equivalent knowledge maintaining and overseeing an enterprise resource planning application used by a municipality or county3-5 years of experience or equivalent knowledge in mastering database management software/tools, including proficiency in SQL query building and report writing3-5 years of experience or equivalent knowledge providing technical support for end users working in Finance, Human Resources and Utility BillingExperience providing technical support of municipal government applicationsExperience working with business intelligence and reporting tools (e.G.

Cognos, Crystal Reports, SSRS, or PowerBI)Knowledge of advance metering infrastructure applications used to collect water consumption dataSKILLS & ABILITIES:Proficient with MSSQL stored procedure creation, job creation, general report automationProficient with advanced MSSQL features to use in automating data delivery, file creation, and notificationsKnowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)Proficient with Open Database Connectivity (ODBC) creation/usageProficient with MSSQL 2012Proficient with MS Office 2019 applicationsKnowledge of General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Utility Billing, PayrollMust maintain confidentiality when working with sensitive customer or employee dataMust be able to work under tight deadlines efficiently and with high qualityMust possess strong organizational skills with demonstrated attention to detailMust have the desire to collaborate with multiple departments and serve as an advocate for end users Supplemental Information PHYSICAL AND ENVIRONMENTAL CONDITIONS:Work is primarily performed in a climate-controlled office environment.

Physical demands are sedentary in nature with prolonged sitting.

Work may cause fatigue of eyes, fingers, and other facilities because of fairly continuous use of motor senses.

Requires moderate physical effort in carrying/moving microcomputers and peripheral equipment.

Includes walking, standing, reaching, bending, and occasionally driving a vehicle.