Commercial Analyst - Supply Chain

Wsh Support Office; United Kingdom; On-site; GBP 42,000 - 56,000; Full time

Benefits offered by this job

25 days holiday (plus public holidays)

Birthday off

Enhanced pension

Life Assurance cover

Staff discounts on high street, travel

Wellbeing assistance

Volunteering Days

Enhanced maternity leave

Secondary Carer leave

Wedding/Commitment day leave

Bespoke training & apprenticeships

Competitive salary

Job summary

Wsh Support Office is seeking a Commercial Analyst to support strategic pricing, procurement and cost optimization across Supply Chain. You’ll build dashboards in Power BI, clean and transform data in Excel, and provide actionable insights to drive commercial decisions.

You will work with multiple data sources, monitor market trends and supplier pricing to identify opportunities. A strong eye for detail and a data-driven mindset are essential for success in this role.

Qualifications

• Confident in use of MS Office suite – focus on Excel.
• Proficient in Power BI; creating interactive dashboards for reporting and insights.
• Love of data and commitment to accuracy.
• Comfortable manipulating large data sets, including visualisation to drive insight.
• Highly organized but adaptable.
• Data driven – accurate and timely.
• Customer focused.
• Proactive with an enquiring mind.
• Desirable Experience of Hospitality/ FMCG.

Responsibilities

• Engage with the wider Supply Chain teams and suppliers to support the Commercial Insight Manager in pricing analysis and insight-driven initiatives
• Design, build and enhance dashboards and reports to provide clear, actionable insights aligned with business objectives
• Utilise Excel, Power BI and other systems to cleanse, transform and analyse data from multiple sources, ensuring accuracy, consistency and high-quality reporting
• Support external benchmarking activities using internal and external data sources to provide market comparisons and practical insights
• Analyse market intelligence, commodity trends, supplier pricing movements and inflation indicators to identify risks, opportunities and emerging trends that support commercial decision-making
• Assist in tracking and reporting key inflation indices, including Consumer Price Index (CPI) and Food Price Index (FPI), and support supplier basket rebalancing initiatives
• Deliver regular cost price reporting, forecasting and analysis, identifying key drivers of change, commercial opportunities and areas of value leakage
• Support Procurement and Operational teams by translating complex data into clear recommendations that improve commercial performance, margin and decision-making

Skills

Data analysis

Attention to detail

Stakeholder communication

Decision support

Tools

Excel

Power BI

Job description

Job Description

The Commercial Analyst plays a key role in supporting strategic pricing, procurement and cost optimisation initiatives across the Supply Chain function. Through the collection, analysis and interpretation of data, the role delivers actionable insights that support commercial decision-making, supplier performance reviews, benchmarking activities and savings opportunities. The role is responsible for developing reports, dashboards and analytical solutions using Excel, Power BI and other business systems, while monitoring market trends, commodity movements and supplier pricing to drive value across the wider business.

Key accountabilities include:

• Engage with the wider Supply Chain teams and suppliers to support the Commercial Insight Manager in pricing analysis and insight-driven initiatives
• Design, build and enhance dashboards and reports to provide clear, actionable insights aligned with business objectives
• Utilise Excel, Power BI and other systems to cleanse, transform and analyse data from multiple sources, ensuring accuracy, consistency and high-quality reporting
• Support external benchmarking activities using internal and external data sources to provide market comparisons and practical insights
• Analyse market intelligence, commodity trends, supplier pricing movements and inflation indicators to identify risks, opportunities and emerging trends that support commercial decision-making
• Assist in tracking and reporting key inflation indices, including Consumer Price Index (CPI) and Food Price Index (FPI), and support supplier basket rebalancing initiatives
• Deliver regular cost price reporting, forecasting and analysis, identifying key drivers of change, commercial opportunities and areas of value leakage
• Support Procurement and Operational teams by translating complex data into clear recommendations that improve commercial performance, margin and decision-making

Qualifications

What we want from you:

• Confident in use of MS Office suite of applications – with a focus on Excel
• Proficient in Power BI; creating interactive dashboards for reporting and insights
• Love of data and commitment to accuracy
• Comfortable manipulating large data sets, including visualisation to drive insight and understanding
• Highly organized but adaptable
• Data driven – accurate and timely
• Customer focused
• Proactive with an enquiring mind
• Desirable Experience of Hospitality/ FMCG

Additional Information

And in return, we offer:

• 25 days holiday (plus public holidays)
• Plus your birthday off
• Enhanced pension
• Life Assurance cover
• Discounts available on the high street shops, holidays, gyms and cinemas
• Wellbeing assistance
• Volunteering Days
• Enhanced maternity leave
• Secondary Carer leave
• Wedding/Commitment day leave
• Bespoke training and development, including apprenticeships
• Competitive salary