Lilly Financial Planning and Treasury Analyst in Cairo, Egypt
Title Financial Planning and Treasury Analyst
State / Province CAIRO
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
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.
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
Attention to details
Breadth and versatility
Influence and ability to drive business recommendations
Team player yet independent
Additional Information document to be uploaded
Removal Date 10-Oct-2017