Analytics Engineer III, Assurance

ACV Auctions; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Healthcare

Dental

Vision

Life/AD&D

Disability insurance

Parental Leave

Stock Purchase Program

RRSP

Job summary

ACV Auctions is seeking an Analytics Engineer III to join the Assurance team in Toronto. You will transform raw data into trusted models and reports, and work across the analytics stack from dbt modeling to Omni BI dashboards to surface insights on arbitration risk.

The role emphasizes reducing ad-hoc bottlenecks, building scalable dbt models, self-serve analytics, and collaboration with business stakeholders. Strong SQL, dbt, and data warehousing experience are required.

Qualifications

• BA/BS in Statistics, Mathematics, CS, OR, or related field.
• 3+ years of analytics engineering, data engineering, or BI experience.
• Expert-level SQL with BigQuery or a comparable cloud warehouse.
• Hands-on production dbt experience (model design, testing, documentation).
• Experience delivering analytics initiatives independently.

Responsibilities

• Transform raw data into decision-ready models and reports.
• Build dbt models and BI dashboards to surface insights.
• Partner with Assurance team to surface arbitration risk insights.
• Develop self-serve analytics enabling AI-assisted querying.
• Maintain data quality with tests and documentation.

Skills

SQL

dbt

BigQuery

Data modeling

BI reporting

Git workflows

Education

BA/BS in Statistics, Mathematics, CS, OR, or related

Master's or PhD a plus

Tools

Git

Looker/Omni BI

Google Cloud Platform

Python/R

Job description

Posted Wednesday, August 19, 2026 at 4:00 AM

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:

• Company Sponsored (paid) Healthcare, Dental, Vision, Life/AD&D, Short-Term and Long-Term Disability.


• Comprehensive additional optional benefits such Critical Illness and Supplemental Life/AD&D.


• All insurance benefits go into effect on your date of hire.


• Generous Parental Leave Top-Up Pay and Vacation Programs.


• Employee Stock Purchase Program with additional opportunities to earn stock in the company.


• Retirement planning through the Company’s RRSP.

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

Navigate competing priorities across multiple stakeholder groups; propose win-win solutions when technical requirements conflict

What you will need:

Education

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

Experience

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

Soft Skills

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

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

#LI-AM3

Our Values

Trust & Transparency | People First | Positive Experiences | Calm Persistence | Never Settling

At ACV, we are committed to an inclusive culture in which every individual is welcomed and empowered to celebrate their true selves. We achieve this by fostering a work environment of acceptance and understanding that is free from discrimination. ACV is committed to being an equal opportunity employer regardless of sex, race, creed, color, religion, marital status, national origin, age, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires reasonable accommodation, please let us know.

For information on our collection and use of your personal information, please see our Privacy Notice.

No immigration or work visa sponsorship provided for this position.

Compensation:

The compensation range for this position is listed in the \"Job Details\" section at the bottom of this posting. Please note that final compensation will be determined based upon the applicant's relevant experience, skillset, location, business needs, market demands, and other factors as permitted by law.