Finance Analyst : Excel Expert : Design & Developing Tools:
Title: Finance Analyst : Excel Expert : Design & Developing Tools: World Energy Oil Co
Rate: cGBP200 per day
Start date: ASAP
Duration: 3 months
World Leading Global Energy Oil Company has an exciting opportunity for a Finance Analyst to conduct financial analysis projects and statistical studies. You will be an Excel expert to help design & develop tools, using excel marco.
The work will be developing 2 Tools to deliver OP18 plan operationalisation of IFRS 16 impacts as well as managing Real Estate OPEX performance management and other MI reporting KPIs, including providing Real Estate OPEX on IAS 17 basis to meet 2019 actual Group Reporting requirements.
*Gather data from multiple sources in excel format and local currency
*Complex data covering multiple years/months, countries, individual site IDs, for transactions captured for planning, actual and future forecasting.
*One–off data load for plan data but needs to be updated on a monthly basis for actual and forecasting
*Transformation of data to USD plus aggregation of USD data by Region and Global hierarchy
*Output in form of excel extracts and/or ability to extract to Retail Data Platform
*Developing a Planning tool for OP18 plan IFRS 16 operationalisation as well as having the functions of providing forecast
*Tool for simplified IFRS16 Lease Accounting calculation for planning and forecasting purposes
*Gather data from multiple sources in excel format in local currency including extracts from Group IFRS16 Tool
*Build model for ROU Asset, Lease Liability, Depreciation and Interest IFRS16 calculations by lease and site level for both Plan and forecasting
* Requires a bachelor's degree and 3–5 years of experience in the field or in a related area.
* Has knowledge of commonly used concepts, practices, and procedures within a particular field.
* Ability to look at business requirements and design and develop a tool that is fit for purpose using Microsoft tools such as Excel / Access
* Finance/ accounting background beneficial
This needs combining with a positive attitude and an ability to work within a large, globally dispersed project team in a multi–cultural environment. You also need to be a self–starter, a logical thinker and a quick learner, with strong initiative and excellent communication, interpersonal and presentation skills, able to write clearly and concisely.
We believe in equality of opportunity for all job applicants regardless of gender, marital status, race, colour, nationality, ethnic origin, creed or religion, disability, sexual orientation or age.
Specialising within Energy Trading, Oil & Gas, Financial Markets and TV & Entertainment, Eaglecliff Recruitment is ISO accredited, a Member of REC and listed within the top 4% for Financial stability by Dun & Bradstreet. Please telephone for an immediate response or email your CV for a reply within one hour. Eaglecliff Ltd is acting in the capacity of an employment agency for permanent recruitment and an employment business for contractor resourcing.