Automotive Parts Data Analyst

ADMI seeks an analytical professional to turn OEM parts and dealership inventory data into actionable business insights. The role develops reports, recommendations, dashboards, and financial models to support inventory optimization and consulting projects.

Responsibilities:

• Receive, validate, and maintain OEM master parts data files
• Import and process dealership inventory files from multiple systems and formats
• Clean, normalize, and organize large datasets for analysis
• Compare dealership inventory against OEM master data
• Identify inventory opportunities, stocking issues, obsolescence, and optimization opportunities
• Analyze sales, demand, inventory turns, fill rates, and other key performance indicators
• Investigate data discrepancies and provide recommendations
• Develop analytical reports and inventory performance summaries
• Create customer-facing findings and recommendations
• Build dashboards and scorecards for consultants, clients, and management
• Produce recurring operational reports and ad-hoc analyses
• Support consulting projects through detailed quantitative analysis
• Develop Excel-based pro formas and business models
• Build financial impact analyses and ROI calculations
• Create forecasting and inventory investment scenarios
• Support proposal development with data-driven financial projections
• Identify opportunities to automate manual reporting processes
• Improve data quality and reporting efficiency
• Support development of proprietary analytical tools and methodologies

Requirements:

• Advanced Microsoft Excel proficiency
• Strong analytical and problem-solving capabilities
• Experience working with large datasets and database structures
• Ability to perform data validation, cleansing, and manipulation
• Experience creating financial models, forecasts, and pro formas
• Strong attention to detail and accuracy
• Excellent written and verbal communication skills
• Ability to manage multiple projects and deadlines
• Pivot Tables
• XLOOKUP
• INDEX/MATCH
• Dynamic Arrays
• Data Validation
• Conditional Formatting
• Advanced Formulas
• Financial Modeling
• Scenario Analysis
• Power Query experience
• Power BI experience
• SQL experience
• Microsoft Access experience
• Inventory management or supply chain experience
• Automotive, dealership, aftermarket, or OEM industry experience
• Knowledge of dealership management systems (CDK, Reynolds & Reynolds, Dealertrack, PBS, Tekion, etc.)
• Experience supporting consulting or business advisory services
• Power Query
• Power BI
• SQL
• Access
• Tableau
• Python (a plus but not required)