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.
Qualifications
* Work with a modern data stack, including Redshift, BigQuery, Matillion, and Retool.
* 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.
Company & Benefits
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. As a Commercial Analyst in the Core Business Analytics team, you'll support the Commercial Operations function with a focus on stock exit and clearance performance. You'll partner with stakeholders across Trading, Commercial, Pricing, and Supply Chain to deliver insights that improve exit planning, reduce aged stock.
* ??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 be unnoticed.
* ?? And many more!
Recruitment Process
Our selection process is designed to be thorough, transparent, and aligned with the role. It includes: Please Note: As part of our recruitment process, we use AI-enabled tools to support screening and assessment.
#J-18808-Ljbffr