Supply Chain Planning Assistant Analyst

About the role

The Supply Chain Planning Assistant Analyst supports end‑to‑end supply planning for European markets from PepsiCo’s Cairo Capability Center. The role focuses on system pre‑planning settings, weekly production planning, daily plan updates, and close collaboration with MRP and DRP teams to ensure plan execution.

Key responsibilities

• Maintain and update system planning settings to support pre‑planning and supply optimisation.
• Develop and publish weekly production plans aligned with demand, capacity and inventory targets.
• Perform daily plan updates reflecting demand changes and short‑term supply constraints.
• Collaborate with MRP and DRP teams to ensure effective execution of the agreed supply plan.
• Monitor demand and supply performance, highlighting risks, gaps and opportunities.
• Conduct ad‑hoc and regular analysis of demand fluctuations, production performance and supply constraints.
• Support continuous improvement initiatives within supply planning processes and tools.
• Ensure data accuracy and planning discipline across systems and reports.

Required profile

• Bachelor’s degree in Supply Chain, Industrial Engineering, Business Administration, Operations Management or a related field.
• 1–2 years of experience in supply chain planning, production planning or demand‑supply coordination.
• Experience in FMCG or multinational environments is a plus.
• Very good English (written and spoken) to support European markets.

Required skills

• Advanced Excel (pivot tables, formulas, data analysis, Power Query, VBA).
• Hands‑on experience with planning systems/ERP such as SAP APO or SAP IBP.
• Basic understanding of MRP and DRP concepts.
• Strong numerical and analytical abilities with high attention to detail.