Procurement Analyst Manager

Line Up Aviation; England; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading aviation company is seeking a Procurement Analyst Manager to oversee procurement processes, manage MRP, and leverage Power BI for data analytics. Key responsibilities include stock management, supplier relationship management, and compliance with company policies. Candidates should have a degree in supply chain management and proficiency in Excel and Power BI.

Qualifications

• Demonstrated experience in procurement, material planning, or supply chain analytics.
• Ability to build and maintain effective relationships with staff, stakeholders, and suppliers.
• Keen focus on accuracy and detail in all aspects of procurement and data management.

Responsibilities

• Run the MRP process to identify stock replenishment needs.
• Support the team in preparing purchase orders based on MRP outputs.
• Leverage Power BI for procurement analytics and develop dashboards.

Skills

Advanced proficiency in Microsoft Excel

Experience with Power BI or similar data analytics tools

Ability to manage MRP processes

Effective communication

Time management and prioritization skills

Education

Bachelor's degree in supply chain management, business administration, or related field

Tools

Power BI

SQL

Python

Job description

Overview

As the Procurement Analyst Manager, you will be responsible for overseeing the procurement process, managing material requirements planning (MRP), master data, and purchase order approvals. This role involves leveraging Power BI for data analytics, creating reports and dashboards, and managing forecasting processes to ensure optimal inventory levels and supplier relationships. The manager will work with internal and external stakeholders to drive continuous improvement, enhance forecast accuracy, and ensure compliance with company policies.

Role

Role: Procurement Analyst Manager

Location: Hemel Hempstead

Hours: Monday to Friday, 08:30 - 17:00

Salary: On Application

Responsibilities

• Run the MRP process to identify stock replenishment needs and address stock shortages. Maintain and update MRP parameters, including supplier lead times, sales forecasts, minimum stock limits, and preferred suppliers.
• Support the team in preparing and raising purchase orders for stock replenishment based on MRP outputs. Oversee validation and approval of purchase orders to ensure accuracy and compliance.
• Ensure stocking levels are maintained at optimal minimum and maximum levels to support business needs and customer order fulfilment.
• Maintain and manage accurate master data within procurement systems to ensure reliable MRP outputs and reporting.
• Leverage and manage Power BI to design, develop, dataflows, semantic models, and interactive dashboards for procurement analytics and provide actionable insights for procurement and inventory management.
• Troubleshoot data discrepancies and ensure alignment between operational data and reporting metrics.
• Present actionable insights to senior management and stakeholders using data visualizations and performance dashboards.
• Oversee quarterly forecast reviews, collaborating with internal and external stakeholders to refine forecasts. Research and implement advanced forecasting techniques (e.g., statistical modelling, machine learning) to improve accuracy and reduce stockouts or overstocking.
• Build, maintain, and manage relationships with suppliers, ensuring consistent communication and a professional approach to all interactions.
• Ensure compliance with company guidelines, purchasing policies, and procedures during all procurement activities.
• Work closely with the procurement team to identify opportunities for process improvements, cost reduction, and business enhancements.
• Engage with internal and external stakeholders to align procurement strategies with business objectives and drive operational efficiency.
• Facilitate cross-functional meetings to address supply chain risks, resolve bottlenecks, and drive process improvements.
• Train and mentor junior procurement staff on MRP systems, data analysis tools, and best practices.

Requirements

• A bachelor9s degree in supply chain management, business administration, or a related field is preferred, though equivalent experience will be considered.
• Demonstrated experience in procurement, material planning, or supply chain analytics.
• Demonstrated success in managing MRP processes, inventory optimization.
• Ability to add value and contribute to process and business improvements.
• Computer literacy with advanced proficiency in Microsoft Excel and experience with Power BI or similar data analytics tools, hands-on experience with Power BI, SQL, or Python for data analysis is advantageous.
• Ability to work in a fast-paced environment with tight deadlines and multiple priorities.
• Familiarity with integrated Enterprise Resource Planning (ERP) systems and prior experience in material planning. Advanced Excel skills and proficiency in Power BI for data analysis and reporting.
• Ability to build and maintain effective relationships with staff, stakeholders, and suppliers.
• Effective time management and prioritization skills to meet deadlines and achieve set targets.
• Deep understanding of commercial and financial impacts of procurement decisions, particularly on business operations and customer order fulfilment.
• Effective communication with various stakeholders, including senior management, suppliers, and junior staff.
• Willingness to research and implement advanced forecasting techniques and stay up to date with best practices.
• Ability to work well under pressure, handling emergencies and stressful situations with composure.
• Keen focus on accuracy and detail in all aspects of procurement and data management.