Energy Data Analyst I

Northern Wasco County People's Utility District

Energy Data Analyst I focusing on energy supply analytics and supporting Power Resources operations in a hybrid work environment.

Posted 5/29/2026full-timeThe Dalles • Oregon • 🇺🇸 United StatesJuniorMid-Level💰 $80,851 - $121,276 per yearWebsite

Tech Stack

Tools & technologies

ETLLinuxPythonRDBMSSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLrelational database management systemsETL toolsobject-oriented programmingPythondata modelingstatistical modelingdata analysisdata integrationAPI development

Soft Skills

organizational skillsanalytical skillscommunication skillstechnical writingoral presentation skillsmathematical skillsattention to detailability to handle confidential informationindependent workcollaborative work