LogoFresh Jobs Ahead
ROI Agency
ROI Agency
51 – 200 Employees
B2BMarketing
ROI Agency is a growth marketing company combining data analysis and creative work to help businesses grow revenue sustainably. Its approach centers on setting measurable KPIs and specific performance guarantees for client growth strategies. Founded in 2017, the company works in B2B marketing.
LinkedIn
Company Jobs

Energy Data Analyst

Build SQL, Python, ETL, and business intelligence systems for a public electric utility. Analyze power markets, electric resources, settlements, and operational data.

USUnited StatesAZArizonaIDIdahoMTMontanaOROregonUTUtahWAWashingtonHybridFull-timeMiddleSeniorEnglish RequiredData Analyst
ETLLinuxPythonSQL

Description

  • Develop and refine complex SQL queries and data models
  • Maintain relational databases, including schemas, tables, functions, and views
  • Build, schedule, and support ETL processes and continuously automated data pipelines
  • Investigate data quality, availability, integration, and performance problems
  • Create and maintain software, APIs, integrations, and reporting tools for Power Resources data
  • Analyze electric load and resource data across hourly, daily, weekly, monthly, and yearly periods
  • Monitor power markets and deliver analysis for operations, planning, and decisions
  • Prepare, validate, and analyze data for energy settlements and reconciliation reports
  • Build dashboards, visualizations, KPI reports, and recurring or one-off reports
  • Apply statistical methods to structured and unstructured data
  • Work with large time-series datasets from internal and external sources
  • Collaborate with users to clarify business needs, capture technical requirements, and deliver data and reporting solutions
  • Explain findings and recommendations to technical and non-technical audiences
  • Contribute to cross-team efforts to improve systems, workflows, controls, and reporting
  • Cross-train and provide backup for other Power Resources analytics functions

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
  • Proven ability to develop and optimize complex SQL queries
  • Experience with relational database systems, including schemas, tables, functions, and views
  • Experience building, scheduling, maintaining, and improving ETL tools and automated data pipelines
  • Python and object-oriented programming skills
  • Experience with Git, GitHub, or similar version control tools
  • Experience working in Windows and Linux environments
  • Business intelligence and data visualization experience
  • Microsoft Excel skills
  • Proficiency with Microsoft Office applications
  • Willingness and ability to travel occasionally to the Northern Wasco County PUD office in The Dalles, Oregon
  • Ability to live in Oregon, Washington, Idaho, Arizona, Utah, or Montana
  • Completion of an interview-stage technical assessment covering core required skills
  • Availability for occasional work outside regular business hours during emergency restoration, critical operational needs, or special projects

Benefits

  • Medical, prescription, and dental premiums fully paid by the employer for individual and/or family coverage
  • Vision premiums fully paid by the employer for individual and/or family coverage
  • 401(k) with a 7.5% employer base contribution and up to a 7.5% employer match
  • 457(b) retirement plan
  • Generous paid time off accrual
  • 11 paid holidays
  • Employer-paid basic life insurance equal to twice annual salary
  • Short-term disability coverage fully paid by the employer
  • Long-term disability coverage fully paid by the employer
  • HRA VEBA
  • Employer-funded wellness incentive deposited to HRA VEBA
  • Business travel insurance fully paid by the employer
  • Additional voluntary benefits
  • Primarily remote work arrangement
  • Top Workplaces recognition

Related Jobs

U.S. Bank

Reporting and Analytics Analyst

U.S. Bank
ConsultingInsuranceLogistics
USUnited StatesAZArizonaCACaliforniaCOColoradoILIllinoisKYKentuckyMAMassachusettsMNMinnesotaMOMissouriNYNew YorkNCNorth CarolinaOHOhioOROregonPAPennsylvaniaTXTexasWIWisconsin
$119,765 – $140,900 / year
HybridFull-timeMiddleSeniorEnglish RequiredData Analyst
AzureCloudETLPythonSQLTableau

Modernize U.S. Bank’s reporting and analytics across Salesforce, Tableau, Snowflake, and Databricks. Build cloud data solutions and deliver actionable insights for banking teams.

Open
Genworth

Hybrid Data Analyst at Genworth

Genworth
1,001 – 5,000 Employees
H1B Visa SponsorFinanceHealthcare InsuranceInsurance
USUnited StatesALAlabamaCTConnecticutFLFloridaILIllinoisIAIowaKSKansasKYKentuckyLALouisianaMEMaineMDMarylandMAMassachusettsMIMichiganMNMinnesotaMSMississippiMOMissouriNENebraskaNHNew HampshireNJNew JerseyNYNew YorkNCNorth CarolinaNDNorth DakotaOHOhioOKOklahomaPAPennsylvaniaRIRhode IslandSCSouth CarolinaSDSouth DakotaTNTennesseeTXTexasVTVermontVAVirginiaWAWashingtonWVWest VirginiaWIWisconsin
$68,900 – $103,000 / year
HybridFull-timeJuniorMiddleEnglish RequiredData Analyst
PythonServiceNowSQL

Manage SQL data requests and reporting for Genworth and CareScout’s aging-care services. Build Power BI dashboards and streamline analytics to improve operational visibility.

Open