Inventory Optimization Engineer

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

As a part of the global industrial organization Marmon Holdings—which is backed by Berkshire Hathaway—you’ll be doing things that matter, leading at every level, and winning a better way. We’re committed to making a positive impact on the world, providing you with diverse learning and working opportunities, and fostering a culture where everyone’s empowered to be their best.

The Inventory Optimization Engineer supports cross-functional efforts to maximize the value of the company's inventory by analyzing excess and obsolete inventory (E&O), identifying opportunities for recovery, and helping prevent future inventory obsolescence.

This role combines engineering, business analytics, and problem solving to improve inventory performance. Working closely with Engineering, Sales, Purchasing, Product Management, Cataloging, Operations, and Finance, this individual will learn the automotive aftermarket while developing practical solutions that improve inventory, reduce write-offs, and support profitable growth.

This new role is onsite, in Charleston, South Carolina.

Key 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 available 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.

Product & Application Research

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

Catalog & Product Data

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

Business Analytics

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

Continuous Improvement

• Identify opportunities to improve inventory management processes.
• Support Lean and Continuous Improvement initiatives.
• Document standard work.
• Help automate recurring reports and manual business processes.

Qualifications

• Bachelor's degree in Engineering, Supply Chain, Business Analytics, Operations, or related technical field.
• Strong analytical and problem-solving skills.
• Excellent Excel skills; Power BI or SQL exposure preferred.
• Strong communication and organizational skills.
• Curiosity and willingness to learn technical products and business processes.

PHYSICAL REQUIREMENTS (any specific physical attributes or limiting factors to be accounted for):

• Work is performed in various environments, such as Office, lab, manufacturing. May be exposed to dust, noise, heat and cold. Position requires “safety-equipment” to be worn in designated areas.

While performing the duties of this job, the employee may spend a large majority of time walking, standing, and using hands to push/pull.

Following receipt of a conditional offer of employment, candidates will be required to complete additional job-related screening processes as permitted or required by applicable law.

We are an equal opportunity employer, and all applicants will be considered for employment without attention to their membership in any protected class. If you require any reasonable accommodation to complete your application or any part of the recruiting process, please email your request to [e-mail], and please be sure to include the title and the location of the position for which you are applying.