Commercial Analyst

A market-leading FMCG business is seeking a Commercial Analyst to join its growing team.

This is an excellent opportunity for a data-driven analyst with strong Excel skills and experience using tools such as Power BI, VBA, Macros or other reporting platforms to turn complex data into meaningful commercial insight.

Working closely with Sales, Marketing, Procurement and Senior Leadership teams, the Commercial Analyst will analyse pricing, product performance, customer profitability, supplier and competitor activity and market trends to support strategic decision-making and drive business performance. The role combines hands-on data analysis, modelling and reporting with the opportunity to present recommendations to key stakeholders across the business.

Then I'd slightly condense the rest:

Key Responsibilities

Analyse and report on pricing, product performance, customer profitability, competitor activity, supplier data and market trends

Maintain pricing tools and implement pricing updates and changes

Develop and maintain commercial models to support reporting, forecasting and profitability analysis

Evaluate the effectiveness of pricing and commercial initiatives, identifying opportunities and recommending improvements

Work closely with Procurement and other stakeholders to maintain the integrity of commercial data and reporting

Support pricing quotations, tenders and commercial proposals

Produce regular and ad-hoc reports, presenting clear insights and recommendations to stakeholders across the businessCandidate Requirements

Experience analysing, manipulating and interpreting large datasets within a commercial, pricing, sales, finance or business analysis environment

Strong Excel skills, including Pivot Tables, Lookups and logical formulae

Experience using reporting and visualisation tools such as Power BI would be advantageous

Strong analytical and problem-solving capabilities, with excellent attention to detail

Ability to communicate complex data clearly through reports, presentations and stakeholder engagement

Knowledge of VBA, Macros and/or Power Automate would be beneficial but is not essential

Degree in a numerical or business-related discipline would be advantageous