Northern Wasco County People's Utility District

Data Analyst

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

Energy Data Analyst I