Founding Data Analytics Engineer
Broccoli AI3 months ago
San Francisco, CA, USAMid Level / Senior
Responsibilities
- Build and operate reliable ingestion pipelines from multiple sources into ClickHouse.
- Model raw feeds into clean, documented tables, including cross-source entity resolution.
- Create canonical views and metric definitions as a source of truth for dashboards and analyses.
- Structure data models, definitions, and documentation for human and AI querying, and build internal data-question tools.
- Implement freshness checks, data-quality tests, and alerts for broken pipelines.
- Conduct ad hoc analyses, segment investigations, and partner-focused data deep dives.
- Collaborate with engineering on schemas, events, system architecture, and upstream data changes.
Requirements
- 4–8+ years of experience in data or analytics engineering, including operating production pipelines end to end.
- Strong SQL and solid Python skills.
- Hands-on experience with ETL tooling such as Airbyte, Fivetran, Dagster, dbt, or hand-rolled solutions, plus orchestration.
- Experience with a columnar or OLAP warehouse; ClickHouse is preferred, while BigQuery, Snowflake, or Redshift are acceptable.
- Experience designing data models and tables for other people to query, with attention to metric meaning and data quality.
- Experience as a first or only data hire or building a data platform from scratch is a plus.
- ClickHouse materialized views and performance-tuning experience is a plus.
- Multi-source identity or entity-resolution experience is a plus.
- Customer-facing or multi-tenant analytics experience, including customer-level data isolation, is a plus.
- B2B SaaS operational data or CRM and field-service data experience, including ServiceTitan, is a plus.
Categories
Data Engineering
About Broccoli AI
Broccoli AI builds AI voice assistants and agents for home service businesses that answer calls, book jobs, and follow up with customers. Its product integrates with platforms like ServiceTitan to replace fragmented front-office workflows for plumbing, HVAC, and electrical contractors. The privately held company is headquartered in San Francisco, and hundreds of contractors use Broccoli to run their front office.