Financial Planning and Analysis Analyst (6 Months)

JOB SUMMARY:

Based in the Allergan Aesthetic office in Egypt, Cairo and reporting to the Commercial Finance Lead, AA, the FP&A function and will be spear-heading the Company’s financial quarterly forecast, annual budgeting process, operating plan variance analysis and special projects. Provide financial consulting and strategic support to senior management and Business Heads, including preparing board presentations, financial presentations, industry/peer group comparisons, and other projects requested by senior management.

KEY DUTIES AND RESPONSIBILITIES:

Financial Planning, Reporting and Analysis (60%)

• Work collaboratively with the Country Manager & Commercial team to develop annual budget, quarterly forecasts and long-range plans.
• Participate in budgeting and forecasting processes in collaboration with the Area Finance
• Prepare standard reporting packages each period for business and finance management consumption.
• Analyze current and past trends in key performance indicators including all areas of revenue, cost of sales, expenses and recommend appropriate budget (selling & promotional) levels.
• Monitor performance indicators, highlighting trends and analyzing causes of unexpected variance.
• Ensure effective support processes are in place, departmental strategies are upheld, objectives are being met and recommending actions as required to remain on track.
• Prepare insightful monthly analysis of actual results vs. budget/forecast and commentary.
• Monthly review, validation, and reporting of promo & selling expenditures.
• Highlight areas of potential under /overspend and adjust full year targets as appropriate.
• Provision of Selling & Promotional expenditures.
• Design and improve complex financial models to support detailed forecasting and planning
• Prepare product profitability analysis.
• Implement Dashboard reports.
• Collect data from commercial team and analyze to generate related reports (number of customers, profitability, etc.)
• Prepare presentations to Senior Management Team.
• Ensure compliance with company policies and procedures and supports company mission, values and standards of ethics and integrity.
• Perform ad-hoc analyses in support of business initiatives.
• Support due diligence efforts when required.
• Evaluation of financial impact of changes to distributor terms (commissions, selling allowances…) and Price-referencing against other countries.
• Pricing evaluations (Comparison across markets, Identify price increase opportunities/threats, Ensure pricing strategies consistent across markets).
• Tracking SG&A spend and highlighting Risks and Opportunities .
• Ensures all reports and disclosures comply with applicable government regulations, professional standards and organization policies.
• Analyze data to ensure proper accounting procedures have been followed.
• Analysis and submission of weekly sales flash to APACMEA.
• Prepare month end report and ensure timely submission in line with Regional FP&A schedule.

In-market inventory management and forecast evaluation (30%):

• Work with commercial team to determine fair stock level targets.
• Proactively track product movements in line with these targets.
• Ensure inventory levels received from distributors monthly.
• Ongoing monthly reporting of inventory levels, proactively highlighting areas of concern.
• Analyze potential impact of the actual shipments on the in-country inventory levels and inform commercial team of any potential risk of deviating from the agreed inventory targets
• Monitor distributor forecast accuracy.
• Working closely with supply chain team on country demand review to understand In-market performance and highlight risks, if any, to management’s attention, to implement correction plan.

Free of Charge Goods Monitoring (10%)

• Monitor amount of Free of Charge goods provided by Allergan to distributors.
• Ensure amounts are in line with Allergan guidelines.
• Collect data from distributors to show what Free of Charges goods are being used for.
• Monitor any outstanding Free of Charge goods owed by Allergan to distributors and ensure liabilities are settled promptly or that appropriate amounts are accrued.

JOB QUALIFICATIONS:

The requirements described in this section are representative of those that must be met by an employee to successfully perform the essential functions of this job.

Education and Experience

• Graduation in Finance / Accounting.
• A minimum of 5 years’ experience as a financial analyst in a global Pharmaceutical Company.
• Evidence of commercial awareness.
• Ability to communicate professionally in English.

Essential Skills and Competencies (includes Licenses, Credentials)

• High degree of accuracy with an extremely good attention to detail.
• Advanced Microsoft Excel and PowerPoint skills.
• Well organized and able to prioritize during time pressured periods.
• A general interest in commercial and marketing issues relevant to the financial planning and management of a healthcare business.
• Ability to build positive working relationships across country teams where challenge and contribution is the norm.
• Responsive and proactive.
• Able to work independently as well as part of a team.
• High level of Analytical Skills and Business understanding.

Others

• Excellence Focused – demonstrating passion and commitment to turning strategy into reality, driving results by focusing on prioritization, continuous improvement and innovation.
• Inquisitive – showing curiosity; asking questions and challenging the status quo to make strong decisions.
• Optimistic – has a positive outlook; aligns with business needs and has a can-do attitude.