Materials Analyst

Aston Carter•Bellbrook, OH

2d•$40 - $50•Onsite

About The Position

The Materials Analyst is responsible for ensuring the right parts and materials are available in the correct quantities at the right time and in compliance with specific requirements. The role coordinates closely with engineering, procurement, production, and logistics to drive on‑time delivery while minimizing excess inventory and supporting cost‑avoidance initiatives.

Requirements

Advanced Microsoft Office skills particularly Excel pivot tables VLOOKUP/XLOOKUP Power Query macros/VBA and PowerPoint for executive presentations.
Hands-on experience with SAP ERP PP and/or MM modules is strongly preferred SAP
Experience in high-mix/high-volume discrete or process manufacturing industries.
Exposure to demand planning tools and statistical forecasting methods.

Nice To Haves

APICS CPIM Certified in Production and Inventory Management or CSCP Certified Supply Chain Professional certification strongly preferred.

Responsibilities

Own and manage the full MRP planning cycle including net requirements calculation planned order generation and exception message resolution.
Analyze and maintain MRP master data including bill of materials BOM item master parameters lead times lot sizes safety stock levels and reorder points.
Monitor MRP output daily prioritize action messages and coordinate with buyers and schedulers to ensure timely material availability.
Develop and maintain planning horizons freeze periods and MRP run frequencies aligned with business requirements.
Lead root cause analysis for material shortages excess inventory and planning-related production disruptions implementing corrective actions.
Serve as a functional user and primary resource for managing SAP MRP planning material control procurement and inventory modules.
Configure and maintain SAP MRP parameters including planning codes order policies lead times safety stock and buyer/planner assignments.
Execute and manage MRP processing runs within SAP analyze planning exceptions and coordinate resolution of system-generated action messages.
Leverage SAP ERP PP/MM modules experience where applicable support system integration data migration or dual-environment planning scenarios.
Collaborate with IT and ERP administrators on system enhancements patch testing and implementation of new planning functionality across SAP applications.
Train and support junior planners on SAP MRP transactions best practices and system navigation.
Develop and maintain advanced MS Excel models for demand forecasting capacity analysis inventory optimization and KPI dashboards.
Build and maintain reports using SAP reporting tools and custom queries previous experience with SAP is a plus.
Provide regular and ad hoc reporting to senior leadership on inventory turns service levels schedule attainment and planning accuracy.
Use data analysis to identify trends forecast demand variability and recommend changes to planning parameters.