Category Planner - Fixed Term Contract (Maternity cover)
37.5 hours per week Monday – Friday
Competitive salary plus benefits package
Location: this role is based 3 days per week in our Glasgow Parkhead office (in our store) and the other two days at home dependant on business needs. The ability to travel to other stores across Scotland when required and occasional travel to our dedicated ecom fulfilment hub in Sunderland & Glenrothes.
About The Paint Shed
We are proud of our heritage. A family-run business for over 60 years, The Paint Shed has grown to become one of the UK’s fastest-growing trade paint retailers since opening our first store in Edinburgh. Today, we’re part of the Brewers Group, the UK’s largest independent paint merchant. Trade professionals and DIY enthusiasts trust us to deliver quality products and tools quickly and affordably. We’re committed to providing excellent service and a top range of products both in-store and online.
Job Description
Stock Forecasting (Focus on Hubs initially, move onto stores)
Key Line stock forecasting for online hubs, ensuring the key SKUs are never out of stock.
Work collaboratively with stock management and finance on budgets, stock value and stock turn, whilst maintaining flexibility to maximise growth.
Work with the warehouse manager to manage the intake of stock across online hubs, with a view of capacity and operational efficiencies.
Make suggestions on improvements on the stock flow and ordering process to maximise availability, efficiency and ensure we have the right stock, at the right time, in the right place.
Ensuring availability of live data to make informed trading decisions to proactively identify opportunities and risks at category and line level from a stock perspective.
Promotion Planning (Full Business)
Work in-line with the critical path to plan stock levels for promotional SKUs across the business.
Collaborate with wider team to roll out successful implementation of promotions using data driven insights to ensure profitability.
Work directly with our suppliers to give a forecast of the uplift in demand to ensure they can increase production so promotional SKUs are in stock at the right time.
Carry out monthly lessons learnt with the wider team, providing feedback and insights into stock turn and performance.
Work closely with the teams to ensure demand plans are reflective of current market trends and commercial opportunities.
Bulk Buying (Full Business)
Work with stores and hubs to maximise bulk buying opportunities, forecasting monthly stock levels and seasonal buys. Work in-line with monthly bulk buying schedules and ensure suppliers receive POs by deadline dates.
Collaborate with wider team to ensure capacity and space management in stores.
Calculate monthly credit values and work with finance to ensure bulk credits are received.
Actively work with the commercial team on timelines for cost price increases and rebate terms to recognise opportunities on bulk buying stock to maximise margin.
Reporting (Focus on Hubs initially, move onto stores)
Report on business stock levels and availability weekly, providing data led suggestions and insight on stock levels.
Working with large amounts of data to provide clear and accurate information for product categories on stock levels for range reviews, monthly, seasonal and ad-hoc reporting with a view to maximising profitability.
Owner of the never out of stock report, ensuring the SMT is kept updated with a view on stock levels of key lines.
You will be comfortable working with a large amount of data and manipulating to provide accurate and presentable reporting for the team.
Slow moving stock (Full Business, focus on ex-hubs)
Pro-actively make suggestions on stock movements or clearance offers based on slow moving lines.
Work with stock compliance to action clearing through slow moving lines in ex-hubs and stores, whilst owning the process end to end.
Maximise regional opportunities in stores by ensuring optimum £ per SQ FT – propose stock movements and replacements.
Benefits:
- Bereavement leave
- Casual dress
- Company pension
- Employee discount
- Enhanced paternity leave
- Life insurance
- On-site parking
- Work from home
Work Location: Hybrid remote in Glasgow G40 2UB
