Data Analytics Engineer

Broccoli AI; San Francisco (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

Broccoli AI in San Francisco, CA, seeks a Data Analytics Engineer to own the unified data layer, transform raw feeds into clean, well-documented tables, and establish the canonical source of truth for customer dashboards and product analytics.

You will build and operate data pipelines feeding ClickHouse, model data with strong entity resolution, and create a robust source-of-truth library used by dashboards and AI queries.

Qualifications

• 4 to 8+ years in data or analytics engineering; hands-on experience building and operating production pipelines end to end.
• Strong SQL and Python skills with hands-on experience in ETL tooling and orchestration.
• Direct experience with a columnar data warehouse; ClickHouse preferred; transferable to BigQuery, Snowflake, or Redshift.
• Data modeling as a craft: designing tables that others query and understand the meaning behind the numbers.

Responsibilities

• Build and run data pipelines to ensure reliable ingestion from all sources into ClickHouse, selecting tooling and owning the end-to-end flow.
• Model the data by turning raw feeds into clean, documented tables, including entity resolution across billing, support, and call data.
• Develop the source-of-truth library with canonical views and metric definitions for dashboards and analytics.
• Make data human and AI ready by structuring models, definitions, and documentation for querying and trusted AI responses.
• Maintain trustworthiness through freshness checks, quality tests, and alerts to catch issues before customers are affected.
• Perform deep dives for ad-hoc analyses, segment investigations, and partner questions.
• Collaborate with engineering to understand data storage, schemas, events, and architecture for stable, usable landed data.

Skills

SQL

Python

Data modeling

ClickHouse

Data pipelines

Tools

Airbyte

Fivetran

Dagster

dbt

Job description

The Data Analytics Engineer will own the unified data layer, transform raw feeds into clean, well documented tables, and establish the canonical source of truth for customer dashboards and product analytics as Broccoli AI's first dedicated data hire. This onsite role is based in San Francisco, CA.

Responsibilities

• Build and run data pipelines to ensure reliable ingestion from all sources into ClickHouse, selecting tooling and owning the end-to-end flow.
• Model the data by turning raw feeds into clean, documented tables, including entity resolution so a customer is consistently identified across billing, support, and call data.
• Develop the source-of-truth library with canonical views and metric definitions that underpin every dashboard and analysis.
• Make data human and AI ready by structuring models, definitions, and documentation so both people and AI agents can query them and obtain correct results; build internal tools to enable Broccoli to ask data questions with trusted responses.
• Maintain trustworthiness through freshness checks, quality tests, and alerts to catch issues before customers are affected.
• Perform deep dives as needed for ad-hoc analyses, segment investigations, and partner questions.
• Collaborate closely with engineering to understand data storage, schemas, events, and architecture, and provide early input to ensure landed data is usable, stable, and easy to model.

Requirements

• 4 to 8+ years in data or analytics engineering, with hands‑on experience building and operating production pipelines end to end and a history of being paged for incidents.
• Strong SQL and Python skills, with hands‑on experience in ETL tooling (Airbyte, Fivetran, Dagster, dbt, or custom solutions) and orchestration.
• Direct experience with a columnar data warehouse; ClickHouse preferred, with transferability to BigQuery, Snowflake, or Redshift.
• Data modeling as a craft: you have designed tables that others query and care about the meaning behind the numbers, not solely the flow of data.

Technologies

SQL, Python, Airbyte, Fivetran, Dagster, dbt, ClickHouse, BigQuery, Snowflake, Redshift

About Broccoli

Broccoli serves hundreds of contractors through its front office platform. The company has grown from zero to multi‑million ARR in under a year and earns the trust of both single‑location operators and the largest PE‑backed roll‑ups. Broccoli has raised over 25 million dollars from Khosla Ventures and Y Combinator.