At a Glance
- Tasks: Build trusted dbt models and create impactful Omni BI reports.
- Company: Join a forward-thinking team focused on data-driven decisions.
- Benefits: Competitive salary, flexible work options, and opportunities for growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Make a real impact by solving analytical challenges with cutting-edge tools.
- Qualifications: 3+ years in analytics engineering and expert SQL skills required.
The predicted salary is between 99000 - 121000 $ per year.
Build trusted dbt models and Omni BI reporting as an Analytics Engineer III supporting ACV Assurance’s business decisions and self-serve analytics. This practitioner works across data engineering and business intelligence. You will use advanced SQL, data quality practices, and semantic modeling to answer urgent questions and reduce recurring analytical bottlenecks. The work supports arbitration risk and product initiatives.
Key Responsibilities:
- Design and maintain dbt models across staging, intermediate, and production layers
- Enforce quality through tests, freshness checks, and documentation
- Build Omni BI dashboards and embedded dealer reporting
- Define governed metrics with Assurance stakeholders
- Deliver recommendations and clear data narratives
Requirements:
- Three or more years in analytics engineering, data engineering, or BI
- Production dbt experience with modeling, testing, and documentation
- Expert SQL skills, including joins, windows, and query optimization
- BA or BS in a relevant quantitative or technical field
- Experience delivering initiatives independently and using Git workflows
- Apply advanced SQL, dbt, and BI expertise to strengthen ACV Assurance analytics, reporting, and trusted decision-making.
Senior dbt Analytics Engineer in Toronto employer: ACV Auctions
ACV is an exceptional employer that fosters a culture of innovation and collaboration, making it an ideal place for a Lead Product Manager to thrive. With a strong focus on employee growth, you will have the opportunity to mentor junior product managers while working in a dynamic environment that values creativity and strategic thinking. Located at the heart of the automotive industry, ACV offers unique advantages such as access to cutting-edge technology and a commitment to transforming digital experiences for customers.
