ROI Agency
ROI Agency
51 – 200 Darbuotojai
B2BRinkodara
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.

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.

Aprašymas

  • 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

Reikalavimai

  • 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

Privalumai

  • 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

Susiję darbai

BDR Solutions LLC

Data Analyst, Railroad Safety Data (Hybrid, Washington, DC)

BDR Solutions LLC

Process railroad safety submissions for BDR Solutions, a federal government support contractor. Validate records, maintain RIRS and GCIS data, and provide Help Desk coverage.

Atidaryti
The Church of Jesus Christ of Latter-day Saints

Finance and Records Data Analyst III

The Church of Jesus Christ of Latter-day Saints

Connect finance and records data across multiple systems to create dependable dashboards, reports, and insights. Help Church leaders make informed decisions through clear analysis.

Atidaryti
U.S. Bank

Reporting and Analytics Analyst

U.S. Bank

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.

Atidaryti
Genworth