Data Analyst - E-Commerce

Our client is a large multi-site retailer and we need an experienced Finance Business Partner to join the E-Commerce team and deliver high-quality data & financial insight and support. You will be a bit of a pro when it comes to large sets of Data and have large retail, FMCG or Pharmaceutical background.

Reporting into the head of E-Commerce, they need a strong Analyst to connect the dots & alert for whats ahead.

Our client requires someone with extensive experience in Excel, VBA, Power Query & Power BI. Our client is a large, complex Retail Group with a large e-commerce platform & stores across the UK & Ireland.

This role is ideal for someone who thrives on data management and enjoys working with spreadsheets, while also business partnering across stakeholders to gain insight and up to date changes.

Skills required:

Essential:

• Advanced Excel skills (formulas, pivot tables, data analysis).
• VBA, Power Query & Power BI experience ideally
• E-commerce or retail / product pricing experience

Desirable:

• Familiarity with Power Query, basic formulas, auditing, or light data transformation workflows.
• Interest in learning about data pipelines, integrations and automation.
• Python or SQL experience
• Finance Qualifications up to PQ - but not essential

Duties include:

• Leading monthly forecasting, variance analysis and financial modelling
• Automate data processes where possible using advanced Excel functions or VBA.
• Use advanced Excel skills (VLOOKUP/XLOOKUP, INDEX/MATCH, pivot tables, Power Query, data validation, conditional logic) to transform, clean and prepare data.
• Build and manage complex Excel spreadsheets for pricing analysis, margin tracking, and promotional planning.
• Business partner with a wide range of teams across Finance, Marketing, Distribution Centres
• Present weekly reports to senior stakeholders

You will also:

• Support and work closely with the head of E-commerce & partner with Finance, marketing and distribution teams to maintain strong relationships between all departments
• Support the creation of streamlined data processes, so updates made in one area flow cleanly into others.
• Assist with mapping data between systems (e.g., ERP, PIM, CMS, marketplace feeds).
• Help maintain master data files and support the development of a 'single source of truth.'

This is a fantastic opportunity for someone who enjoys variety and wants to play a key role in e-commerce team. You'll have the chance to shape processes and work on exciting data projects that drive business growth.

BH35368