Note: The job is a remote job and is open to candidates in USA. AutoNation is one of the largest automotive retailers in the United States, providing vehicles, financing, parts, maintenance, repair services, and other automotive solutions through a nationwide dealership network. The Manager, Transformation Analytics will support enterprise transformation initiatives by building business cases, financial and operational models, SQL queries, BI dashboards, and executive-ready analyses that guide senior leadership decisions.
Responsibilities
- Scope and frame the problem: Break down open-ended questions into a clear plan: define the key drivers, the right approach, and the evidence that will move the decision
- Find and build the data: Track down the right data across Product, Tech, Finance, and Operations, and turn messy inputs into clean financial and operational models and KPIs
- Build the queries: Write clean, well-structured, performant SQL against large and messy datasets: joins across disparate sources, transformations, deduplication, and business-logic layers - thoroughly QA'ed before it reaches stakeholders
- Stand up the reporting: Turn those queries into BI dashboards and data sources (Tableau, Power BI) that stakeholders can act on - designed for the decision, not just the data - and maintain them as the business changes
- Build the narrative: Shape the results into well-structured, well-formatted, executive-ready models and pages, with clear insights and recommendations that are easy to follow
- Pressure-test the analysis: Work with operators and functional teams to validate assumptions, test hypotheses, run scenarios, and bring an independent, data-driven point of view
Skills
- 5–7 years in a data or analytics role building queries and reporting for business stakeholders
- Advanced SQL - not just SELECT and JOIN. Comfortable with CTEs, window functions, and aggregation logic, and able to write queries that perform well against large tables and stay maintainable
- Strong hands-on experience building and maintaining dashboards in Tableau and Power BI, including data source design, calculated fields, and structuring a model so the visuals stay fast and correct
- Experience taking raw, messy, inconsistent source data and turning it into something trustworthy - you've handled the deduplication, grain, and reconciliation problems yourself
- Strong Excel and PowerPoint for analysis and executive communication; Python or dbt a plus
- Top-down, well-structured communicator: make complex analysis easy to follow and decisions easy to make
- Comfortable with ambiguity and fast-moving work; takes initiative and follows through
- Interest in automotive, retail, or consumer businesses; prior industry experience is a plus
- BS/BA degree in Business, Economics, Finance, Engineering, or a related field; advanced degree is a plus
Benefits
- 401k matching
- Health, dental, and vision insurance plans
- Maternity benefits
- Associate purchase and discount programs for new and pre-owned vehicles, services, parts, collision, accessories, and AutoGear
- Deals and discounts through YouDecide, a website with offers from top providers and retailers
Company Overview
Company H1B Sponsorship