# Founding Data Analytics Engineer

**Company:** [Broccoli AI](https://hotfix.jobs/companies/broccoli-ai)
**Location:** San Francisco, CA
**Role:** Data Engineering
**Experience:** 7+ years
**Skills:** SQL, Python, ClickHouse, Airbyte, Fivetran, Dagster, dbt, BigQuery, Snowflake, Redshift, Data Modeling, Entity Resolution, ETL, Data Orchestration, Data Quality
**Posted:** 2026-08-18

> Build and own the unified data layer powering internal analytics, customer-facing dashboards, benchmarks, and future product intelligence. The role requires production data-pipeline experience, strong SQL and Python, data modeling expertise, and ownership of architecture and data quality.

## Job Description

## Responsibilities
- Build and run reliable ingestion pipelines from all data sources into ClickHouse.
- Model raw feeds into clean, documented tables, including entity resolution across billing, support, and call data.
- Build canonical views and metric definitions as the source of truth for dashboards and analyses.
- Structure data models, definitions, and documentation so people and AI agents can query data accurately.
- Build internal tools for trusted data questions and responses.
- Implement freshness checks, data-quality tests, and alerts.
- Perform ad hoc analyses, segment investigations, and partner analyses.
- Work closely with engineering on schemas, events, architecture, and upstream changes.

## Requirements
- **4–8+ years** of experience in data or analytics engineering.
- Production experience building and operating end-to-end pipelines.
- Strong SQL and solid Python skills.
- Hands-on experience with ETL tooling and orchestration, such as Airbyte, Fivetran, Dagster, dbt, or custom tooling.
- Experience with a columnar or OLAP warehouse; ClickHouse is preferred, with BigQuery, Snowflake, or Redshift also applicable.
- Strong data-modeling skills and experience designing tables for others to query.

## Nice to Have
- Experience as the first or only data hire, or building a data platform from scratch.
- ClickHouse experience, including materialized views and performance tuning on event-scale data.
- Multi-source identity or entity-resolution experience.
- Customer-facing or multi-tenant analytics experience, including strict customer-level data isolation.
- Experience with B2B SaaS operational data, CRM data, or field-service data such as ServiceTitan.

## Similar jobs

- [Engineering Manager, Reference Data](https://hotfix.jobs/jobs/17fe7937-a65b-4fd1-bb4d-255cbac4d600) - Addepar - Remote
- [Senior Data Engineer](https://hotfix.jobs/jobs/87b44df0-4459-4294-af40-945c2cbeaa59) - Alpaca - Remote
- [Senior Database Reliability Engineer II](https://hotfix.jobs/jobs/312b25c1-28c7-4373-b975-fe05277359f7) - NinjaTrader - Remote - $130k – $180k/yr
- [AI Data Readiness Lead](https://hotfix.jobs/jobs/456fe66b-aa42-4f78-a5f7-99231661da49) - Deepgram - Remote - $165k – $220k/yr
- [Senior Analytics Engineer](https://hotfix.jobs/jobs/c6d41b7c-d2cd-4ea9-bf08-1450fcca8aee) - Aleph - Remote - $86k – $192k/yr

**Apply:** https://hotfix.jobs/jobs/2ad99144-4700-42ce-b43f-a14b65d31599
**Canonical:** https://hotfix.jobs/jobs/2ad99144-4700-42ce-b43f-a14b65d31599