Analytics Engineer Iii, Assurance (Toronto)

Analytics Engineer Iii, Assurance (Toronto)

19 Nov
|
ACV Auctions
|
Toronto

19 Nov

ACV Auctions

Toronto

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 QualityDesign, build, and maintain dbt models (staging, intermediate, production layers) that serve as the single source of truth for Assurance KPIs, with machine-readability in mindEnforce data quality through dbt tests, source freshness checks, and documentation so downstream consumers can trust what they seeWrite complex SQL transformations on large datasets; optimize for cost and performanceReporting & BITranslate business questions into well-scoped analytical requirements; define metrics in collaboration with Assurance stakeholders and keep definitions governed in our semantic layerBuild upon our Omni BI semantic layer, enabling self-serve chat and dealer-facing embedded reportingBalance 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 futureDeliver clear, compelling data narratives to non-technical stakeholders; support follow-on questions and iterate quicklyAssurance Business DomainsRisk:



support the business in developing data, predictive, and forecasting models that identify high-risk dealer and vehicle populations to support program management strategyProduct: develop dealer-facing dashboards that illustrate their arbitration trends over timeProject Ownership & Stakeholder PartnershipExecute scoped projects with general guidance: define approach and timelines with input from a manager or senior team member, and drive day-to-day execution independentlyDeliver data-driven recommendationsNavigate competing priorities across multiple stakeholder groups; propose win-win solutions when technical requirements conflictWhat you will need:EducationBA/BS in Statistics, Mathematics, Computer Science, Operations Research, or relatedMaster's or Ph.D. a plus, but offset by demonstrated experience and a deep toolboxExperience3+ years of qualified experience in analytics engineering, data engineering, or BIHands-on production experience with dbt (model design, testing, documentation, incremental strategies)Expert-level SQL; comfortable with windowfunctions, complex joins, and query optimization in BigQuery or a comparable cloud warehouseExperience delivering analytical initiatives independently, from scoping through stakeholder presentationExperience with Git-based version control workflowsSoft SkillsExcellent communicator with a strong attention to detail; genuinely curious aboutthe business and willing to dig into the specifics to get things rightCollaborative, low-ego, and invested in the team's collective outputStrong instinct for knowing when to answer quickly vs. when to build properlyCommunicates analytical findings clearly to non-technical audiencesComfortable navigating ambiguityNice-to-HavesProficiency building semantic layers; Omni or Looker BI experience preferred, but similar experience consideredExperience with Google Cloud PlatformFamiliarity with AI-assisted analytics or developer workflowsExperience with binary classification and/or loss forecasting#LI-AM3

📌 Analytics Engineer Iii, Assurance (Toronto)
🏢 ACV Auctions
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: analytics engineer iii, assurance (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: analytics engineer iii, assurance (toronto) / toronto