Overview
Commercial Stock Analyst - Exit Management. As a Commercial Analyst in the Core Business Analytics team, you will 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.
Responsibilities
* Partner with Trading, Supply Chain, and Commercial Operations 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.
Location
Location: This is a hybrid role, with 2 days per week expected in either our Nuneaton office (CV10 7RH).
The Person
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.
Benefits
* Technology Incentive Scheme - bonus schemes for all grades in Technology, starting at 10%.
* Learning and Development opportunities with Holland & Barrett for long-term career development.
* Career progression
* Pension company contribution
* Wellbeing: 28 or 33 days Holiday per year.
* Refer and Earn Scheme
* Epic Extras: access to exclusive benefits, free advice and savings from retailers and providers.
* Discounted Products: 25% discount from day one on shop purchases at H&B (on top of other promotions).
* Free 24/7 Confidential Advice & Colleague Welfare and Mental Health First Aiders.
* Colleague Reward and Recognition Schemes.
Our Recruitment Process
Our selection process is designed to be thorough, transparent, and aligned with the role. It includes:
* A short Coderbyte assessment to evaluate core technical and analytical skills
* Role-specific questions to understand your approach to relevant challenges
* 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