FP&A Sr Analyst

  • PepsiCo
  • New Cairo City, Cairo Governorate, Egypt

وصف الوظيفة


Responsibilities

Functional Responsibilities

  • Act as a single point of contact for the BU and cater for that specific BU’s SC Finance requirements.
  • Create / generate Commercial Finance reports by following DTPs (desk top procedures) and ensure that DTPs are continuously updated in line with process changes.
  • Perform the following activities:
    • Conduct comprehensive management reporting, including analysis and insightful commentary on variances and business performance.
    • Prepare monthly Management Business Review (MBR) reports, channel scorecards, key customer scorecards, pack-wise/portfolio scorecards, and location-wise scorecards.
    • Track weekly volumes and prepare monthly Distributor DII reports.
    • Monitor innovation performance and actualize volume data by flavor, supporting forecast integration.
    • Monthly actualization of financial models and preparation of monthly closing reports, including forecasting.
    • Performance management reporting including insightful commentary on variances and business performance
    • Financial modelling for Annual planning and rolling forecasts
    • What - if and scenario analysis
    • Data collection to support decision making by BU team
    • Other adhoc data and report requests
  • Ensure timely and accurate submission of reports and data to the relevant BU in line with agreed SLA
  • Collaborate with data scientists and modellers to test outputs and refine them
  • Support Commercial Finance Tower lead in projects related to simplification and standardization of reports. Provide assistance as SME in process improvement and technological enhancements and implementation
  • Participate in COE monthly management committee meetings as part of the on-going governance structure to track initiatives progress, change requests, policy changes and overall COE performance
  • Participate in COE Weekly connects with COE team and BU team to review KPIs and performance, Process accuracy and team management (hiring, releasing, on boarding)
  • Transformation/Digitization (Mosaic)
    • Oversee the transition to the new Mosaic tool, ensuring accuracy and completeness during monthly closing.
People Responsibilities

  • Coach and on- board new members of the team in ways of working and processes

Qualifications

  • 6-8 years of experience in finance and planning with specific experience in Commercial & Category finance
  • Bachelor’s/Master’s Degree in commerce/business administration / economic with high level of Finance & Accounting Experience. Chartered Accountant/MBA/CPA Finance is preferred.
  • Sound knowledge of financial systems (SAP, Tableau, MS Office and Other financial reporting systems)
  • Strong understanding of business processes (financial and SC)
  • Preferred Lean/Six Sigma Trained & having Excel Expertise
  • Strong technical knowledge and experience of both Management reporting and planning processes
  • Experience with working with GBS (Preferred FMCG sector) will be an added advantage
  • Good communication skill. Proficiency in English (must)& Arabic (Preferred) language

Essential

  • Highly organized and responsive, with ability to work to SLAs and tight deadlines
  • Numerate and a lateral thinker, good at data analysis, with a strong attention to detail
  • Proven experience of working with ambiguity and managing multiple projects/tasks