Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Optomi

NewBe an early applicant

Data Analyst 2

Posted Updated

Summary

A mid-level data analyst (placed via staffing firm Optomi) builds the data and analytics foundation for an energy client's renewable asset portfolio: administering PI System/Asset Framework asset hierarchies, using SQL and Python for data prep, anomaly detection, and quality control, and delivering Power BI dashboards and near-real-time monitoring of equipment health and performance.

Data Analyst 2 (PI System, Asset Framework, SQL, Python, Power BI)

Optomi, in partnership with our client, a leading energy organization responsible for delivering reliable energy services and supporting a growing portfolio of renewable energy assets, is seeking a Data Analyst 2 to help build and maintain the data and analytics foundation behind its renewable energy operations. This individual will support the management of large-scale asset data, develop reusable data models and hierarchies, and turn millions of equipment and sensor signals into consistent, actionable operational insights. The ideal candidate will bring experience with PI System/Asset Framework or a comparable historian architecture, along with strong SQL and Python skills, data engineering and analytics experience, and the ability to develop dashboards and reports using Power BI or similar visualization tools. This role is well suited for someone who understands time-series data, equipment relationships, data quality, and renewable energy performance, and who enjoys partnering with technical and operational teams to improve asset visibility, performance, and decision-making.


What the right candidate will enjoy!

  • Supporting the data and analytics foundation behind a growing portfolio of renewable energy assets.
  • Working with large volumes of operational data generated by equipment, sensors, and monitoring systems.
  • Designing and maintaining scalable asset hierarchies and reusable templates rather than building one-off solutions for individual sites.
  • Combining data analysis, data engineering, database management, and visualization in a hands-on technical role.
  • Using SQL and Python to investigate operational trends, identify anomalies, automate recurring analysis, and improve data quality.
  • Developing dashboards, reports, and near-real-time monitoring that help operations teams understand equipment health, performance, availability, and losses.
  • Partnering with technicians, operators, engineers, and OEMs to turn analytical findings into practical operational improvements.
  • Supporting renewable energy performance monitoring and compliance-related reporting through reliable data, event detection, and supporting evidence.
  • Improving consistency and efficiency across sites by developing standardized KPIs, calculations, data-quality rules, and reporting processes.
  • Taking ownership of technical documentation, data lineage, version control, and continuous improvements to the analytics environment.


Experience of the right candidate:

  • Professional experience in data analytics, data engineering, database administration, operational technology analytics, or a similar technical role.
  • Hands-on experience with PI System, PI Asset Framework (AF), or a comparable industrial historian and asset data architecture.
  • Experience designing, administering, or maintaining database structures, asset hierarchies, metadata, equipment relationships, and data models.
  • Strong SQL skills, including the ability to write complex queries for data preparation, validation, analysis, and troubleshooting.
  • Experience using Python for data analysis, automation, anomaly detection, data preparation, or recurring quality-control processes.
  • Background working with time-series data, sensor data, equipment signals, or other operational datasets.
  • Experience developing dashboards, reports, and operational visualizations using Power BI or a comparable tool.
  • Understanding of data quality concepts, including validation rules, missing or stale data, signal exceptions, and automated testing.
  • Ability to develop and maintain KPI calculations, business rules, and analytical logic.
  • Experience translating technical data and analytical findings into clear, actionable information for business and operational stakeholders.
  • Strong technical documentation skills, including documenting calculations, data models, processes, and data lineage.
  • Familiarity with code repositories, version control, and change management practices.
  • Strong analytical and problem-solving skills, with the ability to investigate data issues and identify root causes.
  • Ability to collaborate with technicians, operators, engineers, and other cross-functional stakeholders.
  • Experience with renewable energy assets, such as solar, wind, or battery storage systems, preferred.
  • Understanding of renewable energy performance concepts, including equipment availability, energy production, performance losses, and equipment health, preferred.
  • Experience working with industrial equipment data, SCADA systems, historians, or operational technology (OT) environments preferred.
  • Familiarity with compliance reporting, qualifying-event detection, event timelines, and supporting evidence documentation is a plus.


Responsibilities of the right candidate:

  • Administer and govern the renewable asset data model, including database structures, metadata, equipment relationships, data quality rules, and access patterns.
  • Design, build, and maintain Asset Framework hierarchies and reusable templates for renewable energy sites and equipment, including inverters, battery blocks, combiner boxes, trackers, meters, and weather stations.
  • Map raw sensor identifiers and equipment tags to standardized attributes, calculations, and governed data structures.
  • Establish reusable data models and templates that allow newly onboarded assets to populate standard dashboards, displays, and reports with minimal custom development.
  • Build, validate, document, and maintain KPI calculations, automated data-quality tests, alert logic, and diagnostic queries.
  • Develop operational displays, dashboards, reports, and near-real-time monitoring to communicate asset performance, availability, losses, equipment health, and priority actions.
  • Use SQL and Python for data preparation, anomaly detection, event reconstruction, recurring automation, ad hoc investigations, and scalable quality-control routines.
  • Investigate missing, stale, inaccurate, or inconsistent equipment signals and work with technical teams to resolve data-quality issues.
  • Partner with technicians, operators, engineers, and original equipment manufacturers (OEMs) to interpret findings and translate analytical insights into operational actions.
  • Validate whether operational interventions have restored equipment performance or resolved identified issues.
  • Develop queries and reporting to support compliance-event detection, event timelines, supporting data, and evidence packages.
  • Maintain technical documentation covering asset hierarchies, KPI calculations, data models, code repositories, data lineage, and change management.
  • Identify opportunities to standardize analytics across renewable energy sites and reduce reliance on one-off reports and custom development.
  • Collaborate with data, engineering, and operations teams to improve the reliability, scalability, and usability of renewable asset data.
  • Monitor the completeness and quality of the approved asset hierarchy, standard KPI population, stale-tag rates, and unresolved signal exceptions.
  • Continuously improve the speed and consistency of asset onboarding, operational reporting, and actionable analytics delivery.

Skills

Apply

See also

Data Analytics jobs by country — openings, pay and top skills →