Founding Data Engineer

The role

You will build and own a unified data layer by modeling data into clean, documented tables. You will build pipelines, create a source-of-truth library, and ensure data is ready for both humans and AI agents.

What you will do

• Build and run pipelines for reliable ingestion into ClickHouse.
• Model raw feeds into clean, documented tables including entity resolution.
• Build the source-of-truth library with canonical views and metric definitions.
• Structure models and documentation for human and AI agent querying.
• Build internal tools for data querying.
• Maintain data trustworthiness through freshness checks, quality tests, and alerts.
• Run ad-hoc analyses and deep dives.
• Work with engineering to provide input on schemas, events, and architecture.

Required qualifications

• 4–8+ years in data or analytics engineering.
• Experience building and operating production pipelines end to end.
• 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.
• Data modeling experience designing tables for others to query.

Nice to have

• Self-directed: been the first or only data person 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
• B2B SaaS operational data or CRM/field-service data like ServiceTitan

About the company

Broccoli builds AI teammates for plumbing, HVAC, and electrical contractors to replace fragmented software and manual work. The company has grown to $15M+ ARR in under two years and is backed by Khosla Ventures and Y Combinator.