This vacancy is now closed

Stock Analyst (£35,000 - £47,000) - Glasgow - City Centre

Ref: 241 Date Posted: Monday 17 Sep 2018
LinkedIn ShareShare

Stock Analyst

This role will be based in Glasgow and require extensive travel between the Glasgow sites and our Speyside based distillery


We have an exciting new opportunity for a Stock systems Business Analyst to join the Macallan team. This role will guide the usage of stock by the whisky making team, validating future sales plans via the stock model. This will enable us to highlight risks to the plan, or its execution, by analysing the stock and its usage.


This role will report to the Stock Planning & Allocations Manager, with key responsibilities for the role including:

  • Portfolio validation via use of the optimisation model (with particular, though not exclusive, involvement in the 5 year plan).
  • Support the long term planning (LTP) exercise to enable an understanding of the impact on cashflow and capex at various production volume scenarios.
  • Decision making support for the whisky making team in the areas of variant development; tactical use of stock; strategic direction for variants and reporting.
  • Monitor actual stock usage and highlight trends which may represent a risk either in the short or long term.
  • Identify and execute technical system developments in order to drive continuous improvement to the Macallan stock modelling exercise.
  • Data analysis (including sensitivity analysis) for different development possibilities such as predicting likely performance of stock and incorporating those results in the stock model.
  • Work closely with Insights team to develop and improve the market led forecasting (IWSR) exercise.
  • Analysis and interpretation of racking results to support Whisky making team in developing a racking protocol.
  • Advisory support to relevant system upgrades, e.g. TESS and EDFSS and act as key business unit representative for bulk stock design authority.
  • Provide support and assess impact on the stock model of external stock purchases.
  • Work with Specialist Projects Leader to implement improvement initiatives such as extractives


The successful applicant have excellent planning and forecasting skills (ideally within industry), with an ability to manage and analyse complexity. You will be educated to degree level, or equivalent, with a good understanding of systems development and an ability to interact with others cross functionally.


Closing Date for applications:
Monday 24th September 2018

Download Job Profile