Data Analyst

ROI - Workforce as a Service (WaaS); The Dalles (OR); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

100% employer-paid Medical/Rx/Dental

100% employer-paid Vision

401(k) with 7.5% base contribution + 7

Generous PTO

11 paid holidays

Employer-paid life insurance 2x salary

HRA VEBA

Wellness incentive to HRA VEBA

Business travel insurance

Voluntary benefits

Job summary

Northern Wasco County PUD in The Dalles, Oregon is seeking an Energy Data Analyst I to join its Power Resources team. This hands-on role combines 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.

Qualifications

• 3–5 years of full-time professional data analytics experience with relevant skills.
• Bachelor's degree in a technical/quantitative field.
• Advanced degree preferred but not required.

Responsibilities

• Develop and optimize SQL queries and data models.
• Maintain databases, schemas, tables, functions, and views.
• Design and maintain ETL pipelines and automated data flows.
• Create dashboards and KPI reports for Power Resources.
• Analyze hourly to annual energy load and resource data.
• Present findings to technical and non-technical stakeholders.

Skills

Complex SQL & data modeling

Relational databases

ETL pipelines

Python

Git / GitHub

Windows & Linux

BI & data visualization

Excel

Education

Bachelors in Computer Science/Data Science/Math/Stat/Engineering/Physical/Natural Science

Tools

Grafana

R / RStudio

Java

AWS

SharePoint

EDRMS

SCADA

Energy reporting systems

Job description

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 analyze data used for energy settlements with counterparties and reconciliation reporting.
• Create dashboards, visualizations, KPI reports, and recurring and ad‑hoc reporting.
• Perform statistical modeling and analysis of structured and unstructured datasets to identify trends and meaningful insights.
• Work with large time‑series datasets collected from internal and external sources.
• Partner with end users to understand business needs, document technical requirements, and develop effective data and reporting solutions.
• Present analytical findings and recommendations to technical and non‑technical stakeholders.
• Participate in cross‑functional initiatives focused on improving systems, workflows, controls, and reporting.
• Provide cross‑training and backup support for other Power Resources analytics functions.

Occasional work outside normal business hours may be required to support emergency restoration activities, critical operational needs, or special projects.

Required Technical Skills

We’re looking for candidates with demonstrated professional experience in the following areas:

• Complex SQL query development and optimization
• Relational database management systems (RDBMS), including schemas, tables, functions, and views
• ETL tools and automated data pipelines, including building, scheduling, maintaining, and refining pipelines
• Python and object‑oriented programming
• Git/GitHub or comparable version control
• Windows and Linux environments
• Business Intelligence and data visualization
• Microsoft Excel
• Microsoft Office applications

**Applicants should expect a technical assessment covering the core required skills during the interview process.

Preferred Experience & Technologies

Experience with any of the following will help you stand out:

• Grafana
• R / RStudio
• Java
• AWS, cloud computing, and cloud storage
• Microsoft SharePoint
• Electronic document and records management systems (EDRMS)
• Electric utility or broader energy industry experience
• Power or energy market analytics
• Electric load and resource data
• Energy settlements and reconciliations
• SCADA
• Energy or financial reporting systems

Education & Experience

• Bachelor's degree in Computer Science, Data Science, Mathematics, Statistics, Engineering, Physical Science, Natural Science, or a related technical or quantitative field.
• 3–5 years of full‑time professional experience as a Data Analyst or in a similar technical data role with experience across the required technical skill areas.
• An advanced degree in a related field is preferred but not required.
• Other combinations of education and relevant experience demonstrating the required knowledge, skills, and abilities may also be considered.

Northern Wasco County PUD offers a comprehensive benefits package designed to support employees and their families, including:

• 100% employer-paid Medical/Rx/Dental premiums for individual and/or family coverage
• 100% employer-paid Vision premiums for individual and/or family coverage
• 401(k): 7.5% base employer contribution + up to a 7.5% employer match
• Generous PTO accrual
• 11 paid holidays
• Employer-paid basic life insurance equal to 2x annual salary
• HRA VEBA
• Employer-funded wellness incentive to HRA VEBA
• 100% employer-paid business travel insurance
• Additional voluntary benefits

Bring Your Data Skills to the Energy Industry

You don't necessarily need to come from an electric utility to make an impact here. If you have strong hands‑on experience with SQL, Python, databases, ETL/data pipelines, and business intelligence and are interested in applying those skills to complex energy and operational data, we'd like to hear from you.

Join Northern Wasco County PUD and put your technical expertise to work supporting reliable electric service and the communities we serve.