Staff Analytics Engineer

CodeRabbit

Staff Analytics Engineer building the BigQuery and dbt foundation at CodeRabbit. Architecting analytics and revenue models to enhance product engagement and growth.

Posted 6/4/2026full-timeSan Francisco • California, Massachusetts • 🇺🇸 United StatesLead💰 $240,000 - $250,000 per yearWebsite

Tech Stack

Tools & technologies

AWSBigQueryETLGoogle Cloud PlatformSQL

About the role

Key responsibilities & impact

Architect and own CodeRabbit's BigQuery warehouse as the canonical analytical layer, building on the existing GCP and Fivetran foundation and taking it to a governed, investor-grade standard.
Design and ship the dbt project end to end, from raw sources through staging and intermediate models to consumer-facing marts, following modern layering and version-control best practices.
Set the canonical definitions of ARR, NRR, bookings, and lifecycle in the dbt Semantic Layer so BI, Salesforce, and AI agents all read the same number.
Build the canonical revenue models behind CodeRabbit's full billing model: seat subscriptions, usage-based add-ons, and per-marketplace settlement across our marketplace channels (AWS, GCP, Vercel, and others).
Build the identity-resolution spine that resolves a single account and person across product, marketing, billing, and CRM, anchored on stable, system-generated identifiers.
Partner with Growth Engineering to ship the GTM intelligence layer: PQL and PQA scoring, expansion signals, and the single sales-ready queue that reaches reps through reverse ETL and tools like Clay.
Make the warehouse a first-class interface for AI agents, exposing the semantic layer and Agents Schema as the governed source agents query, with PQA scoring trained in BigQuery ML and Vertex AI.
Own data governance, including PII protection and a consent and suppression model that gates downstream activation.
Establish the data practices, definitions, and documentation the company runs on, and serve as the trusted technical partner to Finance, RevOps, Marketing, and Product.

Requirements

What you’ll need

Deep, hands-on analytics engineering experience: expert dbt (project architecture, testing, semantic layer) and strong warehouse fluency, with hands-on BigQuery and GCP a strong plus.
Strong SQL and data modeling judgment: dimensional modeling, grain discipline, and a clear sense of when to compute versus store aggregations.
A track record building the models a revenue team acts on, spanning canonical financial metrics (ARR, NRR, bookings, cohort retention) and the GTM scoring and lifecycle layers that activate through reverse ETL.
An appetite to build AI-native: comfort applying BigQuery ML and Vertex AI to scoring, with a point of view on the semantic layer as the governed interface AI agents query.
Ownership instinct across the full stack, from ingestion config through business logic to reporting, with the judgment to know when to build for now versus build to scale.
Strong written and verbal communication; you can make a metric definition or a modeling tradeoff clear to Finance, GTM leaders, and technical peers alike.
At least 6 years of progressive experience in analytics engineering, data engineering, or a closely related data role, including time as the senior technical owner of a warehouse or dbt project.
Experience with identity resolution across disconnected systems, ideally in a PLG / product-led enterprise (PLE) motion.
Developer-tools or technical B2B SaaS background, and comfort working agent-first with tools like Claude Code.

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account CodeRabbit Website LinkedIn All Job Openings 51 - 200 employees Founded 2023 🤖 Artificial Intelligence ☁️ SaaS 🏢 Enterprise Artificial Intelligence
SaaS
Enterprise CodeRabbit is an advanced AI-powered tool designed to enhance the code review process for development teams. It integrates directly with platforms like GitHub and GitLab, providing instant line-by-line feedback on pull requests, which significantly reduces review times and improves code quality. The tool employs sophisticated algorithms to understand code structure, allowing it to catch bugs and suggest automated fixes while generating meaningful summaries for human reviewers. With a focus on maintaining high standards and efficient workflows, CodeRabbit is engineered to empower teams to ship high-quality software faster, all while ensuring data privacy and security. Staff Analytics Engineer 🔥 1 hour ago 🏢🏡 San Francisco – Hybrid 💵 $240k - $250k / year ⏰ Full Time 🔴 Lead 📊 Analytics Engineer AWS BigQuery ETL Google Cloud Platform SQL Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 Description
Architect and own CodeRabbit's BigQuery warehouse as the canonical analytical layer, building on the existing GCP and Fivetran foundation and taking it to a governed, investor-grade standard.
Design and ship the dbt project end to end, from raw sources through staging and intermediate models to consumer-facing marts, following modern layering and version-control best practices.
Set the canonical definitions of ARR, NRR, bookings, and lifecycle in the dbt Semantic Layer so BI, Salesforce, and AI agents all read the same number.
Build the canonical revenue models behind CodeRabbit's full billing model: seat subscriptions, usage-based add-ons, and per-marketplace settlement across our marketplace channels (AWS, GCP, Vercel, and others).
Build the identity-resolution spine that resolves a single account and person across product, marketing, billing, and CRM, anchored on stable, system-generated identifiers.
Partner with Growth Engineering to ship the GTM intelligence layer: PQL and PQA scoring, expansion signals, and the single sales-ready queue that reaches reps through reverse ETL and tools like Clay.
Make the warehouse a first-class interface for AI agents, exposing the semantic layer and Agents Schema as the governed source agents query, with PQA scoring trained in BigQuery ML and Vertex AI.
Own data governance, including PII protection and a consent and suppression model that gates downstream activation.
Establish the data practices, definitions, and documentation the company runs on, and serve as the trusted technical partner to Finance, RevOps, Marketing, and Product. 🎯 Requirements
Deep, hands-on analytics engineering experience: expert dbt (project architecture, testing, semantic layer) and strong warehouse fluency, with hands-on BigQuery and GCP a strong plus.
Strong SQL and data modeling judgment: dimensional modeling, grain discipline, and a clear sense of when to compute versus store aggregations.
A track record building the models a revenue team acts on, spanning canonical financial metrics (ARR, NRR, bookings, cohort retention) and the GTM scoring and lifecycle layers that activate through reverse ETL.
An appetite to build AI-native: comfort applying BigQuery ML and Vertex AI to scoring, with a point of view on the semantic layer as the governed interface AI agents query.
Ownership instinct across the full stack, from ingestion config through business logic to reporting, with the judgment to know when to build for now versus build to scale.
Strong written and verbal communication; you can make a metric definition or a modeling tradeoff clear to Finance, GTM leaders, and technical peers alike.
At least 6 years of progressive experience in analytics engineering, data engineering, or a closely related data role, including time as the senior technical owner of a warehouse or dbt project.
Experience with identity resolution across disconnected systems, ideally in a PLG / product-led enterprise (PLE) motion.
Developer-tools or technical B2B SaaS background, and comfort working agent-first with tools like Claude Code. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

dbtBigQueryGCPSQLdata modelingdimensional modelingBigQuery MLVertex AIreverse ETLdata governance

Soft Skills

communicationownershipjudgmentcollaborationtechnical partnership