Data Analyst

ROI Agency • Ward Township, OH

20d • Remote

About The Position

Northern Wasco County PUD is seeking an Energy Data Analyst I to join its Power Resources team. This hands-on technical role combines complex SQL, Python, relational databases, ETL/data pipelines, and business intelligence with energy supply and power market analytics. The analyst will develop and maintain databases, software, automated pipelines, integrations, dashboards, and reporting solutions that support Power Resources data and decision-making. The work includes large time-series datasets involving electric load and resources, power market analytics, energy settlements, reconciliation, and operational reporting.

The position is primarily remote, with occasional travel to the Northern Wasco County PUD office in The Dalles, Oregon, for meetings, projects, or other business needs. Candidates must reside in Oregon, Washington, Idaho, Arizona, Utah, or Montana and be able and willing to travel to the office when required. Occasional work outside normal business hours may be required for emergency restoration activities, critical operational needs, or special projects. Electric utility or energy industry experience is preferred but not required; candidates with technical data analytics experience in other industries are encouraged to apply. Applicants should expect an interview technical assessment covering core required skills.

Requirements

• 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.
• Professional experience developing and optimizing complex SQL queries.
• Professional experience with relational database management systems, including schemas, tables, functions, and views.
• Professional experience with ETL tools and automated data pipelines, including building, scheduling, maintaining, and refining pipelines.
• Professional experience with Python and object-oriented programming.
• Professional experience with Git/GitHub or comparable version control.
• Professional experience in Windows and Linux environments.
• Professional experience with business intelligence and data visualization.
• Professional experience with Microsoft Excel and Microsoft Office applications.
• Must reside in Oregon, Washington, Idaho, Arizona, Utah, or Montana.
• Must be able and willing to travel occasionally to the Northern Wasco County PUD office in The Dalles, Oregon.
• Applicants should expect a technical assessment covering the core required skills during the interview process.

Nice To Haves

• Electric utility or broader energy industry experience.
• Power or energy market analytics experience.
• Experience with electric load and resource data.
• Experience with energy settlements and reconciliations.
• Experience with PostgreSQL / pgAdmin.
• Experience with Grafana.
• Experience with R / RStudio.
• Experience with Java.
• Experience with AWS, cloud computing, and cloud storage.
• Experience with Microsoft SharePoint.
• Experience with electronic document and records management systems (EDRMS).
• Experience with SCADA.
• Experience with energy or financial reporting systems.
• Experience with large time-series datasets.
• An advanced degree in a related field.
• Other combinations of education and relevant experience demonstrating the required knowledge, skills, and abilities may be considered.

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.
• Occasionally work outside normal business hours to support emergency restoration activities, critical operational needs, or special projects.

Benefits

• 100% employer-paid medical, prescription, dental, and vision premiums for employees and their families.
• 401(k) with a 7.5% base employer contribution and up to an additional 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.

What This Job Offers

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