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 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 23 years of experience in analyticspreferably 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!
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
#LI-Hybrid
#LI-CM