MRP Buyer Analyst

CORPORATE - MOUNT FRANKLIN FOODS LLC•Hodgkins, IL

5d•$65,000 - $70,000•Onsite

About The Position

The MRP Buyer Analyst is responsible for executing purchasing activities based on MRP signals from the Infor M3 ERP system, ensuring on-time procurement, optimal inventory levels, cost control, and supplier performance. This role requires strong analytical capabilities, advanced Excel proficiency (pivot tables, charts, macros), and a solid understanding of supply and demand dynamics within the food and beverage industry. The position is KPI-driven, requiring familiarity with both industry-standard metrics and internal company performance indicators. The MRP Buyer Analyst plays a key role in maintaining supply continuity, supporting strategic decision making, and driving continuous improvement across procurement operations.

Requirements

Bachelor’s degree in supply chain, Business, Engineering, or related field.
Minimum 3 years of experience in MRP-based purchasing, preferably in food & beverage.
Strong knowledge of ERP systems ( Oracle, SAP, BAAN,etc), ideally Infor M3.
Advanced Excel skills: pivot tables, VLOOKUP, charts, macros (Essential).
Strong analytical mindset with ability to interpret large datasets and generate actionable insights.
Excellent communication and negotiation skills.
Detail oriented, organized, and proactive.

Nice To Haves

Experience with supplier scorecards, cost analysis, and forecast modeling.
Knowledge of food safety regulations and quality standards.

Responsibilities

Process MRP messages including Pull-in, Push-out, and Cancellations.
Generate and manage purchase orders based on system demand and forecasted requirements.
Ensure Purchase order on time delivery from suppliers.
Monitor and act on shortage reports, past due reports, and supply & demand reports.
Track and analyze Purchase Price Variance (PPV)
Support cost control initiatives and identify opportunities for savings.
Monitor inventory levels to avoid excess stock, obsolete materials, and stockouts.
Support inventory health through proactive MRP Messages execution
Monitor Expiration ingredients Inventory Reports
Participate in inventory reviews internally and with customers.
Develop and maintain Excel based tools for analysis and projections using pivot tables, charts, and macros.
Ensure data integrity across procurement reports and ERP entries.
Provide visibility into purchasing trends, supplier performance, and forecast accuracy.
Maintain active communication with internal stakeholders (planning, operations, warehouse finance) and external customers/suppliers.
Ensure alignment on material needs, delivery schedules (BluJay), and service expectations.
Own and track key performance indicators such as:
On time delivery rate (Past Due Reports accuracy)
Purchase order accuracy
Inventory turnover
PPV/FPPV trends
System Data integrity Maintenance (LT updates, Delivery Terms, ETA Accuracy, etc)
Follow all relevant food safety rules including SQF, cGMPs, and Food Defense.
Report any observed food safety violations to your supervisor immediately.