Senior Data Engineer, C&I

EnergyHub

Where
Remote - United States
Pay
$130K to $170K a year

Posted 1 day ago· Checked live at EnergyHub 27 minutes ago

Talent poolAn always-open posting that collects resumes. There may be no real opening behind it.

See how you score for this job

One sentence and your resume. We score it against what EnergyHub asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on EnergyHub's own hiring page 27 minutes ago.
What is the job?
The Commercial & Industrial Team facilitates the management of our non-residential demand response programs, where businesses such as factories, offices and retail sites reduce their energy use when the grid needs it. These programs cover some of our largest customers and programs by flexible grid capacity.
What does it pay?
$130K to $170K a year, as the posting states.
Our verdict
Talent pool. An always-open posting that collects resumes. There may be no real opening behind it.

What the job is

The Commercial & Industrial Team facilitates the management of our non-residential demand response programs, where businesses such as factories, offices and retail sites reduce their energy use when the grid needs it. These programs cover some of our largest customers and programs by flexible grid capacity.

Main Responsibilities: What you’ll do

  • Lead the design and delivery of large, loosely scoped data engineering projects on the C&I measurement and verification (M&V) platform. That pipeline takes raw meter data through baselines, event performance and payments to the reports our operations teams and partners rely on
  • Break complex, ambiguous problems into well-scoped tracks of work that your teammates can pick up. Roadmap them with reliable estimates of time, effort and risk
  • Help tackle tech debt and collaborate to drive the technical direction for the team’s Snowflake and dbt codebase: layering and model design, incremental processing, Python in the warehouse, and the orchestration and CI that support them
  • Own the health of our production pipelines. Strengthen data tests, monitoring and alerting, troubleshoot and resolve incidents (including on-call support), and cut tech debt and build times along the way
  • Make sure payment and performance outputs are accurate and explainable, working closely with product, operations and customer-facing teams to turn program rules into correct, maintainable logic
  • Make the team better through thoughtful code review, documentation and pairing. Teach what you know, learn from teammates at every level, and help the team’s practices improve
  • Tech stack: Snowflake, dbt, Python, SQL, AWS (S3), MongoDB, GitHub Actions
  • Other duties as assigned

Required Skills and Experience: What you need

  • First and foremost, you sincerely love data and all the things it can enable and empower
  • Professional experience designing, building and operating production data pipelines, with a track record of leading projects from ambiguous idea to successful release
  • Advanced SQL, with strong dbt experience in a layered (staging, intermediate, marts) project. That includes incremental models that stay correct when data arrives late, changes or is deleted, and backfills you can run with confidence
  • A track record of making slow or expensive pipelines faster and cheaper on Snowflake or a comparable cloud warehouse, by reading query profiles, choosing the right materializations
  • Strong data modeling: choosing the right grain, keeping the history of data and configuration that change over time, and producing results that can be reproduced and explained months later
  • Strong Python for data work, including pandas and numpy
  • Experience with time-series or event-based data, such as meter or sensor readings, and with the data quality issues that come with it (gaps, duplicates, late arrivals, time zones)
  • Hands-on experience with automated testing (for example dbt unit and data tests, pytest), CI/CD, and monitoring and alerting for pipeline health. You use them to change existing pipelines in small, safe steps and show that outputs only changed where you meant them to
  • Experience choosing among architectural approaches and tradeoffs, with strong, well-founded opinions you hold with an open mind
  • Clear written and verbal communication: you document larger initiatives, explain technical concepts to technical and non-technical audiences, and give and receive feedback with empathy
  • A history of taking ownership of problems that have no clear owner. You enjoy pairing, and you teach and learn from teammates at every level
  • Warmth and welcome for your collaborators and colleagues, with an urge to help them succeed

Preferred Skills and Experience: Nice-to-haves

  • Snowflake depth beyond SQL: Python UDTFs and stored procedures, streams and tasks, clustering, warehouse sizing and cost management
  • dbt beyond the basics: custom macros and materializations, cross-project refs and jobs-as-code
  • Experience with semi-structured sources such as MongoDB and file formats like CSV, JSON and Parquet
  • Background in energy, demand response, utilities or other settings where data drives billing or payments
  • Experience leading a migration, or a long-running initiative that spans teams

Company Benefits

EnergyHub offers a generous benefits package including 100% paid medical for employees and a 401(k) with employer match. We offer a casual environment, the flexibility to set your own schedule, a fully stocked fridge and pantry, free Citi Bike membership, secure bike rack, gym subsidy, paid parental leave, and an education assistance program.

Base Salary Range

$130,000 - $170,000 USD

Similar open jobs

Remote data engineer jobs (166)