Job Summary

This position is responsible for performing difficult professional and administrative work designing, implementing, and maintaining automated systems, systems programming, and database administration for software developed in-house as well as software acquired from third parties. The incumbent provides project management for assigned application development projects and oversees some technical support for existing applications. The incumbent provides data analytics, data portals and develops reports and interfaces. The incumbent also ensures that requirements analyses, specifications, programming, documentation, and testing are completed correctly, on time, and according to established standards. The incumbent is also responsible for some systems programming and database administration on one or more of the City's various software applications. The work requires a proactive approach to ensure the applications meet the needs of a wide range of users in a rapidly expanding environment. Assignments, tasks and projects are performed under general managerial direction and the work has serious impact on the objectives of the department and the work of the City as a whole. The incumbent is required to be on call and perform other duties as required.

Essential Job Functions

Data AnalysisPrepares reports, dashboards and visual displays of data to aid stakeholder’s analysis and decisions.Artificial Intelligence and Machine LearningImplements solutions using AI and ML to improve existing systems & processes and to bring new capabilities to the City.System MaintenanceSupports enterprise applications including the financial system, human resources system, and timekeeping system.Implements updates to enterprise applications.Maintains and documents system processes, accounts, and user profiles.Coordinates application batch processing.Investigates causes of performance problems and makes corrections as necessary.Reviews and checks system files, logs, reports, and capabilities.Investigates system problems and coordinates their timely resolution with vendor and hardware/network support personnel.Assists with disaster recovery procedures.System DevelopmentAssists software development projects and provides analysis with objectives and outlined procedural approaches; performs detailed review of the end product for adherence to user requirements, development standards and documentation standards.Coordinates and directs project management, implementation of new applications, training, documentation, and maintenance activities.Assists staff with requirements analyses, system, and program specifications, writing and testing of software, and preparation of documentation.Assists in the drafts Requests for Proposals and other appropriate specifications for application and system software and utilities or related equipment.Prepares, plans, and assists in the installation of new releases for all city-wide applications.Ensures that requirements analyses, specifications, programming, documentation, and testing are accurately completed.System SupportEstablishes procedures, standards, and reporting formats; trains staff and ensures that standards and procedures are being followed correctly.Assists end-users with problems encountered in the use of applications software.Assists with the training of system users.Assists staff and users with questions and problems regarding the above systems, or other systems related software.CommunicationInterfaces with vendors regarding project definition, schedules, billing, and acceptance of work performed, where projects involve third-party vendors.Works closely with departments on related issues.Works directly with managers to plan and organize the implementation of automated systems schedules.Participates in the preparation of the division budget.Participates in interdepartmental committees to guide the direction of systems and processes.

Qualifications

Preferred: bachelor's degree with major coursework in information systems or closely related field from an accredited university or college; and five (5) years of progressively responsible work with automated systems and programming.

Knowledge, Skills, and Abilities

Preferred:Experience with data analytics and reporting, data visualization. Familiarity with cloud-based data analytics (data ingestion, cleaning and visualization)Experience in R, Python and an understanding of artificial intelligence and machine learning.Familiarity with various systems and sub-systems including Financial, Payroll, Human Resources, General Ledger, Purchasing, Inventory, Time & Attendance, Performance Budgeting, Applicant Tracking, Procurement Card and Revenue systems.Understanding of frameworks to unify data and data portals.Critical-thinking and problem-solving skills.Skill in communication and presentation, including interaction with end users in an automated systems setting. 
Desirable:Knowledge of GIS and some experience with ArcGIS Pro and ArcGIS Online.Understanding of accounting procedures, practices, and concepts and how they apply in an automated systems environment.Experience with SQL reporting in cloud and server-based environments.Knowledge of the hardware and software platforms currently used by the City.Experience with SQL reporting in cloud and  server-based environments.Knowledge of CGI Advantage ERP system, cloud or on-premise, including AP, GL, Purchasing, Inventory, HR, Payroll, Budget, and Employee Self Service modules.  Knowledge of Kronos Time and Attendance systems and how it relates to current financial and payroll systems.Familiarity with Business Objects or other data warehouse and report writing environments.Understanding of Excel macros.Experience in the area of systems analysis, including requirements analysis, general design, and detailed design.Familiarity with database and applications development, including coding, testing, debugging, implementation, and maintenance.Ability to understand hardware and software concepts, system security, data management, systems analysis and design, and programming techniques.Knowledge of vendor support services.