Build Revenue Data Marts: Design and implement dbt-based data marts for core GTM metrics (ARR, NRR, GRR, pipeline, quota, bookings), ensuring 100% reconciliation with Finance's source of truth
Establish Semantic Layer: Encode business logic and metric definitions into a governed, version-controlled semantic layer that standardizes how Vanta defines and calculates key metrics
Partner with GTM Analysts: Translate business requirements from analysts who understand stakeholder needs into scalable, well-tested data models that enable self-service insights
Drive Metric Governance: Collaborate with Finance, RevOps, and business leaders to resolve definitional conflicts, establish clear ownership of metrics, and maintain cross-functional alignment on KPIs
Enable AI-Powered Analytics: Create clean, well-documented datasets that can safely power AI assistants, advanced analytics, and automated reporting tools
Influence Platform Roadmap: Work with Data Engineering to shape data platform capabilities, optimize pipeline performance, and ensure data quality through comprehensive testing frameworks
Champion Best Practices: Establish standards for dbt development, documentation, testing, and deployment that scale as Vanta's data needs grow

Requirements

Experience: At least 4 years in Analytics Engineering, Data Engineering, or equivalent roles focused on transforming and modeling data for analytics. Strong preference for candidates with 2+ years of deep dbt experience architecting projects, not just writing models.
dbt Expertise: Advanced proficiency with dbt (dbt Cloud preferred)—you've built or significantly contributed to dbt projects, managed configurations, implemented testing frameworks, and established governance patterns.
Data Modeling: Strong dimensional modeling skills (facts, dimensions, star schemas, data marts) and experience designing scalable analytical data architectures in modern cloud warehouses (Snowflake, BigQuery, Redshift).
GTM/Revenue Metrics: Solid understanding of go-to-market and financial metrics such as ARR, NRR, GRR, ACV, pipeline coverage, conversion rates, and quota attainment. Ability to translate business definitions into technical models.
SQL Mastery: Advanced SQL skills for complex transformations, aggregations, window functions, and performance optimization over large-scale datasets.
Collaboration: Proven ability to work effectively with cross-functional partners, including business analysts, finance teams, data engineers, and business stakeholders. You can translate technical concepts for non-technical audiences and vice versa.
Data Quality Mindset: Obsessed with correctness - you proactively implement testing, reconciliation processes, and data quality checks to prevent issues before they impact stakeholders.
Communication: Excellent written and verbal communication skills. You document your work clearly and can explain complex data models to both technical and business audiences.
Education: Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, or related technical field preferred.

Benefits

Comprehensive medical, dental, and vision coverage, with 100% of employee-only benefit premiums covered for most medical plans
16 weeks fully-paid Parental Leave for all new parents
Health & wellness stipend
Remote workspace, internet, and cellphone stipend
Commuter benefits for team members who report to the SF and NYC office
Family planning benefits
Matching 401(k) contribution with immediate vesting
Flexible PTO policy, plus 80 hours of Sick Time
11 company-paid holidays
Virtual team building activities, lunch and learns, and other company-wide events!

Applicant Tracking System Keywords

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

Hard Skills & Tools

dbtdata modelingSQLdimensional modelingdata architecturedata martstesting frameworksdata quality checksadvanced analyticsAI-powered analytics

Soft Skills

collaborationcommunicationproblem-solvingstakeholder managementcross-functional alignmentdocumentationinfluencegovernancetranslating technical conceptsattention to detail