Automotive Parts Data Analyst

About the role

We are seeking an analytical, detail-oriented professional to join our team as an Inventory & Data Analytics Specialist. This position plays a critical role in transforming large volumes of OEM parts and inventory data into meaningful business insights for dealership clients. The successful candidate will work with extensive master parts files containing part numbers, pricing, dimensions, product classifications, stocking information, demand metrics, supersessions, and other operational data. These files are combined with dealership inventory records from multiple dealership management systems to produce reports, recommendations, financial models, and consulting deliverables.

This role is ideal for someone who enjoys working with large datasets, solving business problems, building advanced Excel tools, and helping organizations make better inventory and operational decisions.

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.

Preferred Qualifications

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

Technical Skills

• Advanced Excel Skills
• Pivot Tables
• Power Query
• XLOOKUP
• INDEX/MATCH
• Dynamic Arrays
• Data Validation
• Conditional Formatting
• Advanced Formulas
• Financial Modeling
• Scenario Analysis

Preferred Analytics Tools

• Power BI
• SQL
• Access
• Tableau
• Python (a plus but not required)

Ideal Candidate Profile

The ideal candidate is someone who can look at a file containing hundreds of thousands of inventory records and quickly identify business opportunities, trends, risks, and actionable recommendations.

Potential backgrounds include:

• Inventory Analyst
• Business Analyst
• Supply Chain Analyst
• Automotive Fixed Operations Analyst
• Parts Operations Analyst
• Dealership Inventory Specialist
• Financial Analyst with strong data skills

About Us

We are a specialized consulting organization focused on helping clients optimize parts operations, inventory investments, profitability, customer service, and operational performance. Through a combination of industry expertise, proprietary analytics, and data-driven recommendations, we help organizations achieve measurable and sustainable improvements.