Commercial Stock Analyst - Exit Management

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.

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

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, Big Query, Matillion, and Retool.

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.

What we offer:

• 33 days holiday, including bank holidays
• Health Cash Plan
• Life Assurance
• Incentive scheme based on company & personal performance
• Virtual GP
• Private Medical care
• FREE at-home blood test kit
• Holiday Purchase option
• Pension Contribution scheme
• Access to ‘Wellhub' with gyms, studios and wellbeing apps

• 25% Colleague Discount with FREE Standard Delivery
• Exclusive Discounts from a wide range of partners
• £/€50 Annual Product Allowance to spend in store

• Access to a variety of learning opportunities, including Level 2-5 Apprenticeships, Workshops and our Digital Learning Library
• AND MORE!

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

• 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