System Analyst

Ampcus Inc.•Woodbridge, VA

3d•Hybrid

About The Position

Ampcus Inc. is seeking an experienced System Analyst to support OSIsoft PI System infrastructure and data flows. The client uses Aveva OSIsoft PI, SEEQ, and Microsoft Power BI to provide real and near real-time reporting of time series data from SCADA systems to meet operational and regulatory reporting requirements.

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.
Analytical skills, including the ability to think critically.

Responsibilities

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; and manage, and troubleshoot data flowing from SCADA, PLCs, etc.
Experience working 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; and validate and ensure data quality.
Develop naming conventions, hierarchies, and metadata standards.
Configure event frames and notifications for alarms or KPIs.
Proficiency in SQL for querying and troubleshooting data issues.
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 to include regular system backups, patching, and disaster recovery testing and generate performance and health reports.
Train and support end users in PI Vision.
Develop runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.
Lead projects, including: Identifying risks and dependencies between operational tasks and ongoing projects. Breaking down tasks into activities, schedules, and durations within a project lifecycle. Leading and facilitating collaborative, productive, and efficient project meetings.
Embrace changing technology landscapes and quickly learn new skills.
Proactively explore emerging technologies that may benefit the organization.
Mentor and review the work of another team member.