Automotive Parts Data Analyst

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.

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.

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.

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.