Commercial Analyst

Head4Talent are working exclusively with a leading international manufacturing group based in north Bristol who are looking to hire a Commercial Analyst We are looking for a motivated and proactive individual who is passionate about delivering high-quality work and making a positive contribution to the business. The successful candidate will be organised, adaptable and able to build strong relationships with colleagues, customers and stakeholders. You will thrive in a dynamic environment, demonstrate a positive and solutions-focused approach, and be comfortable managing multiple priorities The Commercial Analyst will own the commercial analysis for all UK business: pricing, quoting, performance reporting and the cost data behind them. It is a hands-on role for someone early in their career who enjoys numbers, wants real ownership, and wants to understand how a product gets from a factory to a customer's shelf. Duties Pricing and quotations -Prepare customer quotations and price lists for UK accounts, checking every quote against target margins. -Maintain customer pricing in the ERP system and keep it accurate after cost or price changes. -Model and roll out price increases, showing the impact by customer, product range -Flag low-margin or loss-making lines and recommend action to the sales team. -Support sales colleagues with pricing for new business, ranging changes and customer negotiations. Sales reporting and KPIs -Produce weekly and monthly sales reports for UK and Ireland: revenue, volume, gross margin and performance against budget. -Track and explain KPIs by customer, channel, product category and SKU. -Analyse trends, such as customer growth and decline, product mix and lost business, and turn them into clear recommendations. -Build and maintain dashboards and Excel reports that the sales team can use themselves. -Contribute UK and Ireland input to budgets and forecasts. Landed cost and raw material monitoring -Maintain the inputs to the landed cost pricing matrix for UK products: FOB prices, freight, duty, exchange rates and logistics costs. -Update costs when freight rates, currency or supplier prices move, and show the knock-on effect on margin. -Monitor the raw material price indexes behind our ranges. -Produce a regular market tracker showing index movements and what they mean for product costs. -Give procurement the evidence they need for supplier negotiations: the expected cost movement per product based on its material content, where supplier increases can be challenged, and when to push for reductions. -Model how index movements flow through to landed cost and selling prices, so customer price changes are timed well. General -Respond to ad hoc analysis requests from the commercial and senior management teams. -Improve and automate reporting so less time is spent on manual work. Work with purchasing, customer services, finance and logistics to make sure Essential

• 1–2 years in a commercial, pricing, sales or data analyst role
• Strong Excel literacy: confidently builds and maintains large models using XLOOKUP/INDEX-MATCH, SUMIFS, pivot tables and data validation, and works accurately across thousands of rows
• Understands margin, pricing and what drives profit
• High attention to detail and checks own work
• Explains numbers clearly to non-analysts, in writing and in person
• Organised, manages several deadlines and uses initiative to improve processes Desirable
• Degree in a numerical or business subject, or equivalent experience
• Experience in manufacturing, FMCG, packaging or a product-based business
• Working knowledge of Power BI for reports and dashboards
• Uses AI tools such as Claude or Copilot to speed up analysis and reporting
• Power Query or macros
• SQL
• Knowledge of landed cost, import duty, freight, exchange rates or raw material price indexes Has presented analysis to managers or customers