Overview
hackajob is collaborating with Holland & Barrett to connect them with exceptional professionals for this role. Commercial Stock Analyst - Exit Management (36907)
About Holland & Barrett
At Holland & Barrett (H&B), we want to empower everyone to live healthier, happier lives. With over 150 years of experience, were the largest health & wellness retailer in Europe and a globally trusted brand. Our ambition is to become the worlds 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
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.
The Person
What Were 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
What we offer:
Wellbeing & Lifestyle Benefits
* 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
Learning & Development
* Access to a variety of learning opportunities, including Level 2-5 Apprenticeships, Workshops and our Digital Learning Library
* AND MORE!
Our Recruitment Process
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
J-18808-Ljbffr