Materials Analyst

Hollingsworth•Dearborn, MI

About The Position

The Materials Analyst supports the Material Planning team for the automotive service kits business by turning demand, inventory, supplier, and production data into actionable material plans. The role independently analyzes requirements, maintains planning parameters, identifies supply risks, monitors and reports on supplier performance, and coordinates corrective actions so kits are completed and delivered on time. Working alongside the Materials Data Coordinator, the analyst uses accurate master and transaction data to resolve shortages and excesses and improve inventory performance. The role carries more independent judgment and ownership than the coordinator position and is comparable to a Buyer. The analyst reviews material requirements and MRP recommendations, monitors availability through kit completion, manages inventory and supplier risks, maintains SAP planning parameters and data, and develops reports and analysis to support decisions. The role collaborates across Materials, Purchasing, Operations, Quality, Engineering, Customer Service, suppliers, and IT; supports problem-solving and process improvement; and assists with customer launches, transitions, special projects, audits, and inventory reviews.

Requirements

  • Bachelor’s degree in supply chain, business, operations, analytics, or a related field, or equivalent relevant experience.
  • At least 2 years of experience in material planning, purchasing, inventory control, production planning, supply chain analysis, or a closely related area.
  • Working knowledge of MRP, inventory management, purchasing, and production or fulfillment processes, with ERP experience reviewing demand, supply, inventory, and transactions.
  • Intermediate Excel skills, including formulas, lookups, pivot tables, filters, and data validation.
  • Strong analytical and problem-solving skills, with the ability to identify discrepancies and determine root causes.
  • Ability to manage priorities, communicate risk, and drive cross-functional follow-through.
  • Excellent written, verbal, interpersonal, and teamwork skills.

Nice To Haves

  • 2 or more years of SAP experience, including MRP and material master data.
  • Experience in automotive, service parts, kitting, packaging, or a high-mix manufacturing or distribution environment.
  • Experience analyzing shortages, excess and obsolete inventory, and supplier constraints.
  • APICS/ASCM CPIM or CSCP certification, or progress toward certification.

Responsibilities

  • Analyze customer demand, bills of materials, inventory, open purchase orders, production schedules, and lead times to determine material requirements for service kits.
  • Review MRP recommendations and planning exceptions; create, adjust, or escalate material plans based on business priorities and known constraints.
  • Monitor material availability from order through kit completion and coordinate recovery plans for shortages that could affect delivery.
  • Balance service, inventory, and cost considerations when recommending order timing, quantities, substitutions, or schedule changes.
  • Identify shortages, excess and obsolete inventory, slow-moving material, and inventory imbalances; investigate root causes and recommend corrective actions.
  • Partner with Buyers and suppliers to confirm material availability, expedite or defer deliveries, and resolve quantity or timing concerns.
  • Review supplier performance with Buyers, including delivery, quantity, and lead-time results, and drive corrective actions with suppliers.
  • Assess the material impact of demand changes, engineering changes, new programs, phase-outs, and customer-specific requirements.
  • Maintain clear shortage priorities and communicate risk, ownership, timing, and next steps to affected teams.
  • Review and maintain SAP planning parameters, including lead times, safety stock, lot sizes, minimum order quantities, rounding values, and other MRP settings.
  • Validate material master, BOM, purchasing, and inventory data used in planning; coordinate corrections with the Materials Data Coordinator, Buyers, Operations, and IT.
  • Investigate transaction, IDoc, EDI, ASN, and system discrepancies when they affect material availability or planning accuracy.
  • Use SAP data and system controls consistently, documenting assumptions and changes when required.
  • Develop, run, reconcile, and interpret SAP and Excel reports for shortages, inventory exposure, demand changes, supplier performance, and planning exceptions.
  • Use Excel tools such as lookups, pivot tables, formulas, filters, and data validation to identify trends and support decisions.
  • Provide recurring and ad hoc analysis to Materials leadership and cross-functional partners, with clear conclusions and recommended actions.
  • Track assigned actions and confirm that corrective measures produced the intended result.
  • Work closely with the Materials Data Coordinator, Material Planners, Schedulers, Buyers, Operations, Quality, Engineering, Customer Service, suppliers, and IT.
  • Lead or support cross-functional problem-solving related to material availability, inventory accuracy, supplier constraints, and service kit delivery.
  • Identify recurring planning problems and implement practical improvements to reports, parameters, standard work, and controls.
  • Provide guidance and knowledge sharing on material planning processes, system use, and analytical methods.
  • Support customer launches, transitions, special projects, audits, inventory reviews, and continuous improvement work related to Materials and Purchasing.
  • Perform other duties as needed or assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service