Automotive Business Analytics Specialist

AAA Club Alliance is currently seeking an Automotive Business Analytics Specialist to join our team in Wilmington, DE. This position follows a hybrid work schedule, with onsite presence required Tuesday through Thursday and the flexibility to work remotely on Monday and Friday. Primary Duties & Responsibilities include: Use analytical software and database tools to identify variances, trends, and correlations in purchasing behavior, product and partner utilization, membership penetration, quality, and other key performance indicators.

Monitor, analyze, and interpret financial, transactional, and associate-level sales data. Extract, transform, and analyze raw data to produce reports and communicate findings in a clear, business-friendly manner. Lead annual budget planning, forecasting, and financial modeling for sales and technology initiatives, partnering with leadership to align financial plans with business strategy. Perform monthly budget tracking, variance analysis, and reforecasting, identifying risks and opportunities, and providing actionable recommendations to ensure financial targets are achieved.

Interpret trends and anomalies in data and provide recommendations that support business strategy and operational improvement, including historical and predictive analysis. Serve as a liaison between business line leaders, FP&A, and Business Intelligence analysts to align financial insights, operational metrics, and reporting priorities that support informed decision-making across Automotive operations.

Prepare daily, weekly, monthly, quarterly, and annual performance reports. Analyze trends across sales channels and Automotive operations, and develop narrative reports, charts, and presentations highlighting key metrics such as retention, attrition, promotion response, and usage patterns. Analyze data from multiple sources to identify improvement opportunities across Automotive operations, draw conclusions, and provide recommendations that support leadership decision-making.

Support special projects and Automotive business initiatives through financial analysis, transactional data review, and process improvement activities. Maintain internal documentation for data sources, reporting logic, and business rules, and perform ad hoc analyses to support strategic Automotive initiatives and business questions. Collaborate with cross-functional partners, including Marketing and Business Intelligence, to support data quality, member acquisition, retention efforts, Automotive operations, and analytical needs.

Other job duties as assigned. Minimum Qualifications: Bachelor’s degree in Business, Finance, Accounting, Data Analytics, Economics, Statistics, or a related field. A combination of education and experience may be considered in lieu of a degree. 3-5 years of experience in data analysis, business analysis, financial analysis, sales analytics, or reporting. Automotive data analysis experience is preferred.

Experience working with large data sets, reporting tools, and data analysis methods. Advanced proficiency in Microsoft Excel required, including pivot tables, formulas, lookups, and data analysis functions. Experience with data visualization and reporting tools such as Power BI, Tableau, or similar platforms preferred. Experience partnering with FP&A teams and using financial, operational, and technical reporting tools to support budgeting, forecasting, variance analysis, dashboard development, and business performance insights.

Experience working with financial systems, enterprise reporting platforms, or related tools used to support budgeting, forecasting, general ledger review, expense tracking, and operational performance reporting preferred. Strong written and verbal communication skills with the ability to present complex information in a clear and concise manner. ​ Knowledge, Skills, and Abilities: Strong analytical and problem-solving skills with the ability to interpret complex data and identify meaningful t