Automotive Distribution Analyst

AAA Club Alliance•Wilmington, DE

19h•Hybrid

About The Position

AAA Club Alliance is currently seeking an Automotive Distribution Analyst 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. The role involves using 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. The analyst will monitor, analyze, and interpret financial, transactional, and associate-level sales data, and extract, transform, and analyze raw data to produce reports and communicate findings clearly. A key responsibility includes leading annual budget planning, forecasting, and financial modeling for sales and technology initiatives, partnering with leadership to align financial plans with business strategy. The role also entails monthly budget tracking, variance analysis, and reforecasting, identifying risks and opportunities, and providing actionable recommendations. Interpretation of trends and anomalies in data to support business strategy and operational improvement, including historical and predictive analysis, is crucial. The analyst will serve as a liaison between business line leaders, FP&A, and Business Intelligence analysts to align financial insights, operational metrics, and reporting priorities. Preparation of various performance reports (daily, weekly, monthly, quarterly, and annual) and analysis of trends across sales channels and Automotive operations are expected. The role supports special projects and Automotive business initiatives through financial analysis, transactional data review, and process improvement activities. Maintaining internal documentation for data sources, reporting logic, and business rules, and performing ad hoc analyses are also part of the responsibilities. Collaboration with cross-functional partners, including Marketing and Business Intelligence, is essential to support data quality, member acquisition, retention efforts, Automotive operations, and analytical needs. Other job duties as assigned.

Requirements

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.
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 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.
Strong written and verbal communication skills with the ability to present complex information in a clear and concise manner.
Strong analytical and problem-solving skills with the ability to interpret complex data and identify meaningful trends, variances, and opportunities.
Ability to collect, organize, analyze, and present data in a clear and actionable format.
Strong financial, transactional, and operational reporting aptitude.
Ability to identify process improvement opportunities, streamline recurring reporting activities, reduce manual effort, and support the development of standardized, efficient, and scalable reporting processes.

Nice To Haves

Automotive data analysis experience is preferred.
Experience with data visualization and reporting tools such as Power BI, Tableau, or similar platforms preferred.
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.

Responsibilities

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.

Benefits

Comprehensive health benefits package.
Up to three weeks of paid time off accrued during your first year.
Annual Bonus Plan.
401(K) plan with company match up to 7%.
Professional development opportunities and tuition reimbursement.
Paid time off to volunteer & company-sponsored volunteer events throughout the year.
Free AAA Premier Membership.
Health & Wellness Program.
Health Concierge Service.
Health & Life Insurance.
Short Term/Long Term Disability.
Medical, Dental, and Vision plan options
Up to 2 weeks Paid parental leave
2+ weeks of PTO within your first year
Paid company holidays
Company provided volunteer opportunities + 1 volunteer day per year
Continual learning reimbursement up to $5,250 per year