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

Data Management & Analysis

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

Reporting & Client Deliverables

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

Financial Modeling

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

Process Improvement

• Identify opportunities to automate manual reporting processes.
• Improve data quality and reporting efficiency.
• Support development of proprietary analytical tools and methodologies.

Requirements

Required Qualifications

• 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 including Pivot Tables, Power Query, XLOOKUP, INDEX/MATCH, Dynamic Arrays, Data Validation, Conditional Formatting, Advanced Formulas.
• Financial Modeling and 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

Benefits

• Salary Range: $65,000 - $125,000 annually, depending on experience, technical skills, and industry background.
• Annual performance bonus.
• Employee Stock Ownership Plan participation.
• Professional development and training opportunities.

Additional Details

• Location: Remote (U.S. Required)
• Employment Type: Full-Time
• Reports To: VP – OEM – Business Development and Relationships