StaffAnalyticsEngineer

ABOUT CODERABBIT CodeRabbit is an innovative research and development company focused on building extraordinarily productive human-machine collaboration systems. Our primary goal is to create the next generation of Gen AI-driven code reviewers: a symbiotic partnership between humans and advanced algorithms that significantly outperforms individual engineers. We combine language models with human ingenuity to push the boundaries of software development efficiency and quality. THE OPPORTUNITY We're looking for our Staff Analytics Engineer to build the BigQuery and dbt foundation behind CodeRabbit's go-to-market, and the intelligence that runs on it. You'll architect the warehouse, identity spine, and semantic layer that give every team one trusted definition of ARR, NRR, and lifecycle, then turn that foundation into revenue: PQL and PQA scoring that surface product-qualified accounts the moment they're ready, and expansion signals that catch accounts growing into their next tier. The models you ship move pipeline and retention, not just dashboards. You'll define the canonical model rather than inherit one, on a GCP-native platform we're building to be agent-ready from day one. KEY RESPONSIBILITIES - 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 s