Browse Jobs
For Employers
Post JobLog inGet Started

Planning and Analysis Specialist - (Egypt/Libya/Sudan)

Cairo, Egypt
Posted 6 years ago
211Applicants for1 open position
  • 29Viewed
  • 7In Consideration
  • 17Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Position Overview:

Job Summary:

Performs calculations and submissions regarding the Actuals Reporting and Forecasts (RE/BP) in his/her responsibility area within EAG. Supports BU P&A Team in optimization and standardization of Planning & Analysis’ processes and tools within his/her responsibility area.

Helps BU P&A Team to create routines and collaborative partnerships to document and share best practices broadly.

Supports Region Finance and BU P&A organizations for efficient, effective and sustainable finance processes and transactions; provides services according to business needs while leveraging leading finance practices across the Group. Ensures timely and accurate financial statements are being provided.

Job Profile:

KEY DUTIES/RESPONSIBILITIES:

Performs Actuals Reporting in his/her responsibility area, while adhering to closing calendar deadlines.

  • Performs actual UC reporting
  • Ensures actual UC volume is accurate and available in BOFC
  • Prepares for weekly UC sales reporting
  • Performs GP analysis
  • Confirms finalization of actual postings with CPS
  • Ensures concentrate revenue and costs are accurately posted
  • Performs GP reallocation calculation, if required
  • Ensures accuracy of concentrate write off accruals
  • Calculates GPIE on quarterly basis and sends JV to RFC and supporting documents to HQ
  • Ensures deduction JV is posted timely & accurately
  • Performs actual DME closing
  • Performs activities for DME reconciliation and charges to/from Bottlers
  • Reviews charter campaigns and charge out to BUs
  • Reconciles prepaid expense balance in coordination with GFO
  • Ensures MPP phasing is accurate in MEM
  • Performs year-end & month-end DME accruals
  • Runs and validates sales curve adjustment
  • Performs actual OPEX closing
  • Obtains and controls OPEX actuals and post accrual JVs if required
  • Identifies OPEN PO line items and submits OPEX accrual JVs to GFO
  • Prepares equity income JV and narratives
  • Performs financial control and analysis
  • Reviews, controls and analyzes P&L for actual closing
  • Performs B/S reconciliation (analyze GL accounts and validate the figures)
  • Prepares and submits monthly, quarterly, annual and ad-hoc actual reports including
  • Manual templates
  • Actual closing narratives (P&L and OPCAP)
  • Management Reporting deck for Regions, BUs, EAG
  • Ad-hoc reports prepared upon Region, BU requests
  • Quarterly CAPEX reporting
  • Quarterly SEC representation letter submission
  • Annual UC P&L execution and BC reporting•

Management of Forecasts (RE/BP) in his/her responsibility area, while adhering to RE/BP calendar deadlines:

  • Prepares input assumptions and adjusts BPC according to Region / BU requests:
  • OR/PF
  • Concentrate shipment planning (inventory based, DSI based, or manual)
  • Volume driven rebates, freight, sales tax
  • OPEX
  • DME
  • Working capital
  • Performs RE/BP financial statement line items and adjusts according to Region/BU guidance. Performs RE and BP activities
  • Uploads UC and CSE forecast in BPC
  • Deduction planning in BPC
  • GPIE calculation
  • DME planning in BPC (including FDW extractions)
  • OPEX planning in BPC (including coordination of OPEX input files in BP period)
  • Equity income planning in BPC
  • B/S forecasting in BPC
  • UC P&L planning in BPC
  • Coordinates input and output templates with Regions and BUs
  • Prepares RE/BP interim output reports for Regions and BUs during planning period
  • Compiles and performs RE/BP management reporting and financial consolidation at BU level
  • Controls and analyzes BP/RE management reports (scorecards, dashboards, brand contribution, MEM reports)

Job Requirements

QUALIFICATIONS / COMPETENCIES / SKILLS:

  • The ability to apply forecasting techniques and skills to develop and evaluate business goals and strategies, analyzing information to derive insights and implications to initiate planning and/or re-planning, and controlling financial results.

Foundational competencies:

  • Accepting and building accountability
  • Building value based relationships
  • Communicating effectively
  • Initiating action
  • Planning and organizing
  • Thinking systematically

Technical skills:

  • Financial analysis
  • Planning and forecasting skills
  • Performance management
  • GAAP, cost accounting / analysis
  • Information technology

RELATED EXPERIENCE REQUIREMENTS/ QUALIFICATIONS:

  • Minimum 4 years of experience
  • Accounting experience is a strong plus

EDUCATIONAL REQUIREMENTS:

  • University/Bachelor’s degree - Minimum
  • Postgraduate/Master’s degree - Preferred

CULTURAL DIVERSITY:

This position requires working in diverse environments and with multicultural teams.

TRAVEL REQUIREMENTS:

  • Minimal travel is required through BU locations.

ADDITIONAL INFORMATION:

The key success-criteria is:

  • Communicate clearly about financial concepts in order to act as a true business-partner with local Finance.
  • Working for specific regions through a Business Insights Network (pool of resources), but when needed supporting other regions within the BU.

Featured Jobs

  • Senior Treasury - Maadi, Cairo22 days ago
    Logo
  • E-Commerce Fulfillment Special... - Nasr City, Cairo29 days ago
    Logo
  • Commercial Planning & Analyst - Cairo, Egypt2 months ago
    Logo
  • Senior Business Market Researc... - Nasr City, Cairo2 months ago
    Logo

Similar Jobs

Search other opportunities
JobsAnalyst/ResearchPlanning and Analysis Specialist - (Egyp...