Merchandising Analyst

Retail Human Resources plc; St Albans; Hybrid; GBP 41,000 - 50,000; Full time

Benefits offered by this job

Hybrid work arrangement

Benefits package

Job summary

Retail Human Resources plc is seeking a Merchandising Analyst for a 4-5 month fixed-term contract in St Albans. The role is hybrid (2 days in the office, 3 days at home) with a salary of £45,000 plus benefits.

You'll analyse large data sets to influence commercial decisions, working closely with merchandising, trading and leadership teams. Essential skills include Advanced Excel, Power BI, SQL and Python, with experience in retail analytics.

Qualifications

• Advanced Excel skills with Pivot Tables and Power Query.
• Experience analysing large data sets in retail or B&M environments.
• Ability to present insights to stakeholders and influence decisions.

Responsibilities

• Analyse large volumes of data and convert insights into commercial recommendations.
• Evaluate product performance, pricing, promotions, and inventory productivity.
• Assess customer behaviour, purchasing trends and store space productivity.

Skills

Advanced Excel

Power BI

Data analysis

Presentation skills

Retail analytics

Tools

SQL

Python

Tableau

Job description

Merchandising Analyst (Fixed Term Contract)

St Albans (Hybrid) £45,000 + Benefits

4-5 Month Fixed Term Contract 2 Days Office / 3 Days Home

An exciting opportunity has arisen for an experienced Merchandising Analyst to join a well-established retail business on a fixed-term basis, supporting a major systems implementation project.

This role is ideal for someone who has progressed from a Senior Assistant Merchandiser or Junior Merchandiser background and moved into a dedicated analytical position, using data to influence commercial decision-making across a retail environment.

The Role

Working closely with merchandising, trading and leadership teams, you'll be responsible for analysing large volumes of data and transforming insights into clear commercial recommendations that improve sales, margin, stock productivity and customer growth.

Key areas of analysis will include:

• Product performance
• Pricing effectiveness
• Promotional activity
• Inventory productivity
• Customer behaviour and purchasing trends
• Store space productivity

What We're Looking For

We're seeking a commercially minded analyst with experience gained within a retail or B&M environment who can confidently interpret complex data and provide actionable recommendations.

You'll have a proven track record of influencing trading decisions through analysis and insight, with examples of how your work has driven measurable business improvements.

Technical Skills

Essential:

• Advanced Excel skills, including Pivot Tables and Power Query
• Strong analytical and reporting capability
• Experience presenting insights to stakeholders
• Power BI experience

Desirable:

• Tableau
• SQL
• Python or a similar analytical coding language

Why Apply?

This is a fantastic opportunity to join a successful retail business during an exciting period of change, playing a key role in supporting major projects while delivering valuable commercial insight.

Salary: £45,000 (2 days office, 3 days remote) Contract: 4-5 Month Fixed Term Contract

If you're an experienced merchandising professional with strong analytical skills and a passion for turning data into commercial results, we'd love to hear from you.

Reference: PH - 1004