Automotive Parts Data Analyst

ADMI; United States; Remote; USD 65,000 - 125,000; Full time

Benefits offered by this job

Annual performance bonus

Employee Stock Ownership Plan

Professional development and training

Job summary

ADMI is seeking an Inventory & Data Analytics Specialist to transform OEM parts and inventory data into meaningful business insights for dealership clients. You will work with master parts files, pricing, classifications, stocking information, demand metrics, and dealership records to produce reports, financial models, and consulting deliverables.

The role focuses on analyzing large datasets, building advanced Excel tools, and delivering data-driven recommendations to optimize inventory and

Qualifications

• Experience handling large datasets and database structures.
• Ability to create financial models, forecasts, and pro formas.
• Strong data validation, cleansing, and manipulation skills.
• Excellent written and verbal communication abilities.
• Detail-oriented with ability to manage multiple projects.

Responsibilities

• Receive, validate, and maintain OEM master parts data files.
• Build dashboards and scorecards for clients and management.
• Develop Excel-based pro formas and financial projections.
• Create forecasting scenarios and data-driven ROI analyses.
• Produce recurring reports and ad-hoc analyses for consulting projects.

Skills

Analytical skills

Big data

Data validation

Financial modeling

Attention to detail

Communication skills

Project management

Tools

Power BI

SQL

Access

Tableau

Python

Job description

Automotive Parts Operations & OEM Inventory Analytics

Location: Remote (U.S. Required)

Employment Type: Full-Time

Reports To: VP – OEM – Business Development and Relationships

Salary Range - $65,000 - $125,000 annually Depending on experience, technical skills, and industry background.

Preferred candidates with automotive dealership, OEM parts, inventory optimization, Power BI, SQL, or advanced data modeling experience may command compensation toward the upper end of the range.

Potential additional compensation:

• Annual performance bonus
• Employee Stock Ownership Plan participation
• Professional development and training opportunities

Position Summary

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

Process Improvement

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

Required Qualifications

• 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

• Power Query
• INDEX/MATCH
• Dynamic Arrays
• Data Validation
• Conditional Formatting
• Advanced Formulas

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.