Analytics Engineer IV, ACV Capital
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. Our network of brands include ACV Auctions, ACV Transportation, ClearCar, MAX Digital and ACV Capital within its Marketplace Products, as well as, True360 and Data Services. 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.
Requirements
- BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or related
- 5+ years of professional experience in analytics engineering, data engineering, or BI
- Hands-on production experience with dbt (model design, testing, documentation, incremental strategies)
- Proficiency building semantic layers; Omni or Looker BI experience preferred, but similar experience considered
- Expert-level SQL; comfortable with window functions, complex joins, and query optimization in BigQuery or a comparable cloud warehouse
- Experience delivering major analytical initiatives independently, from scoping through stakeholder presentation
- Background in financial services, fintech, or lending is a meaningful plus - familiarity with origination, account management, or B2B lending workflows accelerates ramp
- Experience with Git-based version control workflows
- Communicates analytical findings clearly to non-technical audiences
- Comfortable navigating ambiguity
- Collaborative, low-ego, and invested in the team's collective output
- Strong instinct for knowing when to answer quickly vs. when to build properly
Nice To Haves
- Master's or Ph.D. a plus, but offset by demonstrated experience and a deep toolbox
- Experience with Google Cloud Platform
- Familiarity with AI-assisted analytics or developer workflows
- Exposure to credit risk, payment systems, or audit/compliance reporting contexts
Responsibilities
- Design, build, and maintain dbt models (staging, intermediate, production layers) that serve as the single source of truth for Capital 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 Capital leadership and keep definitions governed in our semantic layer
- Build and own the 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
- Develop models and dashboards that identify high-propensity dealer and borrower segments to support outbound sales strategy
- Build funnel visibility from application through funding; surface bottlenecks and conversion opportunities
- Provide analytical support for account management workflows, dealer servicing SLAs, and audit/compliance reporting
- Own analytical initiatives end-to-end: identify stakeholders, define scope and timelines, and execute without requiring close supervision
- Proactively surface opportunities and deliver data-driven recommendations — not just answers to questions that were asked
- Navigate competing priorities across multiple stakeholder groups; propose win-win solutions when technical requirements conflict
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
