Data Analyst

Summary

Northern Wasco County PUD is a public electric utility serving the communities of Northern Wasco County. The Energy Data Analyst I will develop and maintain databases, software, automated data pipelines, integrations, dashboards, and reporting solutions supporting Power Resources operations and decision-making. The role will analyze electric load, resource, power market, settlement, reconciliation, and other operational data while presenting insights to stakeholders.

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

Skills

• **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
• * **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
• * 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
• * Other combinations of education and relevant experience demonstrating the required knowledge, skills, and abilities may also be considered
• **Previous electric utility or energy industry experience is preferred but not required.**
• * PostgreSQL / pgAdmin
• * 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
• * Large time-series datasets
• * An advanced degree in a related field is preferred but not required

Qualifications

Must Haves

• **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
• * **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
• * 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
• * Other combinations of education and relevant experience demonstrating the required knowledge, skills, and abilities may also be considered

Nice to Haves

• **Previous electric utility or energy industry experience is preferred but not required.**
• * PostgreSQL / pgAdmin
• * 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
• * Large time-series datasets
• * An advanced degree in a related field is preferred but not required

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