Analytics Engineer III, Assurance
ACV Auctions3 months ago
Responsibilities
- Design, build, and maintain staging, intermediate, and production dbt models as trusted sources for Assurance KPIs.
- Implement dbt tests, source freshness checks, and documentation to enforce data quality.
- Write and optimize complex SQL transformations on large datasets in BigQuery or a comparable cloud warehouse.
- Define governed metrics and build upon the Omni BI semantic layer for self-service chat and embedded reporting.
- Balance urgent analytical requests with the development of reusable models, metric definitions, and BI capabilities.
- Deliver analytical narratives, recommendations, dashboards, and follow-up analysis to business stakeholders.
- Support risk analysis, predictive and forecasting models, and identification of high-risk dealer and vehicle populations.
- Develop dealer-facing dashboards showing arbitration trends over time.
- Independently execute scoped projects, manage timelines, and navigate competing stakeholder priorities.
Requirements
- BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or a related field.
- 3+ years of professional experience in analytics engineering, data engineering, or business intelligence.
- Hands-on production experience with dbt, including model design, testing, documentation, and incremental strategies.
- Expert-level SQL skills, including window functions, complex joins, and query optimization.
- Experience delivering analytical initiatives independently from scoping through stakeholder presentation.
- Experience with Git-based version control workflows.
- Strong communication, analytical, collaboration, attention-to-detail, and ambiguity-navigation skills.
- Preferred experience building semantic layers and using Omni, Looker, or similar BI tools.
- Preferred experience with Google Cloud Platform, AI-assisted analytics or developer workflows, and binary classification or loss forecasting.
- A Master's or Ph.D. is a plus and may be offset by demonstrated experience and a deep toolbox.
Benefits
- Multiple medical plans, including a high-deductible low-cost health plan.
- Company-sponsored short-term disability, long-term disability, and life insurance.
- Optional dental, vision, supplemental life/AD&D, legal/ID protection, accident, and critical illness insurance.
- Uncapped vacation days, paid sick leave, six paid company holidays, two floating holidays, parental leave, bereavement leave, jury duty leave, voting leave, and other legally required paid leave.
- Employee Stock Purchase Program and additional opportunities to earn company stock.
- Company 401(k) retirement plan.
Tech Stack
Categories
Data Engineering
About ACV Auctions
ACV Auctions operates a dealer-only online wholesale marketplace for used vehicles, alongside data, inspection, transportation, and floorplan financing services for auto retailers and commercial sellers. It earns fees from transactions and ancillary products delivered through brands such as ACV Transportation, ACV Capital, True360, and MAX Digital. Founded in 2014 and headquartered in Buffalo, New York, ACV is a public company traded on the NASDAQ.