Analyst (Blend Formulae)

Pernod Ricard

Dumbarton

Hybrid

GBP 32,000 - 48,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive salary
Private medical insurance
Pension/Defined Contribution
Employee assistance programme
Generous annual holiday
Life Assurance
Brand allowances
Rewards & recognition
Employee discounts
Office events

Job summary

Pernod Ricard is hiring an Analyst (Blend Formulae) on a fixed term contract in Kilmalid, Dumbarton, with a hybrid working pattern. The role focuses on preparing blend formulae to support sales, analysing maturing inventories from 3 to 60 years, and ensuring stock solutions meet demand while preserving quality.

You will collaborate with Blenders, BOM and Operational Planners, using tools like Excel and Power BI to drive data-informed decisions.

Qualifications

  • Brings relevant experience from a similar role or transferable experience.
  • Enjoys working with data and using analytical and problem-solving skills.
  • Able to build positive working relationships, collaborate with others, and handle information with care and confidentiality.
  • Comfortable using digital tools and data, with experience of some or all: Excel, Power BI, SMP, E1, OBI or similar systems.

Responsibilities

  • Produce vatting instructions to meet plans within formula parameters and quality criteria.
  • Ensure availability of spirit and support planning for vatting, bottling and exports; update quality information on the system.
  • Support inventory availability through stock allocation and balance current and future requirements.
  • Work with warehouse colleagues to optimise space using data tools and ensure smooth operations.

Skills

Excel
Power BI

Tools

SMP
E1
OBI

Job description

Analyst (Blend Formulae)

Your Manager: Vatting Instruction Team Leader

Team: Distillation & Maturation, Inventory

Location: Kilmalid, Dumbarton – we operate a hybrid working approach

Contract Type: Fixed Term Contract – expected to last until

August 2027

Pernod Ricardis a worldwide leader in the spirits andchampagneindustry, blending traditionalcraftsmanship,state-of-the-artbrand development, and global distribution technologies. Our prestigious portfolio of premium to luxury brands includes Absolut vodka, Ricard pastis, Ballantine’s, Chivas Regal, Royal Salute, and The Glenlivet Scotch whiskies, Jameson Irish whiskey, Martell cognac, Havana Club rum, Beefeater gin, Malibuliqueur,and Mumm and Perrier-Jouëtchampagnes. Our mission is to ensure the long-term growth of our brands with full respect for people and the environment, while empowering our employees around the world to be ambassadors of our purposeful,inclusive,and responsible culture of authentic conviviality

Chivas Brothersis the Pernod Ricard business dedicated entirely to Scotch whisky. Our award-winning portfolio features some of the world’s most revered single malt and blended Scotch whisky brands, includingChivas, Ballantine’s, Royal Salute, The Glenlivet andAberlour,which are exported from Scotland to over 100 countries worldwide. As the world’s No.2 Scotch whisky producer with a 1,600-strong team across 26 sites, we are committed to upholding the heritage and pursuing the progress of Scotchand ensuring its sustainable future, as well as opening it up to new audiences across the globe.

About the role

We are currently hiring an Analyst, on a fixed term contract basis, to prepare blend formulae to support cased and bulk sales utilising inventory ranging from 3 to 60 years old. You will play a valued role in ensuring we can meet our short and long-term market demand by analysing our maturing spirit inventory, working collaboratively and using data and analytical skills to identify appropriate stock solutions that meet demand whilst maintaining the integrity and quality of our large portfolio of blends.

What you will do
Vatting and Spirit Availability
  • Produce vatting instructions to meet plans and working within current formula parameters and legislative and quality criteria as well as taking into account transport and warehousing efficiency.
  • Ensure availability of spirit and support Operational Planning in providing the correct spirit for vatting, bottling and exports and update spirit quality information on the system.
Inventory
  • Support future inventory availability through effective stock allocation, balancing current and future requirements while meeting the inventory depletions plan
  • Effectively utilising quality & survey rated inventory in conjunction with the Blending Team.
  • Utilise or relocate inventory at external sites within contract parameters.
Warehouse Support
  • Work with warehouse colleagues to identify opportunities to make effective use of available space using the Power B.I. part stow/tier search tool to identify/allocate/relocate inventory as appropriate.
  • In conjunction with the Operations Teams, ensure warehouse closures or site maintenance does not impact spirit supply.
  • Produce consolidation and repatriation to maintain warehouse space criteria and assist with warehouse audits as required.
Collaboration
  • Collaborate with Blenders & the Bill of Materials Team to facilitate creation of new spirit codes on the system and work with Operational Planners to define the process for New Product Development.
Yourskills andbackground
  • Bring relevant experience from a similar role or transferable experience that could help you succeed in this position.
  • Enjoy working with data and using analytical and problem-solving skills to reach practical solutions.
  • Able to build positive working relationships, collaborate with others, organise priorities to meet agreed timescales and handle information with care and confidentiality.
  • Comfortable using digital tools and data, with experience of some or all of the following: Excel, Power BI, SMP, E1, OBI or similar systems.
Why join us?
Collective Spirit

You will be part of a connected, international community shaped by iconic brands, a performance mindset,and a proud legacy,where collaboration, fun and ambition coexist.

Craft your path

We empower you to own your career, innovate boldly and grow alongside our business, surrounded by leaders who value curiosity, energy,and impact.

Cultivate the future

You’llhelp shape a business with a soul — one that cherishes the land, respects communities,and brings good times from a good place, responsibly and sustainably.

People are at the heart of everything we do at Pernod Ricard and are the foundation of our collective spirit as‘CréateursdeConvivialité’. We promote inclusion throughout our business and supply chain. In our teams, we proactively foster a diverse work force and an inclusive culture,an environment where we can truly be ourselves.

We will assess your application for this role based on your skills, experiences,and achievements, not your gender, age, ethnic or educational background or any other such factors. Our recruiting team are more than happy to provide reasonable adjustments during our application and interview process,in order foryou toparticipatefully in our recruitment experience.

Our mix of benefits
  • Competitive salary, along with performance related bonus
  • Defined Contribution Pension
  • Private medical insurance, including income protection.
  • Comprehensive Employee Assistance Programme
  • Generous annual holiday entitlement (increasing with length of service) plus public holidays.
  • Life Assurance
  • An allowance to spend on our brands.
  • Our reward & recognition scheme
  • Employee discounts from a range of high street retailers
  • Regular events in our very own office bar

Learn more about working with Pernod Ricard https://www.pernod-ricard.com/en

Learn more about Chivas Brothers https://www.chivasbrothers.com/

Job Posting End Date:

Target Hire Date:

2026-12-14

Target End Date:

2027-08-27

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analyst (Blend Formulae)
Analyst (Blend Formulae)

CHIVAS BROTHERS LTD • Dumbarton

Hybrid
GBP 38,000 - 52,000
Competitive salary + bonus
Defined Contribution Pension
Private medical insurance
+2
Master Data Analyst
Master Data Analyst

Scotch Whisky • Dumbarton

Hybrid
GBP 42,000 - 54,000
Finance Business Partner - Sg&A And Tech (Ftc 12 Months)
Finance Business Partner - Sg&A And Tech (Ftc 12 Months)

Scotch Whisky • Glasgow

On-site
GBP 60,000 - 85,000
Private medical insurance
Pension
Employee discounts
+1
Finance Business Partner - SG&A and Tech (FTC 12 months)
Finance Business Partner - SG&A and Tech (FTC 12 months)

Pernod Ricard SA • Glasgow

On-site
GBP 55,000 - 75,000
Private medical insurance
Pension plan
Share incentive plan
+1
Master Data Analyst
Master Data Analyst

CHIVAS BROTHERS LTD • Dumbarton

Hybrid
GBP 32,000 - 52,000
Competitive salary bonus
Defined Contribution Pension
Private medical insurance
+6
Head of Inventory & Blending
Head of Inventory & Blending

Chivas Brothers • Dumbarton

On-site
GBP 120,000 - 180,000
Private medical insurance
Pension scheme
25 days annual holiday
+4
Despatch Planning Administrator
Despatch Planning Administrator

Scotch Whisky • Dumbarton

On-site
GBP 23,000 - 30,000
Competitive salary
Defined Contribution Pension
Private medical insurance
+8
Control Engineer
Control Engineer

Pernod Ricard Winemakers (now Vinarchy) • Elgin

On-site
GBP 40,000 - 55,000
Competitive salary
Defined Contribution Pension
Private medical insurance including收入保
+7
Control Engineer
Control Engineer

Pernod Ricard SA • Elgin

On-site
GBP 42,000 - 64,000
Competitive salary
Defined Contribution Pension
Private medical insurance
+7
Control Engineer
Control Engineer

Pernod Ricard Winemakers - Headquarters (inactive) • Elgin

On-site
GBP 52,000 - 65,000
Competitive salary
Pension plan
Private medical insurance
+7