Strategic Commercial Analyst — Pricing & Data Insights

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

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.