Senior Data Engineer, C&I

Apply Here

Countries
Remote, USA
Job Types
software & tech
Experience
late
Organization Types
climate & sustainability
Location
USA - Remote
Posted Date
Company
EnergyHub

AI Summary

Job Description

Lead design and delivery of large, loosely scoped data engineering projects on the C&I measurement and verification platform, taking raw meter data through baselines, event performance and payments to reports operations teams rely on. Break complex problems into well-scoped work, drive technical direction for the Snowflake and dbt codebase, own production pipeline health, ensure payment outputs are accurate and explainable, and strengthen the team through code review, documentation and pairing.

Hard Requirements

  • Professional experience designing, building and operating production data pipelines
  • Advanced SQL with strong dbt experience in a layered project, including incremental models and backfills
  • Track record of making pipelines faster and cheaper on Snowflake or a comparable cloud warehouse
  • Strong data modeling: choosing the right grain, keeping history of changing data/configuration, reproducible results
  • Strong Python for data work, including pandas and numpy
  • Experience with time-series or event-based data (meter/sensor readings) and associated data quality issues
  • Hands-on experience with automated testing (dbt unit and data tests, pytest), CI/CD, and pipeline monitoring and alerting
  • Experience choosing among architectural approaches and tradeoffs with well-founded opinions
  • Clear written and verbal communication; documenting initiatives and explaining concepts to technical and non-technical audiences
  • History of taking ownership of problems with no clear owner; enjoys pairing, teaching and learning
  • Warmth and welcome for collaborators and colleagues

Soft Requirements

  • 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, 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 settings where data drives billing or payments
  • Experience leading a migration or long-running initiative spanning teams

Browse all urbanism jobs