Analytics Engineer III, Assurance at ACV | CA | Rezi

Analytics Engineer III, Assurance at ACV

Analytics Engineer III, Assurance

ACV · CA

1 months ago

Analytics Engineer III, Assurance

ACV · CA

a month ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Analytics Engineer III, Assurance role.

Rezi rewrites your resume against ACV's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Analytics Engineer III, Assurance posting at ACV — free, in seconds.

About the Role

The Analytics Engineer III on the ACV Assurance team transforms raw data into trusted, decision-ready models and reports that drive the business forward. 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 is reducing ad-hoc analytical bottlenecks by systematically building underlying dbt models, metric definitions, and BI layers to enable self-serve analytics.

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

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

Skills

  • dbt
  • SQL
  • BigQuery
  • Git
  • Omni BI
  • Looker BI
  • Google Cloud Platform
  • AI-assisted analytics

Experience Level

  • 3+ years of professional experience

Education Level

  • BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or related
  • Master's or Ph.D. a plus

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

About the Company

  • 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

Equal Opportunity

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