Analytics Engineer III, Assurance

ACV • Buffalo, NY

44d • $100,000 - $150,000

About The Position

ACV is a technology company that has revolutionized how dealers buy and sell cars online, transforming the automotive industry. ACV Auctions Inc. (ACV) has applied innovation and user-designed, data driven applications and solutions. We are building the most trusted and efficient digital marketplace with data solutions for sourcing, selling and managing used vehicles with transparency and comprehensive insights that were once unimaginable. We are disruptors of the industry and we want you to join us on our journey.

At ACV we focus on the Health, Physical, Financial, Social and Emotional Wellness of our Teammates and, to support this, we offer:
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)

Requirements

• BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or related
• 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
• Excellent communicator with a strong attention to detail; genuinely curious about the business and willing to dig into the specifics to get things right
• Collaborative, low-ego, and invested in the team's collective output
• Strong instinct for knowing when to answer quickly vs. when to build properly
• Communicates analytical findings clearly to non-technical audiences
• Comfortable navigating ambiguity

Nice To Haves

• Master's or Ph.D. a plus, but offset by demonstrated experience and a deep toolbox
• Proficiency building semantic layers; Omni or Looker BI experience preferred, but similar experience considered
• Experience with Google Cloud Platform
• Familiarity with AI-assisted analytics or developer workflows
• Experience with binary classification and/or loss forecasting

Responsibilities

• 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
• 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
• Support the business in developing data, predictive, and forecasting models that identify high-risk dealer and vehicle populations to support program management strategy
• Develop dealer-facing dashboards that illustrate their arbitration trends over time
• 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

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)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level