Process and Inventory Analyst

CSP Innovations, Inc.; Auburn Hills (MI); On-site; USD 42,000 - 66,000; Full time

Job summary

CSP Innovations, Inc. in Auburn Hills, MI is seeking an Inventory Planner/Analyst to join a team focused on PFEP optimization, inventory control, and data-driven supply chain improvements.

You will collect, organize, and maintain PFEP information with plant teams and prepare recurring inventory reports. The role requires 0–2 years of experience, a degree in Supply Chain or related field, strong Excel skills, and familiarity with ERP systems such as QAD.

Qualifications

• Zero to two years of relevant experience; recent graduates welcome.
• Basic understanding of inventory or supply chain concepts and a willingness to learn manufacturing processes.
• Working knowledge of Excel, including sorting, filtering, and basic formulas.
• Attention to detail, clear communication, task organization, and willingness to ask questions promptly.

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.

Skills

Excel

Data analysis

Inventory concepts

Education

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

Tools

QAD ERP

Pivot tables

Lookups

Power BI

Job description

CSP is the industry leader in the formulation and molding of lightweight, advanced composite components for the transportation industries. As an innovative, full-service Tier One supplier, we offer an entrepreneurial environment where you’re only limited by your own imagination. In addition to our team-focused environment, we provide industry-leading benefits, called BENEfits4U. Our comprehensive offering includes: affordable medical, dental, and vision care; flexible spending accounts; life insurance; 401k with company match and much, much more.

Job Description Essential Job Functions

• 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.
• Help update work instructions and training materials; assist with the rollout of approved process changes under the direction of COE and plant leads.
• 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.

Qualifications

• Associate’s or bachelor’s degree in Supply Chain, Operations, Business, or a related field, or equivalent relevant education and practical experience.
• Zero to two years of relevant experience; recent graduates, internships, co-ops, and relevant project work are welcome.
• Basic understanding of inventory or supply chain concepts and a willingness to learn manufacturing processes.
• Working knowledge of Excel, including sorting, filtering, and basic formulas; willingness to develop pivot-table, lookup, and data-analysis skills.
• Attention to detail, clear communication, task organization, and willingness to ask questions and raise issues promptly.

Preferred Experience

• Internship, co-op, or hands-on exposure to manufacturing, warehousing, production planning, or inventory control.
• Exposure to an ERP system such as QAD, or to inventory transactions and cycle counting; QAD experience is not required.
• Exposure to pivot tables, lookups, Power Query, or Power BI.

Skills & Competencies

• Curious, dependable, and comfortable learning on the plant floor.
• Checks work carefully, accepts feedback, and follows assigned actions through to completion.

Working Relationships & Accountability

Works under the Systems & Excellence Manager’s guidance and supports plant Materials teams. The manager reviews analyses and recommendations. This role does not independently approve inventory adjustments, master-data changes, or policy changes.

Performance Measures

Accuracy and timeliness of assigned reports, PFEP data completeness, action-log upkeep, completion of assigned tasks, and demonstrated development of inventory, Excel, and QAD skills.

Work Environment & Travel

Based in the Auburn Hills, MI main office, with 50% travel to CSP facilities, including overnight stays, for assessments, workshops, training, and implementation. Work includes office analysis and on-site activity in manufacturing environments. Follow applicable site safety and PPE requirements.

If you enjoy innovation, and an opportunity to learn and contribute to a growing organization, CSP is the place for you! Being a CSP employee means having the opportunity to see your impact every day. Our work experience is the combination of everything that’s unique about our culture, our core values, our commitment to your success, and most importantly, our people. We are a team of self-disciplined, hardworking, curious, trustworthy and humble people who make choices according to what is best for the team. We live to collaborate and make a difference.