[Hiring] Analytics Engineer III @ACV

Role Description

The Analytics Engineer III on the ACV Assurance team is a skilled practitioner who transforms raw data into trusted, decision-ready models and reports that drive the business forward. Sitting at the intersection of data engineering and business intelligence, this role contributes across the full analytics stack - from dbt model design and data quality to Omni BI dashboards - and partners with the Assurance Business to surface insights on arbitration risk and product initiatives.

A key objective of this role is reducing ad-hoc analytical bottlenecks over time. You will be expected to answer urgent business questions quickly and directly, while systematically building the underlying dbt models, metric definitions, and BI layer in a way that enables self-serve analytics - including AI-assisted querying - so that business stakeholders can answer common questions themselves.

What you will do:

• Analytics Modeling & Data Quality:
  • Design, build, and maintain dbt models (staging, intermediate, production layers) that serve as the single source of truth for Assurance KPIs, with machine-readability in mind.
  • Enforce data quality through dbt tests, source freshness checks, and documentation so downstream consumers can trust what they see.
  • Write complex SQL transformations on large datasets; optimize for cost and performance.
• Reporting & BI:
  • Translate business questions into well-scoped analytical requirements; define metrics in collaboration with Assurance stakeholders and keep definitions governed in our semantic layer.
  • Build upon our Omni BI semantic layer, enabling self-serve chat and dealer-facing embedded reporting.
  • Balance responsiveness to ad-hoc requests while optimizing via building: triage what should be answered once vs. what should be codified so stakeholders or AI tools can self-serve it in the future.
  • Deliver clear, compelling data narratives to non-technical stakeholders; support follow-on questions and iterate quickly.
• Assurance Business Domains:
  • Risk: support the business in developing data, predictive, and forecasting models that identify high-risk dealer and vehicle populations to support program management strategy.
  • Product: develop dealer-facing dashboards that illustrate their arbitration trends over time.
• Project Ownership & Stakeholder Partnership:
  • Execute scoped projects with general guidance: define approach and timelines with input from a manager or senior team member, and drive day-to-day execution independently.
  • Deliver data-driven recommendations.
  • Navigate competing priorities across multiple stakeholder groups; propose win-win solutions when technical requirements conflict.

Qualifications

• BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or related.
• Master's or Ph.D. a plus, but offset by demonstrated experience and a deep toolbox.

Requirements

• 3+ years of professional experience in analytics engineering, data engineering, or BI.
• Hands-on production experience with dbt (model design, testing, documentation, incremental strategies).
• Expert-level SQL; comfortable with window functions, complex joins, and query optimization in BigQuery or a comparable cloud warehouse.
• Experience delivering analytical initiatives independently, from scoping through stakeholder presentation.
• Experience with Git-based version control workflows.

Benefits

• Multiple medical plans including a high deductible, low cost health plan.
• Company-sponsored (paid) Short-Term Disability, Long-Term Disability, and Life Insurance.
• Comprehensive optional benefits such as Dental, Vision, Supplemental Life/AD&D, Legal/ID Protection, and Accident and Critical Illness Insurance.
• Generous paid time off options, including uncapped vacation days, the greater of 3 paid sick days or in accordance with the applicable state or local paid sick leave law, 6 paid company holidays, 2 floating holidays, parental leave, bereavement leave, jury duty leave, voting leave, and other forms of paid leave as required by applicable law or regulation.
• Employee Stock Purchase Program with additional opportunities to earn stock in the Company.
• Retirement planning through the Company’s 401(k).