About the Role
Build and own the unified data layer that makes customer data fast, consistent, and scalable. Model data into clean, documented tables and establish source-of-truth definitions. Your work will power external-facing dashboards and analytics.
Responsibilities
- Build and run pipelines for reliable data ingestion into ClickHouse, choosing appropriate tooling.
- Model raw data feeds into clean, documented tables, including entity resolution.
- Build a source-of-truth library with canonical views and metric definitions.
- Structure models, definitions, and documentation for Human & AI readiness, enabling trusted data queries.
- Implement freshness checks, quality tests, and alerts to ensure data pipeline reliability.
- Perform ad-hoc analyses, segment investigations, and partner deep dives.
- Collaborate with engineering to understand data production and provide input on system changes for data usability.
Requirements
- 4–8+ years in data or analytics engineering with end-to-end production pipeline experience.
- Proficiency in SQL and Python.
- Hands-on experience with ETL tooling (e.g., Airbyte, Fivetran, Dagster, dbt) and orchestration.
- Experience with columnar/OLAP warehouses (ideally ClickHouse; BigQuery, Snowflake, or Redshift acceptable).
- Demonstrated ability in data modeling, designing tables for others to query.
- Experience as the first or only data person, or building a data platform from scratch.
- Specific experience with ClickHouse, including materialized views and performance tuning.
- Experience with multi-source identity / entity resolution.
- Exposure to customer-facing or multi-tenant analytics with strict data isolation.
- Familiarity with B2B SaaS operational data (calls, bookings, jobs, billing) or CRM/field-service data.
Skills
- SQL
- Python
- ETL tooling
- Data modeling
- ClickHouse
- Entity resolution
- Data pipeline management
- Data warehousing
- Analytics
Experience Level
- 4-8+ years
About the Company
- Broccoli AI is building the AI operating system for home service businesses.
- They work with plumbing, HVAC, and roofing contractors.
- Their AI assistants handle tasks like answering phones, booking jobs, and customer follow-ups.
- Broccoli AI has integrated with systems like ServiceTitan.
- They have direct experience with over 100 contractors.
- Hundreds of contractors use Broccoli AI.
- The company has grown from $0 to millions in ARR in under a year.
- They are trusted by single-location operators and large roll-ups.
- Broccoli AI has raised over $25M from Khosla Ventures and Y Combinator.
