System Analyst

Ampcus Inc; Woodbridge (VA); On-site; USD 80,000 - 100,000; Full time

Job summary

A global consulting firm is seeking a System Analyst to support OSIsoft PI System infrastructure and data flows in Woodbridge, VA. The ideal candidate will have a Bachelor's degree in a relevant field and at least 3 years of experience, preferably in a water utility. Responsibilities include integrating systems, developing reports, and ensuring data quality while collaborating with users. This position offers a hybrid work environment.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or related field.
• Knowledge of PI system infrastructure and administration, PI AF, and SCADA systems.
• Three years of relevant experience, preferably within a water utility.

Responsibilities

• Support OSIsoft PI System infrastructure and data flows.
• Install, configure, and upgrade PI System components.
• Create and maintain complex visualizations and reports using OSI PI.
• Integrate PI System with other systems and troubleshoot data flow issues.

Skills

OSIsoft PI system administration

Data visualization

SQL querying

SCADA systems knowledge

Power BI integration

Education

Bachelor's degree in relevant field

Tools

Microsoft Power BI

PI SQL Client

OLEDB

ODBC

Job description

Overview

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: System Analyst
Location: Woodbridge, VA (Hybrid)

Responsibilities

• Support OSIsoft PI System infrastructure and data flows; work with Aveva OSIsoft PI, SEEQ, and Microsoft Power BI to provide real and near real-time reporting of time series data from SCADA systems for operational and regulatory reporting requirements.
• Install, configure, and upgrade PI System components (PI Data Archive, PI Asset Framework (AF), PI Vision, PI Interfaces/Connectors).
• Create and maintain complex visualizations and reports using OSI PI, sourcing data from the SCADA.
• Integrate PI System with other systems; manage and troubleshoot data flowing from SCADA, PLCs, etc.
• Work with PI SQL Client, OLEDB, ODBC, or PI Web API for data integration.
• Troubleshoot data flow issues from interfaces/connectors and monitor server health, performance, and data availability.
• Set up and maintain PI tags, points, and AF models; validate and ensure data quality.
• Develop naming conventions, hierarchies, and metadata standards.
• Configure event frames and notifications for alarms or KPIs.
• Query and troubleshoot data issues using SQL.
• Support reporting and analytics tools that consume PI (Power BI and Seeq).
• Connect Power BI to multiple data sources (SQL Server, Oracle, Excel, APIs, cloud data).
• Provide operational support and resolve incidents, including regular system backups, patching, disaster recovery testing, and generating performance/health reports.
• Train and support end users in PI Vision.
• Develop runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.
• Lead projects by identifying risks and dependencies, breaking down tasks into activities and schedules, and facilitating productive project meetings.
• Demonstrate willingness to embrace changing technology landscapes and quickly learn new skills; collaborate to explore emerging technologies that may benefit the organization.
• Mentor and review the work of other team members.

Minimum Qualifications and Requirements

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Science, or related field.
• Knowledge of PI system infrastructure and administration, PI AF, and SCADA systems.
• Three years of relevant experience, preferably within a water utility.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans, or individuals with disabilities.