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, ETL process design, and data analysis to support power market analytics and reporting. Proficient in utilizing data visualization tools and statistical modeling to provide actionable insights for decision-making.

Highest-signal resume keywords

SQL Query DevelopmentETL Process DesignData AnalysisPython ProgrammingData Visualization

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

SQLETLData ModelingStatistical AnalysisData Pipeline DevelopmentRelational Database ManagementComplex Query OptimizationTime-Series Data AnalysisStatistical ModelingData Quality Troubleshooting

Soft Skills

Analytical ThinkingProblem SolvingCommunicationCollaborationDocumentation

Tools & Technologies

Microsoft ExcelMicrosoft OfficeGit/GitHubBusiness Intelligence ToolsData Visualization SoftwareWindowsLinux

Industry Keywords

Electric UtilityEnergy IndustryPower Market AnalyticsData IntegrationEnergy 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 reporting
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
Occasionally work outside normal business hours for emergency restoration activities, 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 building, scheduling, maintaining, and refining ETL tools and automated data 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 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 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/Rx/Dental premiums for individual and/or family coverage
100% employer-paid Vision premiums for individual and/or family coverage
401(k): 7.5% base employer contribution + up to a 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
Mostly remote work arrangement
Occasional travel to the Northern Wasco County PUD office for meetings, projects, or other business needs