Data Analytics Engineer — Build Canonical Data & Dashboards

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

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.