Analytics Engineer III, Assurance

If you are looking for a career at a dynamic company with a people-first mindset and a deep culture of growth and autonomy, ACV is the right place for you! Competitive compensation packages and learning and development opportunities, ACV has what you need to advance to the next level in your career. We will continue to raise the bar every day by investing in our people and technology to help our customers succeed. We hire people who share our passion, bring innovative ideas to the table, and enjoy a collaborative atmosphere.

Who we are:

ACV is a technology company that has revolutionized how dealers buy and sell cars online. We are 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)

What you will do:

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. 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…