Skip to main content

Broccoli AI

Data Analytics Engineer

San FranciscofulltimemidAdded today

About this role

Broccoli AI seeks a Data Analytics Engineer to build the unified data layer powering customer dashboards and internal analytics. You'll design data pipelines, create canonical metric definitions, and establish the source-of-truth infrastructure for a rapidly growing AI-driven platform serving home service contractors.

What you'll do

  • Build and maintain reliable data pipelines ingesting from multiple sources into ClickHouse with chosen tooling and orchestration
  • Design and model clean, documented tables including entity resolution across billing, support, and call data
  • Create canonical metric definitions and source-of-truth libraries that all dashboards and analyses depend on
  • Implement data quality tests, freshness checks, and alerts to catch pipeline failures proactively
  • Collaborate with engineering on data architecture, schemas, and event design to ensure warehouse data is stable and usable
  • Execute ad-hoc analyses, customer investigations, and deep dives supporting Strategy & Ops decisions

What they're looking for

  • SQL and Python
  • ETL tooling (Airbyte, Fivetran, Dagster, dbt, or custom)
  • Data orchestration and workflow management
  • OLAP/columnar warehouse architecture (ClickHouse preferred)
  • Data modeling and dimensional design
  • Entity resolution and identity management
  • Data quality testing and monitoring
  • Multi-tenant or customer-facing analytics design
Apply with Autofill

Opens the application — the Jobs AI extension fills it for you. Set up autofill

Opens the official application on the employer’s site. No login required.

Broccoli AI

Broccoli AI builds AI-powered operating systems that automate front-office operations for home service contractors, handling workflows like job booking, customer follow-ups, and dispatch. The company is hiring Software Engineers to develop core product features and growth infrastructure that drive customer acquisition and retention.

View all jobs at Broccoli AI

Likely interview questions

  • Walk us through a production data pipeline you built end-to-end — what sources did you integrate, and how did you handle failures or data quality issues?
  • Describe your experience with ClickHouse or another columnar warehouse — what performance optimization techniques have you applied, and why would you choose it over alternatives?
Unlock all 7 questions free — and practice them live →