Finance Data Analyst

Finance Data Analyst - Day Rate Contract Inside IR35

3 days per week in the office, Chertsey Surrey

Key Skill - Advanced Excel - Pivot Tables, Vlookups, Formula etc

Profit and Loss

• Customer segmentation Analysis. Understand the brief, report framework and metrics. Update the report, gather insights and issue within the agreed SLA’s.
• Support Innovation Business Cases. Understand the brief, report framework and metrics. Update report, gather insights and issue within the agreed SLA’s
• Production of Level Up Deep Dive Analysis:
  Understand the brief and reporting framework. Run the analysis and gather insights for Channel PIC’s line with agreed SLA’s
• Always on Proposition:
  Understand brief and proposed report framework, deliver and maintain report in line with current business requirements and ensure delivery in line with SLA
• Delivery and Service Proposition. Working with PIC, understand brief, identify data, agreed metrics, KPI’s and frequency and report framework. Ensure delivery in line with agreed SLA’s.
• SKU Rationalisation and Range Management. Ensure the delivery of the reports in line with the agreed SLA. Monitor / review report framework and data to ensure fit for purpose. Gather insight for weekly / monthly reporting
• Support multiple channels, D2C, EPP, SMB, Shop APP and ePromoter with reporting requirements.
• Recommend ways to optimise report production to speed up production and efficiency
• Provide training and guidance to help team engage with reports effectively

• Experience with in e-commerce
• Accounting based financial modelling / scenario modelling (must have)
• Accountant / analytics / numbers background
• Experience in working with digital data such as traffic, conversion, bounce rates etc…
• Evidence of using digital tools to analyse data
• Passion for metrics, strong analytical skills and the ability to get into the details, whilst also seeing and understanding the big picture
• Technical Skills with analytical tools:
• SQL
• Looker
• Advanced Excel (Power Pivot, formulae and Pivot Tables)
• QLIK or similar tool, ability to create new reports within the tool
• Power Point
• Able to prioritise, deliverables and partners
• Ability to problem solve and take ownership of a project
• Good presentation skills and both verbal / written communication
• High attention to detail
• Able to work with accuracy in a fast pace and dynamic environment