Back to jobs

Analytics Engineer III, Assurance

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design and maintain dbt models that serve as the source of truth for Assurance KPIs

  • Enforce data quality with dbt tests, source freshness checks, and documentation

  • Build Omni BI dashboards and semantic layer metrics for self-serve and dealer-facing reporting

  • Develop dealer-facing dashboards showing arbitration trends over time

  • Support predictive and forecasting models that identify high-risk dealer and vehicle populations

From the employer’s posting
Design, build, and maintain dbt models (staging, intermediate, production layers) that serve as the single source of truth for Assurance KPIs
Enforce data quality through dbt tests, source freshness checks, and documentation
Build upon our Omni BI semantic layer, enabling self-serve chat and dealer-facing embedded reporting
develop dealer-facing dashboards that illustrate their arbitration trends over time
support the business in developing data, predictive, and forecasting models that identify high-risk dealer and vehicle populations

What you’ll bring

All qualifications

Core experience

  • 3+ years of professional experience in analytics engineering, data engineering, or BI
  • Proficiency building semantic layers; Omni or Looker BI experience preferred, but similar experience considered
  • Experience delivering analytical initiatives independently, from scoping through stakeholder presentation
  • Experience with Google Cloud Platform
  • Experience with Git-based version control workflows
  • Familiarity with AI-assisted analytics or developer workflows
Qualification wording
3+ years of professional experience in analytics engineering, data engineering, or BI
Proficiency building semantic layers; Omni or Looker BI experience preferred, but similar experience considered
Experience delivering analytical initiatives independently, from scoping through stakeholder presentation
Experience with Google Cloud Platform
Experience with Git-based version control workflows
Familiarity with AI-assisted analytics or developer workflows
Education & alternatives
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
Apply at ACV

Posting record

Report an error

Open 3 monthsWe first saw this posting 91 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Aug 20, 202691 days ago
Recorded sightings
265
Last seen by us
Nov 19, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 91

Up longer than most. Similar jobs usually come down between day 7 and day 51.

At ACV, jobs usually come down by about day 77.

From 1,703 similar postings that came down, and 7 of ACV’s. Coming down is not always a hire.

ACV is hiring

8 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • BigQuery
  • dbt
  • GCP
Where the posting names them
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
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
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
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
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
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
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

Your next step

Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.

Applying through Dayforce

  • The application asks you to sign in to the employer’s Dayforce candidate portal, or create an account there.

Already applied? Track this application

Has ACV posted this job before?

Yes. We’ve followed one other Analytics Engineer III, Assurance job there since August 2026. It is still up.

  1. BuffaloStill up after 91 days, first seen Aug 20
  2. This jobUp 91 days so far, first seen Aug 20

Job description

View original posting ↗

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 Deliver data-driven recommendations 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

About ACV

People
About 2,451 in 2024.Benefit plan filings (Form 5500)
Company
Listed as ACVA.

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 20% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 82, the most 171, and the latest week had 93.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Toronto, ON, Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.