Senior Data Engineer, C&I
- 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