Manager, Transformation Analytics

Job description

The Manager, Transformation Analytics sits at the analytical core of AutoNation's transformation agenda: an enterprise-wide effort to modernize how a leading American automotive retailer sells, serves, and operates, with significant P&L impact at scale. The analysis you build will shape strategic decisions made at the Executive Committee and senior leadership level. This is a unique position for an ambitious analytical talent. As a member of the transformation office, you will support the business cases, modeling, and analytical problem solving behind CEO-level initiatives, collaborating cross-functionally with Product, Tech, Finance, Marketing and Operations to build the analysis and sharpen the rationale behind each recommendation. You will help turn those recommendations into real processes across the business. You move fluidly between the big picture and the details. You can scope an ambiguous problem, find and structure the right data, and turn it into a clear answer. You pair rigorous SQL and thoughtful dashboard design with the storytelling instinct to make complex analysis easy to follow and decisions easy to make. Key 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. Minimum Qualifications Experience: 5–7 years in a data or analytics role building queries and reporting for business stakeholders. SQL expertise: 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. You've built the data layer behind a report, not just consumed one. BI and reporting: 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. Data Wrangling: Experience taking raw, messy, inconsistent source data and turning it into something trustworthy - you've handled the deduplication, grain, and reconciliation problems yourself. Supporting tools: Strong Excel and PowerPoint for analysis and executive communication; Python or dbt a plus. Communication: Top-down, well-structured communicator: make complex analysis easy to follow and decisions easy to make. Ownership: Comfortable with ambiguity and fast-moving work; takes initiative and follows through. Industry context: Interest in automotive, retail, or consumer businesses; prior industry experience is a plus. Education BS/BA degree in Business, Economics, Finance, Engineering, or a related field; advanced degree is a plus. Exciting Benefits and Perks Await You: Competitive compensation and 401k matching Enjoy a healthy work-life balance with insurance plans (health, dental, vision) and maternity benefits. Associate purchase and discount programs for new and pre-owned vehicles, services, parts, collision, accessories, and AutoGear Access amazing deals and discounts through YouDecide, a website with offers from top providers and retailers Join our DRVPNK mission to raise and donate millions of dollars to cancer research and treatment, partnering with cancer charities nationwide AutoNation is one of the largest automotive retailers in the United States, offering innovative products, exceptional services, and comprehensive solutions, empowering our customers to make the best decisions for their needs. With a network of dealerships nationwide strengthened by a recognized brand, we offer a wide variety of new and used vehicles, customer financing, parts, and provide expert maintenance and repair services. Through DRV PNK, we have raised over $40 million for cancer-related causes, demonstrating our commitment to making a positive difference in the lives of our Associates, Customers, and the communities we serve. AutoNation is committed to creating a diverse, equitable, and inclusive environment in our workplace and the services we provide. We welcome candidates from all backgrounds who are passionate about making a positive impact. Even if you do not meet every requirement, we encourage you to apply. Join our team and help us foster a culture of belonging while contributing to our revolutionary work in the automotive industry. We value innovation, teamwork, and a commitment to making a positive impact in the world.