At a Glance
- Tasks: Analyse stock exit performance and optimise markdown strategies with data-driven insights.
- Company: Join Holland & Barrett, Europe's largest health & wellness retailer with a trusted global brand.
- Benefits: Enjoy 33 days holiday, health cash plan, and exclusive discounts.
- Other info: Hybrid role with excellent learning and development opportunities.
- Why this job: Make a real impact on stock clearance decisions and enhance your analytical skills.
- Qualifications: Degree in a quantitative field and 2-3 years of analytics experience required.
The predicted salary is between 35000 - 45000 £ per year.
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.
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, and optimise margin recovery on markdown and end-of-line activity.
Location: This is a hybrid role, with 2 days per week expected in Nuneaton office at CV10 7RH
The Role
- 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
- 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
- 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.
- Discounts & Savings: 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!
Stock Exit & Markdown Analytics Specialist in Nuneaton employer: Holland and Barrett
Holland & Barrett is an exceptional employer, offering a vibrant work culture that prioritises employee wellbeing and professional growth. With generous benefits such as 33 days of holiday, a health cash plan, and access to extensive learning opportunities, employees are empowered to thrive both personally and professionally. Located in Nuneaton, this hybrid role fosters collaboration across teams, ensuring that every team member contributes to the company's mission of becoming the world's most trusted wellness partner.
StudySmarter Expert Advice🤫
We think this is how you could land Stock Exit & Markdown Analytics Specialist in Nuneaton
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those at Holland & Barrett. A friendly chat can open doors and give you insights that job descriptions just can't.
✨Tip Number 2
Show off your skills! If you’ve got SQL chops, why not create a mini-project or dashboard? Share it on LinkedIn or during interviews to demonstrate your analytical prowess and creativity.
✨Tip Number 3
Prepare for the interview by understanding their business model. Dive into how they manage stock clearance and markdowns. This will help you speak their language and show you’re genuinely interested in the role.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re keen on being part of the StudySmarter community.
We think you need these skills to ace Stock Exit & Markdown Analytics Specialist in Nuneaton
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Stock Exit & Markdown Analytics Specialist. Highlight your SQL skills and any experience with commercial operations or analytics. We want to see how your background fits with our mission at Holland & Barrett!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about health and wellness, and how your analytical skills can help us improve stock clearance and margin recovery. Let’s see your personality come through!
Showcase Your Analytical Skills:In your application, don’t forget to mention specific projects where you’ve used data analysis to drive decisions. Whether it’s building dashboards or running SQL queries, we want to know how you’ve made an impact in previous roles.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come in through our own platform!
How to prepare for a job interview at Holland and Barrett
✨Know Your SQL Inside Out
Since the role requires SQL proficiency, make sure you brush up on your querying, joining, and transforming skills. Prepare to discuss specific examples of how you've used SQL to analyse stock or sales data in previous roles.
✨Understand the Business Context
Familiarise yourself with Holland & Barrett's business model and the health and wellness industry. Be ready to talk about how pricing strategies and stock clearance impact overall performance, showing that you can think commercially.
✨Showcase Your Visualisation Skills
As you'll be building dashboards in Metabase, bring examples of your previous work. If possible, prepare a mock dashboard to demonstrate your ability to present data clearly and effectively, highlighting key insights.
✨Be Ready for Collaboration Questions
This role involves working cross-functionally, so expect questions about teamwork. Think of examples where you've successfully collaborated with different teams, particularly in analytics or commercial operations, and how you navigated any challenges.
