Systems Analyst II

Prince William Water; Ashburn (VA); Hybrid; USD 100,000 - 140,000; Full time

Job summary

Prince William Water seeks an IT Project Manager to lead internal upgrades, installations, and enhancements using structured project management principles. You will prepare and manage RFPs, SOWs, project charters, milestones, and deliverables, coordinating with stakeholders to ensure on-time, within-budget results.

The role analyzes requirements, optimizes data flows, and aligns information systems with business goals.

Qualifications

• Bachelor's degree in computer science, information technology, business, or related field.
• At least 3 years of experience in requirements analysis, systems design/development, database administration, and project management.
• Or a combination of education and experience as described above.

Responsibilities

• Lead IT upgrades, installations, and enhancements using formal project management.
• Provide senior management with software/product plans for budgeting and initiatives.
• Analyze requirements to optimize application configurations and data handling.

Skills

Project management

Systems analysis

Requirements gathering

Data analysis

Education

Bachelor's degree in CS/IT/business

Tools

Cityworks

Oracle Primavera

J.D. Edwards

SharePoint

PowerBI

Cayenta

Job description

This position is eligible for a partial telework schedule, with a combination of on-site and remote work based on job responsibilities and operational needs.

• Serve as Project Manager for internal information technology upgrades, installations, and enhancements using sound project management principles and systems analysis. Duties include Request ForProposal (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, Aveva OSI Pi, Microsoft PowerBI, 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.

• Knowledge of the principles of project management, systems analysis, and programming; Microsoft server operating system; financial, purchasing, and payroll practices; English usage, spelling, and grammar; computer equipment and software related to assignment, including Cayenta, Cityworks, J.D. Edwards, SharePoint, Aveva OSI Pi, Microsoft PowerBI, Oracle Primavera and Databases; query and reporting writing tools.
• Ability to communicate effectively with clients in non-technical terms, both orally and in writing; work cooperatively; troubleshoot and diagnose systems problems and or make or recommend resolutions in areas of responsibility; evaluate alternatives and make sound independent decisions within established guidelines; prepare clear, concise and accurate documentation, reports of work performed, project management reports and other written materials; read, interpret, explain and apply technical information on business processes, software, and hardware for technical and nontechnical users; keep technical skills current to meet continuing requirements for assignments; establish and maintain cooperative working relationships with all levels of employees and customers,
• Extensive knowledge of data processing, hardware platforms, and enterprise software applications.
• Technical experience with query and report writer tools, application integration, and databases.
• Strong project management skills with effective results focus within an information systems environment.
• Strong analytical and problem-solving skills.
• Knowledge of Document Management, Financial, Purchasing, and GIS practices.
• Experience with Cayenta, Cityworks, SharePoint, Aveva OSI Pi, Microsoft PowerBI, Oracle Primavera, J.D. Edwards, and/or Database software.
• Technical knowledge and experience with Windows server and desktop environments.

Minimum Education and Work Experience:

• Bachelor’s degree in computer science, information technology, business, or related field.
• At least three years of experience which includes requirements analysis, systems design and development, database administration, and project management.
• Or a combination of education and experience as described above.

Required Licenses/Certifications and Other Special Requirements:

• None.

Minimum Lead/Supervisory or Management Experience:

• None.

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.

• Physical demands: The work is mostly sedentary with periods of light physical activity. Typical positions require workers to walk or stand for short periods; lift and carry up to 20 pounds; climb stairs, bend, reach, hold, grasp, and turn objects; and operate computer keyboards. The work requires the ability to speak clearly and to see and hear clearly with or without correction. Subject to work beyond the normal scheduled hours of work; to attend evening meetings and work sessions.
• Work environment: Primary work is performed indoors in a standard office setting. The noise level in the work environment is usually moderate.

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.