PepsiCo Careers

Control & Reporting Analyst

Nasr City, Egypt

Egypt - English

Job Description

Auto req ID: 136577BR
External Posting Title: Control & Reporting Analyst

Job Description

Main Purpose
Supply Chain Analyst will be responsible to ensure proper inventory valuation by maintain accurate standard cost, validate correctness of variances accounts and maintain quality of inventory and reserves account reconcile. He / she will be leading process improvements and interventions from time to time to achieve process simplification, better controls and process standardization.


Financial Reporting

  • Adherence to closing agenda timeline
  • Prepare monthly inventory physical count procedures across all locations
    • Follow-up with plant controllers to resolve all issues that may be raised during the count process
    • Ensure that the count is performed according to Pepsico’s policies and procedures
    • Communicate/analyze physical count results and provide justification to management regarding the count differences
    • Secure management’s approval as per the latest SOA on the count differences and reflect such differences on SAP
  • Prepare the inventory reserve analysis, secure needed approvals and ensure proper recording;
    • Finished goods reserve
    • Raw materials reserve
    • Spare parts reserve
  • Monitor inventory in transit between all locations and warehouses and Investigate any abnormal activities
  • Check unit price per category in B/S vs. COGs
  • Check inventory GL accounts ending balances are reconciled with the Auxiliary reports for each inventory category
  • Ensures no negative inventory stocks at month-end
  • Write-off process;
    • Responsible for the write off process across all locations
    • Prepares the write off analysis and secure the needed approvals
Performance Management reviews
  • Conduct Monthly and Quarterly detailed Balance Sheet review for all Inventory accounts together with the necessary aging and COC
  • Highlight of any balance sheet risks to management
  • Prepares monthly inventory deck comparing actual vs. previous month and last year
  • Monthly tracking for breakage, damaged products and expired products by; (Beverages Only)
    • DC
    • Price point
    • SKU
  • Update the supplier allocation sheet for Raw&Pack ending stocks
  • Issue monthly Operations Deck
Audit & Compliance
  • Support both external and internal audit for inventory related matters
  • Ensure business compliance with Statutory, Legal and Taxation requirements, PepsiCo corporate and local business policies & procedures, and ethical business practices
  • Partner with BPO (Business process Owner) and CO (Control Owner) in GCS and Fraud risk assessment, monitoring self testing and remediation of failures
  • Maintain updated GCS MIM process
  • Ensure timely closure of;
    • Internal audit remediation and track progress
    • BAIC issues
  • Ensure adherence of SoA as per approved local policies and enforce execution
  • Ensure timely GCS testing (Quarterly)
  • Perform sudden visits to all warehouses to perform sudden counts
Business Partnership:
  • Review all SC contracts and evaluate costs
  • Attend S&OP meetings and engage to enhance MRP process
Planning and Forecasting
  • Partner with Supply chain and planning finance to develop and track financial matrics and validate assumption for productivity projects to ensure tangible savings are delivered to P&L
  • Partner with Planning Finance to ensure working capital forecast accuracy and improvements through Inventory (DII) and Cash Flows Analysis
Special Projects
  • Identify scope for process improvements and interventions from time to time to achieve process simplification / better controls / process standardization / accounting / outsourcing
  • Lead & partner with BIS to implement system enhancements of COGS and inventory management areas


Key Skills/Experience Required

  • 4+ years’ experience Foods & Beverages business
  • Solid understanding of business levers
  • Go-To-Person on Performance Metrics, Productivity Process and Best Practices around Metrics.
  • Ability to work cross-functionally, cross-geographically and across multiple cultures
  • Strong internal and external communicator, influencer, and negotiator.
  • Ability to set and priorities short, mid and long term objectives.
  • Bachelor of Accounting/Finance subject
  • Postgraduate qualification preferable

Relocation Eligible: Not Eligible for Relocation
Job Category: Finance
Job Type: Regular