Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Analyst role.
Rezi rewrites your resume against ROI Agency's job description. Free.
Tailor your resume to this Data Analyst role.
Rezi rewrites your resume against ROI Agency's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst posting at ROI Agency — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst posting at ROI Agency — free, in seconds.
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.
Responsibilities
- 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.
Requirements
- Demonstrated professional experience in complex SQL query development and optimization.
- Demonstrated professional experience with relational database management systems (RDBMS), including schemas, tables, functions, and views.
- Demonstrated professional experience with ETL tools and automated data pipelines, including building, scheduling, maintaining, and refining pipelines.
- Demonstrated professional experience with Python and object-oriented programming.
- Demonstrated professional experience with Git/GitHub or comparable version control.
- Demonstrated professional experience in Windows and Linux environments.
- Demonstrated professional experience with Business Intelligence and data visualization.
- Demonstrated professional experience with Microsoft Excel.
- Demonstrated professional experience with Microsoft Office applications.
Skills
- SQL
- Python
- Relational databases
- ETL/data pipelines
- Business intelligence
- Git/GitHub
- Windows
- Linux
- Microsoft Excel
- Microsoft Office applications
- PostgreSQL
- Grafana
- R
- Java
- AWS
- Cloud computing
- Cloud storage
- Microsoft SharePoint
- SCADA
Location
- The Dalles, Oregon
Work Type
- Mostly Remote
- Occasional travel to office
Experience Level
- 3–5 years of full-time professional experience as a Data Analyst or in a similar technical data role
Education Level
- Bachelor's degree in Computer Science, Data Science, Mathematics, Statistics, Engineering, Physical Science, Natural Science, or a related technical or quantitative field.
Benefits
- 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
- 457(b) retirement plan
- Generous PTO accrual
- 11 paid holidays
- Employer-paid basic life insurance equal to 2x annual salary
- 100% employer-paid short-term disability
- 100% employer-paid long-term disability
- HRA VEBA
- Employer-funded wellness incentive to HRA VEBA
- 100% employer-paid business travel insurance
- Additional voluntary benefits
About the Company
- Join a public utility recognized as one of The Oregonian’s 2025 Top Workplaces.
- Northern Wasco County PUD offers an exceptional benefits package.
- 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.