Data Analyst

ROI Agency

. Develop and optimize complex SQL queries and data models .

Posted 9/25/2026full-timeThe Dalles • Oregon • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL query development, relational database management, and ETL processes, while providing analytical insights and reporting solutions for power market operations. Proficient in data visualization and statistical modeling to support decision-making in the energy sector.

Highest-signal resume keywords

SQL Query DevelopmentRelational Database ManagementETL Process DevelopmentData VisualizationStatistical Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonData AnalysisStatistical ModelingData Pipeline DevelopmentData Quality TroubleshootingKPI ReportingData IntegrationAutomated Data PipelinesData Modeling

Soft Skills

Analytical ThinkingProblem SolvingCommunicationCollaborationCross-Training

Tools & Technologies

ETL ToolsMicrosoft ExcelMicrosoft OfficeGit/GitHubBusiness Intelligence Tools

Industry Keywords

Electric UtilityEnergy IndustryPower Market AnalyticsData VisualizationEnergy Settlements

Tech Stack

Tools & technologies

ETLLinuxPythonSQL

About the role

Key responsibilities & impact

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 Power Resources data
Analyze electric load and resource data across hourly, daily, weekly, monthly, and annual periods
Provide power market analytics and monitoring for operations, planning, and decision-making
Organize, validate, and analyze data for energy settlements and reconciliation reporting
Create dashboards, visualizations, KPI reports, and recurring and ad-hoc reports
Perform statistical modeling and analysis of structured and unstructured datasets
Work with large time-series datasets from internal and external sources
Partner with end users to understand business needs, document technical requirements, and develop data and reporting solutions
Present analytical findings and recommendations to technical and non-technical stakeholders
Participate in cross-functional initiatives improving systems, workflows, controls, and reporting
Provide cross-training and backup support for other Power Resources analytics functions
Work occasional hours outside normal business hours for emergency restoration, critical operational needs, or special projects

Requirements

What you’ll need

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
Demonstrated experience with complex SQL query development and optimization
Experience with relational database management systems, including schemas, tables, functions, and views
Experience with 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
Ability and willingness to travel to the Northern Wasco County PUD office in The Dalles, Oregon when required
Applicants should expect a technical assessment covering core required skills during the interview process
Other combinations of education and relevant experience demonstrating the required knowledge, skills, and abilities may be considered
Advanced degree in a related field preferred but not required
Electric utility or energy industry experience preferred but not required

Benefits

Comp & perks

100% employer-paid medical, prescription, dental, and vision premiums for employees and their families
7.5% base employer 401(k) contribution
Up to an additional 7.5% employer 401(k) 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
Primarily remote work arrangement with occasional travel to the office