Energy Data Analyst I

Northern Wasco County PUD • The Dalles, OR

7d • $80,851 - $121,277 • Onsite

About The Position

Northern Wasco County PUD is seeking an experienced Energy Data Analyst I to join our growing Power Resources team. This full-time, exempt position offers a Monday – Friday 5/8 schedule. The Energy Data Analyst I serves as a data and analytics resource to the Power Resources Department, with a focus in energy supply analytics. Develops and maintains databases, software, and automated data pipelines supporting critical Power Resources data. Builds complex SQL queries, ETL workflows, and dashboards; compiles and distributes KPI and reconciliation reports; and supports virtual server environments. Analyzes electric load and resource data (hourly through annual) related to settlements with counterparties and organizes data for settlement and reconciliation reporting. Supports end users to define requirements, deliver reporting and analytics solutions, and communicate findings and recommendations to support decision-making.

Requirements

• 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
• 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
• 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.

Nice To Haves

• Experience supporting an electric utility, energy market analytics, creating data displays and dashboards, settlements/reconciliations, SCADA, or energy/financial reporting systems is preferred.
• PostgreSQL/pgAdmin
• Apache NiFi
• Grafana
• R/RStudio
• Java
• cloud storage/cloud computing solutions
• Microsoft SharePoint

Responsibilities

• 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.
• Participate in cross-functional initiatives and special projects to improve systems, workflows, controls, and reporting.
• Maintain confidentiality of sensitive information and exercise professional judgment and discretion.
• Demonstrates cultural competency through respectful, inclusive work habits and through the valuing and welcoming of cultural differences in all position responsibilities.
• Supports the District’s mission to serve our customers and foster a safe and positive work environment by personally exhibiting behavior that aligns with the District’s Core Values & Beliefs.
• Must perform the duties of this position in a safe and efficient manner and follow all safety regulations and protocols.
• Other duties as assigned.
• Serve as backup support for Data Analyst II or other future scoped analytics role reducing single points of failure.
• Performs other Power Resources Department duties in the absence of other assigned personnel, or as needed.
• All PUD employees are expected to work outside of normal business hours when required during emergency restoration activities and to accomplish other special projects.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level