Provide power market analytics and monitoring to support Power Resources operations, planning, and decision-making.
Analyze electric load and resource data (hourly, daily, weekly, monthly, and annual) related to settlements with counterparties; organize data and assist with reconciliation reporting.
Develop, update, and maintain databases, software, and reporting tools that support critical Power Resources data and workflows.
Develop complex SQL queries and data models; administer and support relational database management systems.
Design, build, and manage ETL processes and around-the-clock (ATC) data pipelines; troubleshoot data quality, availability, and performance issues.
Create dashboards and visualizations; compile, validate, and distribute KPI reports and other periodic or ad-hoc reporting.
Perform statistical modeling and analysis of structured and unstructured datasets; identify trends and present results through reports and presentations.
Develop and maintain data integrations and APIs that collect large time-series datasets from internal and external sources.
Work with end users to understand data needs, document technical requirements, and deliver solutions on strict deadlines.
Prepare and present written and verbal recommendations to support strategy and operations aligned with District goals.

Bachelor’s degree in computer science, data science, mathematics, statistics, physical science, natural science, engineering, or a related field
One to two (1–2) years of professional experience or advanced academic study in data analytics, business intelligence, software development, or a related area
Experience supporting an electric utility, energy market analytics, creating data displays and dashboards, settlements/reconciliations, SCADA, or energy/financial reporting systems is preferred
Must-have technical skills: SQL; relational database management systems (RDBMS); ETL tools; object-oriented programming and Python; Git/GitHub; Windows and Linux; Microsoft Excel; proficiency in EDRMS and Microsoft Office Suite.
Must-have professional skills: strong organizational, analytical, and communication skills; strong technical writing and oral presentation skills; strong mathematical skills; attention to detail and accuracy; ability to handle confidential information responsibly; ability to work independently and collaboratively to meet strict deadlines; ability to implement and complete cross-functional initiatives; ability to present data and create visualizations that support decision-making in the Power Resources Department.

Generous PTO Accruals
11 Paid Holidays
100% employer paid premium for Medical/Rx/Dental for individual and/or family coverage
100% employer paid premium for vision coverage for individual and/or family coverage
100% employer paid Basic Life Insurance 2X annual salary
401(k) 7.5% base + 7.5% match = 15% total possible employer contribution
457(b)
100% employer paid Short Term Disability and Long Term Disability
HRA VEBA employee funded Wellness Incentive to HRA VEBA employer funded
100% Paid Business Travel Insurance
Voluntary benefits

Energy Data Analyst I

Key skills