Data Analytics Engineer
Airbyte
Analytics
Bigquery
Clickhouse
Cloud
Cloud Platform
Cloud Platforms
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
ETL
Fivetran
Reporting and Analytics
SQL
Job Description
This onsite role in San Francisco, CA, places you as the first dedicated data hire at Broccoli AI. You will own the unified data layer, transform raw feeds into clean tables, and establish the canonical source of truth that powers customer dashboards and product analytics.
Responsibilities
- Design and operate end-to end data pipelines to reliably ingest data from all sources into ClickHouse, selecting the right tooling and owning the data flow.
- Model the data by converting raw feeds into well documented, clean tables, including entity resolution so that 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 all dashboards and analyses.
- Prepare data for both human analysts and AI systems by structuring models, definitions, and documentation so queries return accurate results; build internal tools for trusted data questioning.
- Maintain trust in the data with freshness checks, quality tests, and alerting to catch pipeline issues before customers are impacted.
- Perform ad hoc analyses and deep dives when the team requires segment investigations or responses to partner questions.
- Collaborate closely with engineering to understand data storage, schemas, events, and architectural decisions, and provide early input to ensure data that lands in the warehouse is usable and stable.
Requirements
- 4 to 8 plus years in data or analytics engineering, with hands-on experience building and operating production pipelines end to end and handling incidents when they occur.
- Strong SQL and Python skills, with practical experience using ETL tooling (Airbyte, Fivetran, Dagster, dbt, or custom solutions) and orchestration.
- Working with a columnar OLAP data warehouse is essential; experience with ClickHouse is preferred, with transfer experience in BigQuery, Snowflake, or Redshift acceptable.
- Data modeling as a craft: you have designed tables that others rely on and you care about the meaning of the numbers, not only the data flows.
Technologies
- SQL
- Python
- Airbyte
- Fivetran
- Dagster
- dbt
- ClickHouse
- BigQuery
- Snowflake
- Redshift
About Broccoli
- Hundreds of contractors rely on Broccoli to run their front office operations.
- The company has grown from zero to millions in ARR in under a year.
- Broccoli serves both single-location operators and the largest PE-backed roll-ups.
- Funding includes more than $25 million raised from Khosla Ventures and Y Combinator.
Similar Jobs
