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
What we need for this role
- Experience within 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
- PowerPoint
- 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