Inventory & Process Analyst: Data-Driven Optimizer

CSP (Teijin Automotive Technologies); Auburn Hills (MI); On-site; USD 42,000 - 58,000; Full time

Job summary

CSP is seeking an entry-level Inventory/Planned Materials Analyst in Auburn Hills, MI. You will collect PFEP data, prepare reports, and support analysis of materials, inventory movement, and replenishment settings, working with plant teams.

Based in a manufacturing environment, you will help trace discrepancies, update procedures, and participate in process improvements while developing Excel, data‑analysis, and ERP skills with mentorship from the Materials team.

Qualifications

• Associate’s or bachelor’s degree in Supply Chain, Operations, Business, or related field.
• Zero to two years of relevant experience; internships welcome.
• Basic understanding of inventory concepts and willingness to learn manufacturing processes.
• Working knowledge of Excel; willingness to develop pivot-table, lookup, and data-analysis skills.

Responsibilities

• Collect, organize, and maintain PFEP information with plant teams, including demand, lead times, replenishment settings, packaging, storage, and points of use.
• Prepare recurring inventory reports using established templates; check data for completeness and accuracy and flag unusual results for review.
• Assist with analysis of raw material, purchased components, work-in-process, and finished goods to identify shortages, excess stock, and slow-moving inventory.
• Compile cycle-count results, track count completion, and help document variances; support physical inventory preparation and follow-up activities.
• Help trace inventory discrepancies through receiving, production reporting, transfers, scrap, and shipping transactions with experienced team members.
• Gather planning parameters and compare them with approved standards; document potential gaps for review by the manager and plant Materials team.
• Participate in plant assessments and improvement workshops; take process observations, maintain action logs, and follow up on assigned tasks.
• Support trade compliance documentation for the Logistics & Supply Chain Optimization Manager, including country-of-origin and shipment records.
• Support material-availability, capacity, and inventory-bank studies by gathering data and completing defined analyses; submit findings for review.

Skills

Inventory control

Data analysis

Excel proficiency

Problem solving

Education

Associate’s or bachelor’s degree in Supply Chain, Operations, Business

Tools

Excel

QAD ERP

Power BI

Job description

CSP is seeking an entry-level Inventory/Planned Materials Analyst in Auburn Hills, MI. You will collect PFEP data, prepare reports, and support analysis of materials, inventory movement, and replenishment settings, working with plant teams.

Based in a manufacturing environment, you will help trace discrepancies, update procedures, and participate in process improvements while developing Excel, data‑analysis, and ERP skills with mentorship from the Materials team.