QUALIFICATIONS:

• Business degree, finance qualification (part qualified)
• 3-4 years’ experience in FP&A/analytical roles in retail. Experience in F&B would be advantageous.
• Excellent Excel capabilities; can demonstrate understanding and experience of Pivot Tables, VLOOKUP, SUMIF
• Highly proficient at manipulating and analysing large volumes of data in order to identify key commercial issues/trends.
• Familiar with using business intelligence tools like Business Warehouse or BI4
• Experience of SAP Business Intelligence and SAP Analysis for Office would be advantageous.

KEY SKILLS:

• 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/presentational and written communication skills and the ability to interact professionally with a diverse group (executives, accountants, store managers…)
• Fluent in English

JOB PURPOSE:

The primary purpose of this role is to provide strong and proactive assistance of the finance, and to partner with operational & commercial teams with analysis of the business, management reporting, budgeting and other ad-hoc finance analysis.
Contract: 37.5 hours per week
Benefits: Simplyhealth cash plan, Retail Trust, life insurance, and up to 25% in-store discounts

KEY RESPONSIBILITIES:

• Preparation of reports and presentations for internal and external stakeholders, including weekly & monthly performance reports and quarterly presentations for airports.
• Preparation of full platform P&L forecasts & presentations for corporate budgetary purposes (including sales, margin and store costs)
• Partnering with Commercial and Operations team to provide decision support on commercial initiatives including pricing & promotion analysis, modelling and making recommendations to drive business growth & development
• In-depth analysis of commercial results (sales, margin & stock, mix effects and KPI trends)
• Monthly end: preparation of accruals, variance analysis to improve accuracy of management accounts and to provide budget holders with insight to drive cost control. Monthly submission to group.
• Cashflow forecasting
• Ownership of monthly rent calculations and preparing data for audited rent certificates.
• Ad-hoc analysis upon request
• Supporting with business development opportunities