Commercial Finance Analyst

Commercial Finance Analyst
up to £45k depending on experience
West London / Hybrid working

The primary purpose of this role is to provide strong and proactive assistance of the finance & commercial teams with analysis of the business, management reporting, budgeting and other ad-hoc finance analysis

In-depth analysis of commercial results (sales & margins, mix effects)
Preparation of sales and margin forecasts for corporate budgetary purposes
Preparation of reports and presentations for internal and external business stakeholders, including weekly & monthly performance reports and quarterly presentations for each platform where the business operates concessions
Commercial financial support to operations (Store Managers, Operations Director) and to the Commercial Department (promotions analysis)
Ad-hoc analysis upon request of the Operations or Finance directors
Assistance for monthly financial closings (e.g. Newport submissions for the group, stock provisioning reports)
Preparation of business plans for new stores including IRR appraisal

Candidate Specification:

MBA, Business Degree,
Excellent Excel capabilities - can demonstrate understanding and experience of pivot tables, v lookups, sumif, index, equiv... Highly proficient at manipulating and analysing large volumes of data in order to identify key commercial issues/trends
Fluent in English
Familiar with using Business Intelligence tools like Business Warehouse or BI4
Experience of SAP Business Intelligence and SAP Analysis for Office would be advantageous
Retail background would be preferred
Experience of modelling the financials of new stores/products would be advantageous

Able to work independently and suggest solutions to queries raised
Strong attention to details/accuracy/controls of data
Strong analytical skills
Ability to organise work around tight deadlines
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group (executives, accountants, store managers…)