Data & Analytics Jobs in New Cairo City, Egypt (Now Hiring) — 48 open — Page 2

Responsibilities

• Financial Reporting - Month End Close Process - Adherence to closing agenda timeline - Prepare the monthly inventory physical count procedures across all locations Ø Follow-up with plant controllers to resolve all issues that may rise 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.
• Get the approval of management as per the SOA on the count differences and reflect such differences on SAP - Conduct monthly detailed Balance Sheet review for all Inventory levels together with the necessary aging and COC - Highlight of any balance sheet risks - Prepare the inventory reserve analysis, secure needed approvals and ensure proper recording.This reserve analysis consist of
• Finished goods
• Raw materials
• Spare parts. - Monitor the inventory in transit between all locations and warehouses. Investigate for any up normal activities in the transit areas - Check the unit price per category in B/S vs. COGs - Update the FG auxiliary report with the PBI variance capitalization manual entry (Beverages Only) - Check the ending balances on Inventory GL accounts are reconciled with the Auxiliary reports for each inventory category - Ensures no negative inventory stocks at month-end - Update the supplier allocation sheet: R&P ending stock from auxiliary report, receipts from MB51, PO price/unit t-code ME2N
• Monthly tracking for breakage, damaged products and expired products by; (Beverages Only)          Ø DC          Ø Price point          Ø SKU
• Prepares monthly inventory deck comparing actual vs. previous month and last yearIssue monthly Operations DeckWrite-off process;        Ø Responsible for the write off process across all locations        Ø Prepares the write off analysis and secure the needed approvalsBSR preparation on a quarterly basisMonitor the implementation of the policies and procedures. This include the followings:• Enforce execution of approved local SoA• Enforce execution of Inventory process and procedures• Report any violations/exceptions to OPS controller• Identify any process gap and enhance the workflow to optimization  and share the results with the OPS director
• Partner with SC director to conduct annual MIM routine risk assessment workshop
• Conduct the annual fraud risk assessment with SC Sr. director
• Follow-up to close all internal audit points, Corporate audit points as per the recommended deadline
• Ensure proper execution of COSO controls
• Ensure timely GCS testing (Quarterly)
• Support the OPS controller in the Preparation of the audit committee
• Perform sudden visits to all warehouses to perform sudden counts
• Manages KPMG requirements for Supply chain (should be monthly process going forward)
• Review all SC contracts and evaluate costs
• Attend S&OP meetings and engage to enhance MRP process
• Manages WC initiatives, DII and forecast accuracy

 

 

 

Qualifications

• Finance / Economics degree from an accredited school
• Minimum 2 years of experience.
• Ability to work on own initiative and within a pressurized environment.
• Excellent customer service, interpersonal and communication skills.
• Excellent command of Arabic and English language.
• Problem solving skills.
• Ability to adapt to change and work with different stakeholders coming from different backgrounds
• Proficiency in Microsoft office, numerical & analytical skills, presentation skills, high level of communication skills, and ability to work under pressure.
• Ability to work in teams