Energy Data Analyst I

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.

SUMMARY OF BENEFITS: We are proud to offer a comprehensive and very competitive benefits package including but not limited to:

• 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

GENERAL ACCOUNTABILITIES AND ESSENTIAL FUNCTIONS:

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

Secondary Functions:

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

Skills/Knowledge/Abilities:
PLEASE NOTE: This position requires the use of various tools/equipment that are related to performing the essential functions of this job.

• Must-have technical skills: 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.


• Must-have professional skills: 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.


• Preferred Skills: PostgreSQL/pgAdmin; Apache NiFi; Grafana; R/RStudio; Java; cloud storage/cloud computing solutions; Microsoft SharePoint

Supervisory and/or Functional or Technical Responsibility or Oversight:

• No supervisory responsibilities.

QUALIFICATIONS: Recommended Education, Training & Experience (includes licenses or certifications): Other combinations of education and/or experience demonstrating the knowledge, skills, and abilities required to do the work will also be considered.

Education/Experience:

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


• Experience supporting an electric utility, energy market analytics, creating data displays and dashboards, settlements/reconciliations, SCADA, or energy/financial reporting systems is preferred.

Job Scope: 

• Works on complex assignments requiring judgment, analysis, and initiative to identify root causes, develop options, and make recommendations.


• Moves quickly from problem definition to solutions; selects and adapts order, priorities, and work methods while interpreting applicable policies, procedures, and guidelines.


• Work affects data accuracy, reliability, service quality, and operations and may have moderate financial and reputational impact.


• Tasks and information relative to this position are of a confidential and/or sensitive nature requiring strict confidentiality and professional conduct.

Mental or Visual Demand: Concentrated mental and/or visual attention; the work involves performing complex tasks to very close accuracy and quality specifications; or a high degree of hand and eye coordination for sustained periods.

Physical Requirements: Requirements are those consistent with normal office administrative or clerical positions such as sitting, standing, walking, keyboarding. May push up to 50lbs, and/or lift, pull, or carry up to 25lbs. 

Physical Requirements:
Requirements are those consistent with normal office administrative or clerical positions such as sitting, standing, walking, keyboarding. May push up to 50lbs, and/or lift, pull, or carry up to 25lbs. 

This organization believes that each employee makes a significant contribution to our success.  That contribution should not be limited by the assigned responsibilities.  Therefore, this job description is designed to outline primary duties, qualifications, and job scope, but not to limit the incumbent nor the organization to just the work identified.  It is our expectation that each employee will offer their services wherever and whenever necessary to ensure the success of our endeavors. Northern Wasco County PUD reserves the right to revise or change job duties and responsibilities. This job description does not constitute a written or implied contract of employment.

*Northern Wasco County PUD is an Equal Opportunity Employer.