Process and Inventory Analyst

CSP; Auburn Hills, Northern (MI, KY); Hybrid; USD 50,000 - 65,000; Full time

Job summary

CSP, located in Auburn Hills, MI, seeks a Process and Inventory Analyst to join our team and support PFEP data, inventory reporting, and materials analysis. You will work with plant teams on demand, lead times, and replenishment settings, ensuring data accuracy and process improvements.

Based in the Auburn Hills office with 50% travel to CSP facilities, you will assist with cycle counts, material availability studies, and trade-compliance documentation under the guidance of the Systems &

Qualifications

• Associate’s or bachelor’s degree in Supply Chain, Operations, Business, or related field, or equivalent education and experience.
• Zero to two years of relevant experience; new grads welcome.
• Basic understanding of inventory or supply chain concepts and 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.

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 and check data for completeness/accuracy; flag unusual results.
• Assist with analysis of raw material, components, WIP, and finished goods to identify shortages, excess stock, and slow-moving inventory.
• Compile cycle-count results, track count completion, document variances, and support physical inventory prep and follow-up activities.
• Trace inventory discrepancies through receiving, production reporting, transfers, scrap, and shipping transactions with experienced team members.
• Gather planning parameters and compare with approved standards; document gaps for review by manager and plant Materials team.
• Participate in plant assessments and improvement workshops; maintain action logs and follow up on tasks.
• Help update work instructions and training materials; assist with rollout of approved process changes under COE guidance.
• Support trade compliance documentation for 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 concepts

Data analysis

Attention to detail

Communication

Education

Bachelor's or Associate degree in Supply Chain/Operations/Business

Tools

Excel

QAD ERP

Pivot tables

Power BI

Power Query

Lookups

Job description

## Process and Inventory AnalystApply: Auburn Hills: Full time: Posted Yesterday: JR101417CSP 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. Professional certifications are not required. ## Skills & CompetenciesCurious, dependable, and comfortable learning on the plant floor. Checks work carefully, accepts feedback, and follows assigned actions through to completion. ## Working Relationships & AccountabilityWorks 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 MeasuresAccuracy 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 & TravelBased 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!*