7 hours ago
Remote, United StatesSenior
Base Salary
$130k - $170k/yr
Responsibilities
- Lead the design and delivery of large, loosely scoped data engineering projects for the C&I measurement and verification platform.
- Break ambiguous problems into scoped workstreams and create roadmaps with estimates of time, effort, and risk.
- Drive technical direction for Snowflake and dbt code, including layering, model design, incremental processing, Python in the warehouse, orchestration, and CI.
- Own production pipeline health by strengthening tests, monitoring, alerting, incident response, and on-call practices.
- Ensure payment and performance outputs are accurate, explainable, and maintainable in partnership with product, operations, and customer-facing teams.
- Improve team practices through code review, documentation, pairing, teaching, and technical collaboration.
Requirements
- Professional experience designing, building, and operating production data pipelines, including leading projects from ambiguous ideas through successful release.
- Advanced SQL and strong dbt experience with layered projects, incremental models, late-arriving or changing data, deletions, and reliable backfills.
- Experience optimizing Snowflake or comparable cloud warehouse pipelines using query profiles, materializations, and cost-performance tradeoffs.
- Strong data modeling skills, including selecting grain, preserving changing history and configuration, and producing reproducible and explainable results.
- Strong Python for data work, including pandas and numpy.
- Experience with time-series or event-based data and related data quality issues such as gaps, duplicates, late arrivals, and time zones.
- Hands-on experience with automated testing, CI/CD, monitoring, and alerting for pipeline health.
- Experience evaluating architectural approaches and tradeoffs, communicating clearly, taking ownership of ambiguous problems, and collaborating through pairing and feedback.
- Preferred: advanced Snowflake features such as Python UDTFs, stored procedures, streams, tasks, clustering, warehouse sizing, and cost management.
- Preferred: advanced dbt capabilities including custom macros, custom materializations, cross-project references, and jobs-as-code.
- Preferred: experience with MongoDB, CSV, JSON, and Parquet data sources.
- Preferred: experience in energy, demand response, utilities, billing, or payments, or leading migrations and long-running cross-team initiatives.
Benefits
- 100% employer-paid medical coverage for employees.
- 401(k) with employer match.
- Flexible schedule in a casual work environment.
- Fully stocked fridge and pantry.
- Free Citi Bike membership and secure bike rack.
- Gym subsidy, paid parental leave, and education assistance program.
- Opportunity to work with executives, gain broad business experience, and contribute to clean-energy and climate-impact initiatives.
About EnergyHub
EnergyHub builds a software platform that enables electric utilities to manage distributed energy resources—smart thermostats, EVs, batteries, and more—and deliver demand response and virtual power plant services. The company sells its cloud-based DERMS and grid services to utilities and program partners, providing forecasting, control, and customer engagement tools. Founded in 2007 and headquartered in Brooklyn, New York, EnergyHub is an independent subsidiary of Alarm.com.
