Data Analyst
Core
Develop and maintain databases, automated data pipelines, and reporting solutions to support electric power operations, energy settlements, and market analytics 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)
Builds
Automated ETL pipelines, relational databases, dashboards, and reconciliation reporting for power resources
Domain
Energy industry / Electric utility operations
Required skills
Complex SQL, Relational database management (RDBMS), ETL pipeline development, Python, Git, Linux/Windows environments, Business Intelligence, Microsoft Excel
Preferred skills
PostgreSQL, Grafana, R, Java, AWS, SCADA, Power market analytics, Electric load data analysis
Technologies
SQL, Python, PostgreSQL, Grafana, R, Java, AWS, Linux, Windows, Microsoft Office
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; Troubleshoot data quality and integration issues; Present analytical findings to stakeholders.
Seniority
Mid-Senior level (3-5 years experience)
