Lilly Financial Planning and Treasury Analyst in Cairo, Egypt


Title Financial Planning and Treasury Analyst

City Cairo

State / Province CAIRO

Country Egypt

Workplace Arrangement Local

Company Overview (Lilly is one of the top 10 global pharmaceutical companies, dedicated to creating medicines that help improve peoples' quality of life for more than 140 years. Since our founding by Colonel Eli Lilly in 1876, we have pioneered medical breakthroughs like human insulin, the polio vaccine, and many other breakthrough therapies...

At the heart of Lilly's operations are its core values – excellence, integrity and respect for people, these are reflected in business practices that include strong governance principles, the ethical development of medicines, transparency and ethical product promotion)

Responsibilities Financial analysis profile:

  • Identifies trends and recommends improvements accordingly.

  • Collaborate with CFO in development of budget, planning and corporate financial requirements.

  • Prepares and evaluates complex profit plans, operating records, and financial statements.

  • Preparation of studies, reports, and analyses in areas such as budgets, forecasts, financial plans, governmental requirements, statistical reports, cash flow projections, and business forecasts.

  • Coordinates with all levels of management to gather, analyze, summarize, and prepare recommendations regarding financial plans, acquisition activity, new business planning, trended future requirements, government requirements, and operating forecasts.

  • Calculate and load detailed technical information for the annual Business plan ( incl. sales/price/volume ) as well as budgets planning and loading into SAP for cost center/cost element planning purposes

  • Review and analyze monthly Local Sales

  • Use of SMART tool to drive business co-relations in term of sales segmentations

  • Transform & automate OPEX reporting

  • Monthly detailed OPEX analysis by cost center and review with budget holders , Identify saving opportunities and ensure full OPEX control

  • Ensure business events are properly reflected in the financial scorecards (review of all lines of IS)

  • Enhance OPEX forecasting and provide a more structured OPEX forecasting model with P2P/SAP expertise

  • Conduct business analysis to analyze and support pricing recommendations

  • Makes recommendations to management regarding cost & expenses saving or profit generating opportunities and profitability improvement strategies.

  • Partner with business development in investment projects and business cases.

  • Respond to ad-hoc requests from Corporate/region

  • Provides strategic pricing analysis to recommend appropriate pricing levels for management

  • Assists organization's controller in the development of the budget, planning and other corporate financial requirements.

  • Ensures quality regular reporting of financial data

  • Has ownership of corporate Pricing and Product Addition Request as defined by the company.

  • Ensure quality fiduciary controls is place in disbursement and pricing

  • Analyze financial information to determine past, present and future financial performance in all areas of the business

Treasury profile:

  • FX trading, forecasting and coordination of hedging activities.

  • Assist in the effective management of cash by ensuring timely payments are made and funds invested.

  • Coordinate with corporate to arrange inter- company funding as needed for organizational requirements.

  • Open new bank accounts when required and liaise with banks for necessary documentation required.

  • Update constitutional documents, signatories list, passport copies of all signatories and Board Resolutions.

  • Handle bank guarantees issued for tenders, renewals and cancellations.

  • Handle letters of credit namely opening, amendments and follow up in an expedient manner.

Monitoring of cash flow movements and expected cash requirements.

Basic Qualifications

  • Bachelor degree, commerce, economics, finance, accounting

  • 3-7 years in finance, minimum 3 yrs in financial planning is a must

  • CFA-MBA is an asset

  • Fluent English is a must- French is an asset

  • Analytical skills

Additional Skills/Preferences

  • Attention to details

  • Breadth and versatility

  • Business oriented

  • Influence and ability to drive business recommendations

  • Team player yet independent

Additional Information document to be uploaded

Removal Date 10-Oct-2017