Materials Analyst Req# 1167

Hollingsworth LLC

Dearborn (MI)

On-site

USD 65,000 - 90,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Hollingsworth LLC in Dearborn, MI is seeking a Materials Analyst to support the Material Planning team for automotive service kits. You will analyze demand, inventory, supplier, and production data to create actionable material plans and resolve shortages or excesses.

You will work with the Materials Data Coordinator to maintain SAP parameters, monitor supplier performance, and drive improvements in inventory and planning processes.

Qualifications

  • Bachelor's degree in supply chain, business, operations, analytics, or a related field.
  • At least 2 years of experience in material planning, purchasing, inventory control, production planning, or 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 and ability to identify discrepancies and root causes.
  • Ability to manage priorities, communicate risk, and drive cross-functional follow-through.
  • Excellent written, verbal, interpersonal, and teamwork skills.

Responsibilities

  • Analyze demand, BOMs, inventory, open POs, production schedules, and lead times to determine material requirements for service kits.
  • Review MRP recommendations and planning exceptions; create, adjust, or elevate material plans based on priorities and constraints.
  • Monitor material availability from order through kit completion and coordinate recovery plans for shortages.
  • Balance service, inventory, and cost considerations when recommending order timing, quantities, substitutions, or schedule changes.
  • Partner with Buyers and suppliers to confirm material availability and resolve timing concerns.
  • Review supplier performance and drive corrective actions with suppliers.
  • Develop and interpret SAP and Excel reports on shortages, inventory exposure, and planning exceptions.

Skills

Analytical thinking
Problem solving
Attention to detail
Teamwork
Prioritization

Education

Bachelor’s degree in supply chain, business, operations, analytics, or related field

Tools

Excel
MRP systems
SAP
ERP systems

Job description

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 elevate 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Materials Data Coordinator
Materials Data Coordinator

Hollingsworth LLC • Dearborn (MI)

On-site
USD 60,000 - 90,000
Material Planner
Material Planner

The Lion Brewery • Pittston

Hybrid
USD 65,000 - 85,000
Strategic Inventory & Materials Planner
Strategic Inventory & Materials Planner

Hollingsworth LLC • Mishawaka (IN)

Hybrid
USD 55,000 - 85,000
Materials Manager
Materials Manager

Medbio, LLC • Grand Rapids (MI)

On-site
USD 90,000 - 130,000
Materials Analyst
Materials Analyst

Stark Aerospace • Columbus (MS)

On-site
USD 65,000 - 90,000
Material Planning Specialist
Material Planning Specialist

HYUNDAI MOBIS • Ellabell (GA)

On-site
USD 55,000 - 75,000
Materials Planner
Materials Planner

HYVA CORPORATION • Elk Grove Village (IL)

On-site
USD 55,000 - 75,000
Materials Planner
Materials Planner

Jost International • Elk Grove Village (IL)

On-site
USD 65,000 - 90,000
Senior Supply Chain Planner
Senior Supply Chain Planner

BayOne • Michigan

On-site
USD 75,000 - 95,000
Materials Planner
Materials Planner

Jost International • Illinois

Hybrid
USD 55,000 - 85,000