Financial Planning & Analysis Manager

Financial Planning & Analysis

• Prepare Master Budget for Red Bull Egypt.
• Analyze current and past trends in key performance indicators including all areas of revenue, cost of sales, expenses, and capital expenditures.
• Oversee and manage the continued development of Budgeting, Financial Forecasting, Operating Plan and Modeling tools.
• Analyze complex financial information and reports to provide accurate and timely financial recommendations to management for decision making purposes.
• Pave the way for new investment proposals, through owning the preparation of new business cases, supporting the S&M teams with new launches through providing ROI financial modelling,..etc.
• Calculate and report monthly P&L variance analysis and conduct monthly meetings with department heads to discuss variances and advise appropriate action to reduce budget gap.
• Monitor performance indicators, highlight trends and analyze causes of unexpected variances.
• Team up with the Supply Chain team leads to monitor the achievement of COGS targets and provide the correct analysis of COGS/custom clearance trends, risks and opportunities.
• Calculate the customer & price mix impact on the total P&L.
• Calculate/reports the major KPIs (Financial Sales, DSO), basic exposure rate, advanced exposure rate.
• Prepare contingency plans.
• Prepare reports on aggregated or on detailed level by GKA and LKA comparing the profitability YTD, comparing PY vs CY vs RE vs Year to Go.
• Prepare the international exposure rate report.
• Prepare and distribute a detailed monthly report including comments on brand, project (= internal order), account, and cost center level using SAP, BI and Hyperion for each budget owner and GM
• Prepare and manage the cash flow statement.
• Prepare transfer price calculation and propose the fair IC price.
• Prepare long range plan (LRP) 3 years plan.
• Prepare trade term impact simulations, challenges assumptions and profitability.
• Work closely with the Key Account Managers on reducing the exposure between customers/products.
• Benchmark the costs of marketing activities and their impact on the consumer and challenges where appropriate. Consider potential 3rd party sponsoring income and question assumptions.
• Support the budget owners in budget reallocations and ensure overall budget adherence
• Calculate the profitability of the new products after one year to compare the launch proposal’s basic and advanced exposure rate.

People Management

• Manage the FP&A team in Egypt by setting challenging individual and team objectives, reviewing, and rewarding performance, providing timely feedback and support a climate for continuous improvement.
• Build a team of highly engaged and motivated people.
• Develop and regularly update the job descriptions for all accounting staff.
• Ensure that sufficient resources are in place and each position is held by a person with the appropriate qualification.
• Agree on annual objectives and link variable pay to the achievement levels.
• Hold bi-annual performance reviews giving clear, honest and fair feedback.
• Promote development and internal trainings to elevate knowledge levels within the team.
• Assure that all key processes are documented in writing and that checklists are being used.

Requirements

• Minimum of 8 years of relevant FP&A experience in a similar organization.
• Strong leadership skills/strong leadership track record.
• Capable of communicating precisely, effectively, and convincingly based on facts with internal and external stakeholders.
• SAP, Hyperion, HFM and BI knowledge is a plus.
• A structured and well-organized individual.
• Must be self-motivated, self-directed and be able to work under pressure in a fast-paced team environment.
• Fluency in English & Arabic (verbal and written)