Analytics Engineer IV

Responsibilities

• Create and maintain dbt models across staging, intermediate, and production layers to establish a single source of truth for Capital KPIs, designed for machine readability.
• Ensure data quality through dbt tests, source freshness checks, and thorough documentation so downstream users can trust the data.
• Develop complex SQL transformations on large datasets, optimizing for cost and performance.
• Translate business questions into clearly scoped analytics requirements, define metrics with Capital leadership, and keep definitions governed in the semantic layer.
• Build and own the Omni BI semantic layer to enable self-serve analytics and dealer-facing embedded reporting.
• Balance quick responses to ad hoc requests with scalable solutions, triaging what to answer once versus what to codify for self-service by stakeholders or AI tools.
• Present data narratives clearly to non-technical stakeholders and iterate based on follow-up questions.
• Lead Targeting initiatives by developing models and dashboards that identify high-propensity dealer and borrower segments for outbound sales.
• Establish loan origination funnel visibility from application to funding, highlighting bottlenecks and conversion opportunities.
• Provide analytical support for account management workflows, dealer servicing SLAs, and audit/compliance reporting.
• Own analytical initiatives end-to-end, identifying stakeholders, defining scope and timelines, and delivering without close supervision.
• Proactively surface opportunities and offer data-driven recommendations beyond the questions asked.
• Navigate competing stakeholder priorities and propose win-win solutions when technical requirements conflict.

Requirements

• BA/BS in Statistics, Mathematics, Computer Science, Operations Research, or a related field.
• 5+ years of professional experience in analytics engineering, data engineering, or BI.
• Hands-on production experience with dbt, including model design, testing, documentation, and incremental deployment.
• Expert-level SQL with proficiency in window functions, complex joins, and query optimization in BigQuery or a comparable cloud warehouse.
• Demonstrated ability to deliver major analytical initiatives independently from scoping to stakeholder presentation.
• Experience with Git-based version control workflows.
• Experience communicating analytical findings clearly to non-technical audiences.
• Comfort navigating ambiguity and a collaborative, low-ego team player attitude.
• Strong judgment on when to provide rapid answers versus building robust, reusable solutions.

Technologies

• dbt
• SQL
• BigQuery
• Looker
• Omni BI
• Git

Compensation

Salary range: USD 140,000 - 170,000 per year. Final compensation will be determined based on relevant experience, skill set, location, business needs, market factors, and applicable laws.

Benefits

• Multiple medical plans including a high deductible option
• Company-sponsored Short-Term and Long-Term Disability
• Company-sponsored Life Insurance
• Dental and Vision insurance
• Supplemental Life/AD&D
• Legal/ID Protection
• Accident and Critical Illness Insurance
• Uncapped vacation, paid sick days, company holidays, and floating holidays
• Parental leave, bereavement leave, jury duty leave, and voting leave
• Other paid leave as required by law
• Employee Stock Purchase Program
• 401(k) retirement plan

About ACV Auctions

ACV Auctions is a technology company transforming how dealers buy and sell cars online. The platform provides data-driven tools and solutions to source, sell, and manage used vehicles with transparency and insight, reshaping the automotive marketplace.

Our Values

• Trust and Transparency
• People First
• Positive Experiences
• Calm Persistence
• Never Settling