Energy Data Analyst I
Northern Wasco County PUD | The Dalles, Oregon
Candidates must reside in one of the following states: Oregon, Washington, Idaho, Arizona, and Montana
Why Northern Wasco County PUD?
Join a public utility recognized as one of The Oregonian’s 2025 Top Workplaces. Northern Wasco County PUD offers an exceptional benefits package, including 100% employer-paid medical, prescription, dental, and vision premiums for employees and their families, plus a 7.5% base employer 401(k) contribution and up to an additional 7.5% employer match.
Beyond the benefits, this is an opportunity to apply advanced data and analytics skills to work that directly supports electric power operations and the communities Northern Wasco County PUD serves.
Mostly Remote Work: This position offers a primarily remote work arrangement, with occasional travel to the Northern Wasco County PUD office in The Dalles, Oregon for meetings, projects, or other business needs. Candidates should be able and willing to travel to the office when required.
About the Role
Northern Wasco County PUD is seeking an Energy Data Analyst I to join its Power Resources team. This is a hands-on technical role combining complex SQL, Python, relational databases, ETL/data pipelines, and business intelligence with energy supply and power market analytics.
You’ll develop and maintain the databases, software, automated pipelines, integrations, dashboards, and reporting solutions that support critical Power Resources data and decision-making. You'll also work with large time-series datasets involving electric load and resources, power market analytics, energy settlements, reconciliation, and operational reporting.
Previous electric utility or energy industry experience is preferred but not required. Candidates with strong technical data analytics experience from other industries are encouraged to apply.
What You'll Do
- Develop and optimize complex SQL queries and data models.
- Develop and maintain relational databases, including schemas, tables, functions, and views.
- Design, build, schedule, and maintain ETL processes and around-the-clock automated data pipelines.
- Troubleshoot data quality, availability, integration, and performance issues.
- Develop and maintain software, APIs, integrations, and reporting tools supporting critical Power Resources data.
- Analyze electric load and resource data across hourly, daily, weekly, monthly, and annual time periods.
- Provide power market analytics and monitoring to support operations, planning, and decision-making.
- Organize, validate, and analyz