MRP Buyer Analyst

 

Summary of Job 

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. 

Essential Functions and Responsibilities

 

MRP Execution & Purchasing 

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

 

Cost & Price Management 

- Track and analyze Purchase Price Variance (PPV)  
- Support cost control initiatives and identify opportunities for savings. 
 

Inventory & Obsolescence Control (E&O)  

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

 

Data Analysis & Reporting 

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

 

Internal & External Communication 

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

KPI Ownership & Continuous Improvement 

 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) 

 

Food Safety Responsibilities: 

• Follow all relevant food safety rules including SQF, cGMPs, and Food Defense. 

• Report any observed food safety violations to your supervisor immediately. 

 

Education and Qualifications 

Required Skills & Qualifications 

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

Preferred Qualifications 

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