Supply & Demand Planner

Beer52; City of Edinburgh; Hybrid; GBP 40,000 - 56,000; Full time

Job summary

Beer52, Edinburgh, seeks a Supply & Demand Planner to own short- and long-range forecasts and demand plans across all product types, aligning with marketing activity to determine optimal purchasing volumes.

You will report to the Supply Chain Director, collaborate with 3PL partners, and drive improvements in forecast accuracy, stock control and proactive reporting—minimising waste and ensuring timely despatch for subscriptions and shop listings.

Qualifications

• Highly numerate with advanced Excel or Google Sheets skills.
• Able to turn data into clear, visual reporting for the wider business.
• Strong understanding of stock control, including short-dated stock.

Responsibilities

• Taking account of current and future stock, create and implement short, full-theme and long-range forecasts and demand plans.
• Collaborate with the marketing team to understand their plans and reflect these in forecasting.
• Partner with the Head Buyers to drive commercial opportunities through the timing of themes and ensure stock availability for retail opportunities and partnerships.
• Calculate and submit purchasing volumes for subscriptions and shop through a defined S&OP process, ensuring sign-off with the Supply Chain Director.
• Report on stock levels, weekly progress on reducing excess and short-dated stock, and upcoming risks.
• Work with the 3PL to plan and direct production, minimising delays to order despatch.

Skills

Numerate

Excel

Data visualization

Stock control

3PL coordination

Communication

Organised

Tools

Excel

Google Sheets

Job description

As our Supply & Demand Planner, you’ll play a pivotal role in getting the right products to our members at the right time. You’ll own our robust short and long-range forecasts and demand plans, bringing together seasonal patterns, customer trends and upcoming marketing activity to determine optimal purchasing volumes across all of our product types.

About role

You’ll build the long-term view of our monthly themes, finding smart ways to put excess legacy kits and theme stock to good use where appropriate. From there, you’ll break that plan down into full theme forecasts and fortnightly production plans, agreed with our 3PL partner.You’ll also be the go-to person for stock reporting, reconciling our internal view of stock against supplier stock levels, taking into account both regular reporting and every stock movement, so the business always has an accurate picture.Great communication is key to success in this role. You’ll work closely with your own team and the wider business, bringing data to life through clear, visual reporting that gives everyone complete transparency.Working alongside our Supply Chain Director and Operations Manager, you’ll have the opportunity to shape how we plan, driving improvements in forecasting accuracy and building processes that reduce excess stock and risk.

Key responsibilities

• Taking account of current and future stock, create and implement short, full-theme and long-range forecasts and demand plans.
• Collaborate with the marketing team to understand their plans and objectives and reflect these in forecasting.
• Partner with the Head Buyers to drive commercial opportunities through the strategic timing of themes, and to ensure consistent stock availability for retail opportunities and permanent listings with key partners.
• Calculate and submit purchasing volumes for subscription and shop through a defined S&OP process, using available technology to improve accuracy, and work with the Supply Chain Director to ensure a smooth sign-off.
• Report on overall stock levels, weekly progress on reducing excess and short-dated stock, and upcoming risks and priorities.
• Work with marketing, the Operations Manager and the Supply Chain Director to clear short-dated stock, including promotional packs and shop activity, so that every short-dated item has a plan and no expired product is used.
• Work with our 3PL to plan and direct production, minimising delays to order despatch.
• Work with the wider team to plan brew and drawdown schedules for Welcome Box beer and wine, and to ensure consistent availability of non-core items such as packaging, magazines and snacks.
• Work with the Supply Chain Director and Operations Manager to deliver peak forecasts and forward plans that manage volume increases.
• Develop robust processes and tools that promote good practice and continuous improvement.

About you

• Highly numerate, with advanced Excel or Google Sheets skills.
• Able to turn data into clear, visual reporting for the wider business.
• Strong understanding of stock control, including short-dated stock.
• Confident working with 3PLs and suppliers.
• A clear communicator who builds strong relationships across teams.
• Organised and detail-focused, with a drive to improve processes and reduce waste.

Skills and experience

• Experience in demand planning or forecasting, ideally in FMCG, food and drink or e-commerce.
• The chance to influence and shape one of the fastest-growing areas of our business, with genuine scope for career progression.
• A collaborative, energetic working environment.

About working with us

Beer52 | B Corp is the home of the UK’s No.1 craft beer club, and now a family of four discovery clubs spanning beer, wine, whisky and coffee. Each month, members receive hand-selected, small-batch products chosen by experts, delivered to their door alongside stories that bring each discovery to life, including Ferment, the UK’s No.1 craft beer magazine.Our mission is to build the world’s leading community of curious drinkers, connecting people through discovery and a shared love of quality, independent producers. With over 9 million member reviews and counting, our community is at the heart of everything we do.As a certified B Corp, carbon neutral business and accredited Living Wage employer, we’re committed to using business as a force for good. Based in Edinburgh, our team works in a fast-growing, collaborative environment where curiosity, creativity and a passion for great drinks and community-building are truly valued.If you love numbers, enjoy solving puzzles and want to make a real impact in a growing B Corp business, we’d love to hear from you!