Description
Excel Reporting Analyst - Bracknell, Berkshire
£144.00 per day (Inside IR35) plus 25 days holiday and Bank holiday paid leave (pro rata), 50% of time working from home
Our client a truly global brand is urgently seeking an experienced Excel Reporting Analyst to assist in improving synergies across their customer's digital purchase and ownership journey and synchronise the on-line and off-line customer experience.
The role holder will need to maintain and develop a number of Excel and Microstrategy reports, as well as contributing to the development of new reporting systems and understanding new trends as they support customers digitally with new features and new services.
Key skills:
- Google Analytics or On-line Retail Analytics
- Advanced Excel (Pivot tables, Macros, Formatting)
- Data Analysis experience
Main Responsibilities:
- The role holder will be responsible for data analysis within the New Business and Sales Operations departments:
- Analysis of all data related to Digital Retail Platform focusing on High Value Behaviours and reporting on the trends, understanding the main factors affecting these trends and developing insights for senior management.
- Must have some Google Analytics experience or at least some Online Retail Analytics experience (Digital Platform analytics experience)
- Modelling of customer behaviour to understand closing ratio at different stages of the sales funnel: from Unique Visitors, Brochure Requests, Customer Account Registration, Leads shared and orders placed.
- Data analysis of sales figures (for European regions)
- Develop the central European reporting function keeping and improving data reliability, accuracy of reporting, and data coherence.
- Support Sales Planning activity by providing relevant analysis for Regional Sales Managers (RSM).
- Collection and analysis of each market's short term (current month) business forecast, wholesales, and COI (customer orders).
- In coordination with RSM highlight main risk/opportunity from performance analysis.
- Support New Business team to accurately collect customer data, analyse, report and provide support to senior business stakeholder strategy.
- Produce daily reports to monitor the take up of connected services.
- Produce monthly reports to monitor the Programme.
Excel Reporting Analyst - Bracknell, Berkshire