Manager, Transformation Analytics

United Fidelity Bank; United States; On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

401k matching

Health, dental, vision insurance

Vehicle purchase/discount programs

YouDecide deals

DRVPNK cancer charity involvement

Job summary

AutoNation is seeking a Manager, Transformation Analytics to drive enterprise-wide analytical initiatives across the transformation office. You will build business cases, model financials, and partner with Product, Tech, Finance, Marketing, and Operations to shape decisions.

You will translate recommendations into scalable processes, crafting dashboards and reports with storytelling to support CEO-level decisions and strategic initiatives.

Qualifications

• 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.

Responsibilities

• Scope and frame the problem with a clear plan: define the key drivers, approach, and evidence.
• Find and build the data across Product, Tech, Finance, and Operations; turn inputs into clean models and KPIs.
• Build the queries: write clean, well-structured SQL on large datasets; ensure QA before stakeholders.
• Stand up BI dashboards and data sources (Tableau, Power BI) designed for action, not just data.
• Build the narrative: executive-ready models and pages with clear insights and recommendations.
• Pressure-test the analysis with operators and cross-functional teams to validate assumptions.

Skills

SQL expertise

BI & Reporting

Data wrangling

Excel & PowerPoint

Python or dbt

Communication

Ownership

Industry knowledge

Education

Bachelor's degree in Business/ Economics/ Finance/ Engineering

Tools

Tableau

Power BI

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.