Inventory Optimization Engineer — Onsite in Charleston

Perfection Automotive Aftermarket Group; Charleston (SC); On-site; USD 75,000 - 105,000; Full time

Job summary

Perfection Hy-Test Company in Charleston, SC, is hiring an Inventory Optimization Engineer to maximize inventory value by analyzing excess and obsolete stock, identifying recovery opportunities, and reducing write-offs.

You will collaborate with Engineering, Sales, Purchasing, Product Management, Cataloging, Operations, and Finance to learn automotive aftermarket processes and develop practical solutions for inventory improvement.

Qualifications

• Bachelor's degree required in engineering, supply chain, business analytics, or related field.
• Strong analytical and problem-solving skills.
• Excellent Excel skills; Power BI or SQL exposure preferred.

Responsibilities

• Analyze excess and obsolete inventory to identify opportunities for recovery.
• Research inventory history, demand, and product information to understand why inventory became excess.
• Prepare recommendations for inventory disposition based on data.
• Support recurring E&O review meetings with cross-functional teams.
• Track inventory aging and inventory health metrics.
• Assist in developing standard processes for evaluating excess inventory.
• Work with Engineering and Product Management to understand product applications.
• Research opportunities to sell inventory against existing or alternative SKUs.
• Assist in identifying interchangeable or equivalent products.
• Help identify opportunities for SKU consolidation.
• Learn automotive product applications and catalog structure over time.
• Partner with Cataloging to improve product information.
• Help identify missing applications and cross-references.
• Review product data for opportunities to improve inventory visibility.
• Support projects that improve catalog accuracy and completeness.
• Collect, organize, and analyze inventory data from ERP and reporting systems.
• Build dashboards and reports using Excel and Power BI.
• Monitor inventory aging, turns, E&O dollars, recovery rates, and write-offs.
• Present findings and recommendations to leadership.
• Identify opportunities to improve inventory management processes.
• Support Lean and Continuous Improvement initiatives.
• Document standard work.
• Help automate recurring reports and manual business processes.

Skills

Analytical skills

Excel

Power BI

SQL

Education

Bachelor's degree in Engineering, Supply Chain, Business Analytics, Operations, or related technical field

Tools

Power BI

SQL

Job description

Perfection Hy-Test Company in Charleston, SC, is hiring an Inventory Optimization Engineer to maximize inventory value by analyzing excess and obsolete stock, identifying recovery opportunities, and reducing write-offs.

You will collaborate with Engineering, Sales, Purchasing, Product Management, Cataloging, Operations, and Finance to learn automotive aftermarket processes and develop practical solutions for inventory improvement.