Commercial Stock Analyst - Exit Management

HOLLAND AND BARRETT; Nuneaton; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

A leading health and wellness retailer in the UK is looking for a Data Analyst to support their analytics organization. This hybrid role requires SQL skills and the ability to analyze stock and markdown performance. You will collaborate with various departments, build dashboards in Metabase, and contribute to data-driven decisions. Benefits include a technology incentive scheme, extensive learning and development opportunities, and a supportive work environment focused on wellbeing.

Benefits

Technology Incentive Scheme

Learning and Development opportunities

Pension company contribution

28 or 33 Days Holiday

Refer and Earn Scheme

Discounted Products

Free 24/7 Confidential Advice

Mental Health First Aiders

Qualifications

• 2-3 years of experience in analytics, preferably with commercial operations, pricing, or inventory analytics.
• Able to explain trends to commercial and supply chain stakeholders clearly.
• Manages own tasks in agile delivery, balancing speed and accuracy.

Responsibilities

• Partner with Trading, Supply Chain, and Commercial Ops to identify stock exit challenges.
• Build dashboards in Metabase to track exit performance and markdown effectiveness.
• Write SQL to analyze product, store, and channel-level outcomes.

Skills

SQL proficiency

Commercial awareness

Communication

Delivery ownership

Visualisation skills

Collaborative mindset

Education

Degree in a quantitative field (Mathematics, Statistics, Economics, Engineering)

Tools

Metabase

Redshift

BigQuery

Matillion

Retool

Job description

About Data at Holland & Barrett

At Holland & Barrett (H&B), we want to empower everyone to live healthier, happier lives. With over 150 years of experience, we're the largest health & wellness retailer in Europe and a globally trusted brand. Our ambition is to become the world's most trusted wellness partner, chosen by over 100 million people worldwide.

Our Analytics organisation is structured into five verticals: four embedded analytics areas aligned to key business functions, and a central Business Intelligence team focused on cross‑functional reporting and performance enablement. Together with our Data Engineering and Data Science colleagues, we make data a strategic lever to achieve H&B's goals.

The Role

What You'll Do

• Partner with Trading, Supply Chain, and Commercial Ops to identify stock exit challenges and help shape smarter clearance decisions.
• Build dashboards in Metabase that track exit performance, markdown effectiveness, and aged stock risk.
• Write SQL to analyse product, store, and channel‑level clearance outcomes.
• Evaluate effectiveness of pricing levers, discounting mechanics, and exit channel strategies.
• Provide visibility into exit performance against forecast, target, and historic benchmarks.
• Run deep dives into underperforming SKUs, range transitions, and residual inventory impact.
• Collaborate cross‑functionally with BI Developers, Embedded Analysts, and Pricing & Promotions teams to deliver data products.
• Contribute to sprint planning and backlog shaping as part of the Commercial Ops analytics roadmap.
• Work with a modern data stack, including Redshift, BigQuery, Matillion, and Retool.

Location: This is a hybrid role, with 2 days per week expected in either our Nuneaton office (CV10 7RH)

The Person

What We're Looking For

• SQL proficiency: Comfortable querying, joining, and transforming data to analyse stock, sales, and markdown performance.
• Commercial awareness: Understands pricing, lifecycle, and margin trade‑offs related to stock clearance and end‑of‑line management.
• Communication: Able to clearly explain trade‑offs and performance trends to commercial and supply chain stakeholders.
• Delivery ownership: Manages own tasks within agile delivery, balancing speed and accuracy.
• Visualisation skills: Builds usable dashboards in Metabase that support operational planning.
• Collaborative mindset: Works well across Commercial, Supply, and Pricing functions.
• Education & Experience: You have a degree in a quantitative field such as Mathematics, Statistics, Economics, or Engineering, and 2‑3 years of experience in analytics—preferably with exposure to commercial operations, pricing, or inventory analytics.

Benefits

Technology Incentive Scheme – we offer different bonus schemes for all grades in Technology, starting at 10%.

Learning and Development opportunity with Holland & Barrett is a great base for career development long term.

Career progression

Pension company contribution

Your wellbeing is paramount so you can get away and take 28 or 33 Days Holiday per year.

Refer and Earn Scheme – as we're growing you can earn money by referring people to join us from your network.

Epic Extras gives you access to exclusive benefits, free advice and savings from a range of retailers and providers.

Stay healthy with Discounted Products – from day one you'll get a 25% discount (on top of other promotions) when you shop at H&B on anything that you buy.

We all need a little help sometimes, so we offer Free 24/7 Confidential Advice & Colleague Welfare.

Mental Health First Aiders – we have lots of qualified Mental Health First Aiders because its all about your health & wellbeing.

We have colleague Reward and Recognition Schemes, so your hard work and loyalty won't go unnoticed.

And many more!

Our Recruitment Process

Our selection process is designed to be thorough, transparent, and aligned with the role. It includes:

• A short Coderbyte assessment to evaluate core technical and analytical skills
• Role‑specific questions to understand your approach to relevant challenges
• An interview with the Hiring Manager to explore your experience and motivations
• A case study to demonstrate problem‑solving and strategic thinking
• A follow‑up review to delve deeper into your insights and approach
• Short conversations with team members to assess team fit and working style

Please Note: As part of our recruitment process, we use AI‑enabled tools to support screening and assessment. These are designed to make the process fairer, faster, and more consistent, while all final decisions remain with our recruitment team.