Data Analyst
Core
Develop and maintain databases, automated pipelines, and reporting solutions to support electric power operations, energy settlements, and decision-making for a public utility.
Role type
Senior IC data analyst (energy/power markets) (via careerplan.io/jobs/CA-00A-50-37C-12-60C-data-analyst-at-roi-agency)
Builds
Automated data pipelines, dashboards, and reporting solutions for power resources
Domain
Energy / Electric utility / Power markets
Deliverable
dashboards & analysis
Required skills
SQL, Python, relational databases, ETL/data pipelines, Git, Linux/Windows, BI tools, Excel
Preferred skills
PostgreSQL, Grafana, R, Java, AWS, SCADA, energy market analytics, time-series data
Technologies
SQL, Python, PostgreSQL, Grafana, R, Java, AWS, Git, Linux, Windows, Excel
Responsibilities
Develop and optimize complex SQL queries and data models; Design, build, and maintain ETL processes and automated data pipelines; Analyze electric load and resource data across multiple time periods; Create dashboards, visualizations, and KPI reports; Perform statistical modeling to identify trends; Present analytical findings to stakeholders.
