LogoFresh Jobs Ahead
ROI Agency
ROI Agency
51 – 200 Angajați
B2BMarketing
ROI Agency este o companie de marketing pentru creștere care combină analiza datelor și munca creativă pentru a ajuta companiile să își majoreze veniturile în mod sustenabil. Abordarea sa se bazează pe stabilirea unor indicatori-cheie de performanță măsurabili și a unor garanții de performanță specifice pentru strategiile de creștere ale clienților. Compania a fost fondată în 2017 și activează în marketingul B2B.
LinkedIn
Locurile de muncă ale companiei

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.

USStatele Unite ale AmericiiAZArizonaIDIdahoMTMontanaOROregonUTUtahWAWashingtonHibridNormă întreagăNivel mediuSeniorLimbă Obligatorie: englezăAnalist de date
ETLLinuxPythonSQL

Descriere

  • 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

Cerințe

  • 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

Beneficii

  • 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

Locuri de muncă similare

U.S. Bank

Reporting and Analytics Analyst

U.S. Bank
AsigurăriConsultanțăLogistică
USStatele Unite ale AmericiiAZArizonaCACaliforniaCOColoradoILIllinoisKYKentuckyMAMassachusettsMNMinnesotaMOMissouriNYNew YorkNCCarolina de NordOHOhioOROregonPAPennsylvaniaTXTexasWIWisconsin
119.765 $ – 140.900 $ / an
HibridNormă întreagăNivel mediuSeniorLimbă Obligatorie: englezăAnalist de date
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.

Deschide
Genworth

Hybrid Data Analyst at Genworth

Genworth
1.001 – 5.000 Angajați
Sponsor pentru viza H1BAsigurare de sănătateAsigurăriFinanțe
USStatele Unite ale AmericiiALAlabamaCTConnecticutFLFloridaILIllinoisIAIowaKSKansasKYKentuckyLALouisianaMEMaineMDMarylandMAMassachusettsMIMichiganMNMinnesotaMSMississippiMOMissouriNENebraskaNHNew HampshireNJNew JerseyNYNew YorkNCCarolina de NordNDDakota de NordOHOhioOKOklahomaPAPennsylvaniaRIRhode IslandSCCarolina de SudSDDakota de SudTNTennesseeTXTexasVTVermontVAVirginiaWAWashingtonWVVirginia de VestWIWisconsin
68.900 $ – 103.000 $ / an
HibridNormă întreagăJuniorNivel mediuLimbă Obligatorie: englezăAnalist de date
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.

Deschide