Cityworks Systems Analyst

Position Summary

Performs Internal Project Management and Systems Support of varied information systems at Prince William Water. Assists management in the successful analysis of data from areas such as finance, customer service, engineering, operations and maintenance, utilizing the effective application of technology. Overall goals are set, and the worker determines the specific tasks and assignments to be performed, independently handling new, unusual problems and deviations encountered in the work. Demonstrates a commitment and supports a culture of diversity, equity, and inclusion.

Position Responsibilities / Essential Job Functions

• Serve as Project Manager for internal information technology upgrades, installations, and enhancements using sound project management principles and systems analysis. Duties include Request For Proposal (RFP), statement of work (SOW), project charters, project milestones, and deliverables.
• Provide Senior Management with software product plans for future budgeting and information systems initiatives to maximize efficiency and performance and identify opportunities to automate existing processes.
• Analyz application requirements to determine the most efficient configuration of application software, and the importing and manipulation of data to maximize the value of the application.
• Financial analysis, reporting, and integration of information systems to meet Prince William Water business process requirements to include enterprise reporting, processing, and reconciliation of Utility Billing, Construction Permitting, Project Management Office, Operations and Maintenance, Document Management, Procurement, and E-Commerce.
• Work with application users to determine operational requirements and optimal business solutions using available technologies and the best methods for fulfilling them.
• Consult with Information Technology staff and users in the design, development, and implementation of procedures, routines, interface between applications, and oversees same using a variety of application software products, data management, and office automation tools.
• Maintain a good working knowledge of the databases, tables, elements, and relationships with other applications to avoid duplication, redundancy, and data inconsistencies.
• Troubleshoot month-end and year-end processing issues.
• Develop and maintain automated interfaces between various applications.
• Provides support, training, and documentation as needed to end users for specialized vendor software systems such as Cityworks, Oracle Primavera, J.D. Edwards, SharePoint, PM Web, Cayenta, and Cognos.
• Prepare specifications, codes, test, document, and execute data maintenance routines to move data from a variety of electronic sources to and from relational databases, flat file structures, etc.
• Develop a wide range of queries and reports using high-end query and report writer tools.
• Work with staff to schedule workloads to ensure that all project deliverables are completed by agreed project target dates and within budgets.
• May be deemed essential at any time.
• Perform other duties as assigned or required.

Essential Skills and Experience

Essential Competencies :

Minimum Education and Work Experience :

Required Licenses / Certifications and Other Special Requirements :

Minimum Lead / Supervisory or Management Experience :

Physical Demands and Work Environment

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

The qualifications listed above are intended to represent the minimum skills and experience levels associated with performing the duties and responsibilities contained in this job description. The qualifications do not express absolute employment or promotional standards. They are general guidelines that should be considered along with the job-related selection or promotional criteria.