ABOUT THE ROLE Red Bull Egypt is seeking a dynamic and strategic Financial Planning & Analysis Manager to lead our FP&A team providing critical insights and recommendations to the leadership team on strategic choices, budgets, forecasts, and both short- and long-term plans. RESPONSIBILITIES Areas that play to your strengths All the responsibilities we'll trust you with:
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.
EXPERIENCE Your areas of knowledge and expertise that matter most for this role:
Minimum of 8 years of relevant FP&A experience in a similar organization.
