Broccoli AI Logo

Broccoli AI

Data Analytics Engineer

Posted 9 Days Ago
In-Office
San Francisco, CA, USA
Senior level
In-Office
San Francisco, CA, USA
Senior level
Build and own the unified data layer: ingest pipelines into ClickHouse, model and document canonical tables, define metrics, implement quality/freshness checks, enable human and AI querying, run ad-hoc analyses, and collaborate with engineering and Strategy & Ops to ensure trustworthy analytics for customers and internal dashboards.
The summary above was generated by AI
About Broccoli

At Broccoli, we're building AI teammates for the people who build and maintain our world.

We partner with plumbing, HVAC, and electrical contractors, the hardworking businesses that keep homes and communities running, and replace fragmented software and repetitive manual work with AI that actually gets the job done.

Our AI teammates answer phones, book appointments, follow up with customers, recover missed revenue, and help contractors deliver exceptional customer experiences, all while integrating seamlessly with platforms like ServiceTitan.

Before we wrote a single line of code, we visited more than 140 contractors to understand how these businesses truly operate. That firsthand experience shaped everything we've built.

Today:

  • Hundreds of contractors rely on Broccoli every day.

  • We've grown to $15M+ ARR in under two years.

  • We're trusted by everyone from independent contractors to some of the largest private equity backed operators in the home services industry.

  • We're backed by Khosla Ventures and Y Combinator.

We're still just getting started.

About the role

Our data is rich and comes from many sources. Every customer dashboard, every business review, every metric the company runs on draws from it — and we haven't yet built the unified data layer that makes all of that fast, consistent, and ready to scale.

You'll build that layer and own it. You'll model our data into clean, documented tables and build the source-of-truth library and own the data definitions the whole team runs on. You'll work hand in hand with the Strategy & Ops team — and essentially every tool we build, especially the external-facing dashboards and analytics our customers see, will be built on your work.

You're the team's first dedicated data hire: you own the architecture, the tooling choices, and the trust in every number. What you build powers customer-facing dashboards, cross-customer benchmarks, and eventually the business intelligence we ship inside the product.

What you'll do
  • Build and run the pipelines. Reliable ingestion from all our sources into ClickHouse — you choose the tooling and own the flow.

  • Model the data. Turn raw feeds into clean, documented tables — including entity resolution, so a customer is the same customer across billing, support, and call data.

  • Build the source-of-truth library. Canonical views and metric definitions that every dashboard and analysis reads from.

  • Make the data Human & AI-ready. Structure our models, definitions, and documentation so both people and AI agents can query them and get the right answer — then build the internal tools that let anyone at Broccoli ask a data question and trust the response.

  • Keep it trustworthy. Freshness checks, quality tests, and alerts — we find out a pipeline broke before a customer does.

  • Run deep dives when the team needs them. Ad-hoc analyses, segment investigations, partner questions.

  • Work closely with engineering. Understand how our systems store and produce data, including schemas, events, and architecture, and give input early on changes so the data that lands in the warehouse is usable, stable, and easy to model.

What we're looking for
  • 4–8+ years in data or analytics engineering — you've built and operated production pipelines end to end, and been the one paged when they broke.

  • 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 — ClickHouse ideally; BigQuery, Snowflake, or Redshift transfer fine.

  • Data modeling as a craft: you've designed the tables other people query, and you care what the numbers mean, not just that the pipes run.

Nice to have
  • Self-directed: you've been the first or only data person somewhere, 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 (strict customer-level data isolation).

  • B2B SaaS operational data — calls, bookings, jobs, billing — or CRM/field-service data like ServiceTitan.

HQ

Broccoli AI San Francisco, California, USA Office

300 Brannan St, 405, San Francisco, California, United States, 94107

Similar Jobs

Yesterday
Hybrid
San Francisco, CA, USA
140K-155K Annually
Senior level
140K-155K Annually
Senior level
Information Technology • Database • Consulting
Design, build, and maintain scalable ETL/ELT pipelines and cloud-native analytics infrastructure using Python, PySpark, and SQL. Orchestrate workflows (Airflow/Databricks/Step Functions), implement CI/CD, deploy infrastructure-as-code, ensure data quality, lineage, and regulatory compliance for financial datasets, and collaborate with cross-functional teams to support reporting, risk, and downstream ML use cases.
Top Skills: AirflowAws CloudwatchAws EmrAws GlueAws IamAws LambdaAws RedshiftAws S3Databricks WorkflowsGitGithub ActionsPysparkPythonSQLStep Functions
4 Days Ago
In-Office
Santa Clara, CA, USA
152K-265K Annually
Senior level
152K-265K Annually
Senior level
Artificial Intelligence • Computer Vision • Hardware • Robotics • Metaverse
Lead development of data pipelines, ETL, and analytics for pre- and post-silicon DFT data; apply statistical methods and applied AI/GenAI to solve EDA/DFT problems; design scalable distributed databases; collaborate across teams and mentor junior engineers.
Top Skills: Applied AiAWSAzureC++Data ModelingData VisualizationDftDfxDistributed DatabasesEdaETLGCPGen AiMachine LearningPerlPythonSQLStatistical ToolsTcl
Yesterday
Remote or Hybrid
USA
100K-145K Annually
Mid level
100K-145K Annually
Mid level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Build and maintain cloud cost monitoring, alerting, and optimization tooling. Develop automation, cost allocation/tagging, data pipelines, dashboards, and integrations with billing APIs. Support FinOps processes, implement cost guardrails, troubleshoot cost systems, participate in on-call rotation, and collaborate with senior engineers and product teams to drive cost-efficient infrastructure and reporting.
Top Skills: AWSAzureDockerGCPGitGoPython

What you need to know about the San Francisco Tech Scene

San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.

Key Facts About San Francisco Tech

  • Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Google, Apple, Salesforce, Meta
  • Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
  • Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
  • Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account