Logo of Huzzle

Commercial Stock Analyst - Exit Management

  • Job
    Full-time
    Junior & Mid Level
  • Data
    Marketing
  • Coventry

AI generated summary

  • You need SQL skills, commercial awareness, strong communication, delivery ownership, visualization abilities, and a collaborative mindset, plus a relevant degree and 2-3 years of analytics experience.
  • You will analyze stock exit challenges, build performance dashboards, evaluate pricing strategies, run SKU deep dives, collaborate with cross-functional teams, and contribute to analytics projects.

Requirements

  • 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.

Responsibilities

  • 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.

FAQs

What is the main focus of the Commercial Stock Analyst role?

The main focus is on stock exit and clearance performance, collaborating with stakeholders in Trading, Commercial, Pricing, and Supply Chain to improve exit planning and optimize margin recovery.

What tools will I be using in this role?

You will be working with a modern data stack that includes Redshift, BigQuery, Matillion, and Retool.

What qualifications are required for this position?

A degree in a quantitative field such as Mathematics, Statistics, Economics, or Engineering, along with 2–3 years of experience in analytics, preferably in commercial operations, pricing, or inventory analytics.

Will I be expected to work in the office?

Yes, this is a hybrid role with an expectation of 2 days per week in the Nuneaton office.

What type of analytics work will I be doing?

You will be analyzing stock, sales, and markdown performance using SQL, building dashboards in Metabase, and running deep dives into underperforming SKUs.

What kind of benefits does Holland & Barrett offer?

Benefits include 33 days holiday, Health Cash Plan, Life Assurance, incentive schemes, private medical care, and access to wellness resources.

Is there an emphasis on collaboration in this role?

Yes, a collaborative mindset is essential as you will be working across Commercial, Supply Chain, and Pricing functions.

How does the recruitment process work?

The recruitment process includes an interview with the Hiring Manager, a case study, follow-up reviews, and discussions with team members to assess fit and working style.

What kind of dashboards will I be expected to build?

You will build dashboards in Metabase that track exit performance, markdown effectiveness, and aged stock risk.

Will I have opportunities for professional development?

Yes, there are various learning opportunities available, including apprenticeships, workshops, and access to a digital learning library.

Making health and wellness a way of life for everyone.

Science & Healthcare
Industry
5001-10,000
Employees
1870
Founded Year

Mission & Purpose

Holland & Barrett is a leading wellness retailer and one of the largest in Europe. We make health and wellness a way of life for everyone, with a leading range of own brand, innovative vitamins, supplements, specialist food, sports nutrition and ethical beauty brands. Established in 1870, Holland & Barrett has been trusted for wellness for over 150 years and has an omnichannel retail presence of more than 1000 stores across 18 countries worldwide, including over 800 in the UK and Ireland**Holland & Barrett’s colleagues are “qualified to advise” with in depth training in nutrition and supplements to give accessible personalised advice to customers on their individual needs. We’re passionate about helping every colleague thrive across all dimensions of wellbeing, and we’re committed to having a diverse and inclusive workplace. In line with our EPIC values (Expertise, Pioneering, Inclusive, Caring), we embrace and actively celebrate all our colleagues unique and varying experiences, backgrounds, identities and cultures - I am me, we are H&B.