Analytics Engineer III, Assurance
ACV Auctions3 months ago
Toronto, CanadaSenior
Responsibilities
- Design and maintain dbt staging, intermediate, and production 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 semantic-layer capabilities, self-service chat, and dealer-facing embedded reporting in Omni BI.
- Translate business questions into analytical requirements, answer urgent requests, and codify recurring analyses for stakeholder or AI-assisted self-service.
- Develop data, predictive, and forecasting models supporting arbitration risk and high-risk dealer and vehicle identification.
- Build dealer-facing dashboards showing arbitration trends over time.
- Independently execute scoped projects, navigate competing stakeholder priorities, and deliver data-driven recommendations and presentations.
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 model design, testing, documentation, and incremental strategies.
- Expert-level SQL proficiency, 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, attention to detail, collaboration, curiosity, and ability to communicate findings to non-technical audiences.
- Master’s or Ph.D. is a plus, with demonstrated experience and a deep technical toolbox considered.
- Semantic-layer proficiency and Omni or Looker BI experience are preferred.
- Google Cloud Platform experience, AI-assisted analytics or developer workflow familiarity, and binary classification or loss forecasting experience are nice-to-haves.
Benefits
- Company-sponsored healthcare, dental, vision, life/AD&D, short-term disability, and long-term disability coverage effective on the date of hire.
- Optional critical illness and supplemental life/AD&D benefits.
- Generous parental leave top-up pay and vacation programs.
- Employee Stock Purchase Program and additional opportunities to earn company stock.
- Retirement planning through the company’s RRSP.
- Learning and development opportunities in a people-first, collaborative work environment.
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.