Materials Analyst
Dearborn, MI, United States15h ago
Key details
- Location
- Dearborn, MI, United States
- Work style
- Onsite
- Level
- Mid level
- Experience
- 2–5 yrs
- Function
- Operations & Strategy
- Focus area
- other
- Posted
- 15h ago
Skills
bill of materialscustomer servicedata validationedierpexcelinventory controlinventory managementmrppivot tablesproduction planningrequirements analysisroot cause analysissapsupply chain
About the role
POSITION SUMMARY
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.
ROLE OUTCOMES
Shortages, excess inventory, obsolete material, and planning exceptions are identified early and addressed with clear action plans.
SAP planning parameters and material data are reviewed and maintained so system recommendations are reliable.
Supplier performance is monitored and reported, and shortfalls are addressed with suppliers and Buyers.
Supplier, customer, engineering, and production changes are translated into timely adjustments to material plans.
Supplier invoices are processed with accuracy and timeliness
ESSENTIAL JOB RESPONSIBILITIES
MATERIAL PLANNING AND REQUIREMENTS ANALYSIS
Analyze customer demand, bills of materials (BOMs), 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.
INVENTORY AND SUPPLY RISK MANAGEMENT
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.
SAP DATA AND PLANNING PARAMETERS
Review and maintain planning parameters in SAP, 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.
REPORTING AND ANALYSIS
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.
COLLABORATION AND PROCESS IMPROVEMENT
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.
PROJECTS AND OTHER DUTIES
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.
CORE COMPETENCIES
Self-check: if you already do several of these in your current role, you may be a strong fit for this role. Specific duties are listed in the section above.
COMMUNICATION & SERVICE
Work with others to achieve results important to internal and external customers. Help others succeed.
Raise material risks early and clearly, including the business impact, options, and recommended action.
Explain complex data and planning issues in a way others can understand and act on.
Build productive working relationships across Materials, Purchasing, Operations, and support functions.
LEARNING & IMPROVEMENT
Proactive to improve our experience and performance. Make things better.
Dig into root causes instead of only treating the immediate shortage or transaction issue.
Continue building knowledge of SAP, MRP, inventory management, purchasing, and service kit operations.
EFFICIENCY & EFFECTIVENESS
Use planning, processes and systems to achieve priority goals and use resources well. Get important things done efficiently.
Prioritize work based on customer impact, production risk, timing, and business value.
Analyze multiple data sources carefully and check conclusions against operational reality.
Make timely recommendations using available data, sound judgment, and documented assumptions.
Manage recurring responsibilities and urgent exceptions without losing follow-through.
LEADERSHIP
Create and sustain an organization that achieves meaningful results and where all team members can thrive. Lead by example.
Take ownership of material planning results and follow through on commitments.
Influence cross-functional action without relying on formal authority.
Model Hollingsworth values, critical thinking, accountability, and fact-based decision-making.
PERFORMANCE INDICATORS
Performance measures and targets will be established based on the business plan, role priorities, and available measurement systems. Measures may include:
Material shortages, delivery risks, and MRP exceptions are identified, escalated, and resolved with enough lead time for action.
Service kit delays attributable to material planning are reduced.
Planning parameters and reports are accurate, current, and completed on time.
Inventory exposure, excess, and obsolete material are identified and addressed.
Process improvements reduce recurring issues, manual effort, or avoidable inventory cost.
PHYSICAL REQUIREMENTS
The employee must be able to perform the essential functions of the role, with or without reasonable accommodation, including:
Frequently use a computer, keyboard, telephone, and other standard office equipment for planning, analysis, communication, and reports.
Sit or stand for extended periods at a computer and communicate effectively in person and in writing.
Occasionally move through warehouse or production areas to investigate material conditions and coordinate with operations.
ROLE REQUIREMENTS
Required
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.
Preferred
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.
#HLGSWRTH
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.
ROLE OUTCOMES
Shortages, excess inventory, obsolete material, and planning exceptions are identified early and addressed with clear action plans.
SAP planning parameters and material data are reviewed and maintained so system recommendations are reliable.
Supplier performance is monitored and reported, and shortfalls are addressed with suppliers and Buyers.
Supplier, customer, engineering, and production changes are translated into timely adjustments to material plans.
Supplier invoices are processed with accuracy and timeliness
ESSENTIAL JOB RESPONSIBILITIES
MATERIAL PLANNING AND REQUIREMENTS ANALYSIS
Analyze customer demand, bills of materials (BOMs), 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.
INVENTORY AND SUPPLY RISK MANAGEMENT
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.
SAP DATA AND PLANNING PARAMETERS
Review and maintain planning parameters in SAP, 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.
REPORTING AND ANALYSIS
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.
COLLABORATION AND PROCESS IMPROVEMENT
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.
PROJECTS AND OTHER DUTIES
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.
CORE COMPETENCIES
Self-check: if you already do several of these in your current role, you may be a strong fit for this role. Specific duties are listed in the section above.
COMMUNICATION & SERVICE
Work with others to achieve results important to internal and external customers. Help others succeed.
Raise material risks early and clearly, including the business impact, options, and recommended action.
Explain complex data and planning issues in a way others can understand and act on.
Build productive working relationships across Materials, Purchasing, Operations, and support functions.
LEARNING & IMPROVEMENT
Proactive to improve our experience and performance. Make things better.
Dig into root causes instead of only treating the immediate shortage or transaction issue.
Continue building knowledge of SAP, MRP, inventory management, purchasing, and service kit operations.
EFFICIENCY & EFFECTIVENESS
Use planning, processes and systems to achieve priority goals and use resources well. Get important things done efficiently.
Prioritize work based on customer impact, production risk, timing, and business value.
Analyze multiple data sources carefully and check conclusions against operational reality.
Make timely recommendations using available data, sound judgment, and documented assumptions.
Manage recurring responsibilities and urgent exceptions without losing follow-through.
LEADERSHIP
Create and sustain an organization that achieves meaningful results and where all team members can thrive. Lead by example.
Take ownership of material planning results and follow through on commitments.
Influence cross-functional action without relying on formal authority.
Model Hollingsworth values, critical thinking, accountability, and fact-based decision-making.
PERFORMANCE INDICATORS
Performance measures and targets will be established based on the business plan, role priorities, and available measurement systems. Measures may include:
Material shortages, delivery risks, and MRP exceptions are identified, escalated, and resolved with enough lead time for action.
Service kit delays attributable to material planning are reduced.
Planning parameters and reports are accurate, current, and completed on time.
Inventory exposure, excess, and obsolete material are identified and addressed.
Process improvements reduce recurring issues, manual effort, or avoidable inventory cost.
PHYSICAL REQUIREMENTS
The employee must be able to perform the essential functions of the role, with or without reasonable accommodation, including:
Frequently use a computer, keyboard, telephone, and other standard office equipment for planning, analysis, communication, and reports.
Sit or stand for extended periods at a computer and communicate effectively in person and in writing.
Occasionally move through warehouse or production areas to investigate material conditions and coordinate with operations.
ROLE REQUIREMENTS
Required
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.
Preferred
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.
#HLGSWRTH
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.