# Data Analytics Engineer

**Company:** [Broccoli AI](https://hotfix.jobs/companies/broccoli-ai)
**Location:** San Francisco, CA
**Role:** Data Engineering
**Experience:** 4+ years
**Skills:** SQL, Python, ETL, airbyte, Fivetran, Dagster, dbt, ClickHouse, BigQuery, Snowflake, Redshift, Data Modeling, entity resolution
**Posted:** 2026-07-29

> Build and own the unified data layer and source-of-truth models for a fast-growing AI platform serving home service contractors. Design production pipelines into ClickHouse, create canonical metric definitions, ensure data quality and trustworthiness for customer dashboards, internal analytics, and AI agents.

## Job Description

## What you'll do
- Build and run the pipelines. Reliable ingestion from all our sources into ClickHouse — you choose the tooling and own the flow.
- Model the data. Turn raw feeds into clean, documented tables — including entity resolution, so a customer is the same customer across billing, support, and call data.
- Build the source-of-truth library. Canonical views and metric definitions that every dashboard and analysis reads from.
- Make the data Human & AI-ready. Structure our models, definitions, and documentation so both people and AI agents can query them and get the right answer — then build the internal tools that let anyone at Broccoli ask a data question and trust the response.
- Keep it trustworthy. Freshness checks, quality tests, and alerts — we find out a pipeline broke before a customer does.
- Run deep dives when the team needs them. Ad-hoc analyses, segment investigations, partner questions.
- Work closely with engineering. Understand how our systems store and produce data, including schemas, events, and architecture, and give input early on changes so the data that lands in the warehouse is usable, stable, and easy to model.

## What we're looking for
- 4–8+ years in data or analytics engineering — you've built and operated production pipelines end to end, and been the one paged when they broke.
- Strong SQL and solid Python; hands-on with ETL tooling (Airbyte, Fivetran, Dagster, dbt, or hand-rolled) and orchestration.
- Real experience with a columnar/OLAP warehouse — ClickHouse ideally; BigQuery, Snowflake, or Redshift transfer fine.
- Data modeling as a craft: you've designed the tables other people query, and you care what the numbers mean, not just that the pipes run.

## Nice to have
- Self-directed: you've been the first or only data person somewhere, or built a data platform from scratch.
- ClickHouse specifically — materialized views, performance tuning on event-scale data.
- Multi-source identity / entity resolution experience.
- Exposure to customer-facing or multi-tenant analytics (strict customer-level data isolation).
- B2B SaaS operational data — calls, bookings, jobs, billing — or CRM/field-service data like ServiceTitan.

## Similar roles

- [Software Engineer, Robotics Data](https://hotfix.jobs/jobs/c68e72f3-b1c5-46e6-8bb6-878c4711ab8f) - Mercor - San Francisco, CA - $130k – $500k/yr
- [Hardware Analytics Engineer](https://hotfix.jobs/jobs/3525e0bf-1a95-4a6b-93e1-eeee565a6c17) - Cerebras Systems - Sunnyvale, CA - $214k – $225k/yr
- [Software Engineer, Reconciliation & Reporting](https://hotfix.jobs/jobs/dfa344bb-be58-4834-a0c4-8955a6fdea83) - Square - California - $121k – $213k/yr
- [Software Engineer](https://hotfix.jobs/jobs/f15bf869-549d-42fd-b363-35be6fd503e4) - OpenAI - San Francisco, CA - $255k – $405k/yr
- [Software Engineer, Fleet Simulation](https://hotfix.jobs/jobs/531a4fbc-f1c7-4615-b321-8ca4875c523a) - Zoox - Foster City, CA - $191k – $266k/yr

**Apply:** https://hotfix.jobs/jobs/d009e80b-8551-42f8-8971-d2d3f0a8f417
**Canonical:** https://hotfix.jobs/jobs/d009e80b-8551-42f8-8971-d2d3f0a8f417