Commercial Analyst

Morgan McKinley (Guildford); Woking; Hybrid; GBP 42,000 - 50,000; Full time

Job summary

An international business in Woking is looking for an experienced Business Analyst to lead Sales Reporting and deliver Commercial Insights. The role requires proven data analysis skills, advanced Excel proficiency, and the ability to present data effectively. The company offers a competitive salary of up to £50k and excellent benefits including a hybrid work model, annual bonus, and private healthcare. This position is a fantastic opportunity for career progression within the organization.

Benefits

Annual bonus

25 days holiday plus Bank Holidays and birthday off

Free parking

Pension

Private healthcare

Life assurance

Staff discounts on company products

Qualifications

• Proven data analysis skills with the ability to present data clearly.
• Experience in using data manipulation and visualisation tools.
• Strong communication skills for interpreting data.

Responsibilities

• Lead Sales Reporting and Commercial Insights.
• Prepare monthly sales reports and consolidated sales data.
• Analyze data to drive sales and inform decisions.
• Control Master Price database and Margin calculator.
• Prepare monthly Trade Partner Investment reports.

Skills

Data analysis

Data presentation

Effective communication

Advanced Excel

Power BI

Job description

Overview

We have a fantastic opportunity for an experienced Business Analyst to join a successful, international business in Woking. There are excellent opportunities for career progression within the organisation and we are looking for someone who is ambitious and keen to make a mark. Alongside a competitive salary of up to £50k they offer excellent benefits including; annual bonus, 25 days holiday plus Bank Holidays and your birthday off, hybrid working (3 days per week office based), free parking, pension, private healthcare, life assurance, staff discounts on company products and more.

Responsibilities

• Reporting to the Sales Director, you will be responsible for leading Sales Reporting, delivering Commercial Insights, and managing Pricing tools. You will act as a key conduit between the Sales team and other functions such as Demand Planning, Product Management and Finance on several cross-functional activities.
• Prepare monthly sales reports including sales versus prior year, sales versus budget etc
• Consolidate sales data from multiple retail partners, producing reports on sales by product, retailer etc
• Analyse data to provide actionable insights to help drive sales and to ensure that the business can make informed commercial decisions
• Control and maintain Master Price database and Margin calculator
• Support annual price list renewals process
• Maintain weekly retail price tracker across key retailers and products
• Prepare monthly Trade Partner Investment reports including actual spend versus planned investment, spend versus budget etc
• Monitor Trade Partner promotional activities, producing post-promotion performance reports with recommendations

Requirements

• We are looking for someone with proven data analysis skills alongside the ability to present data clearly, communicate effectively and interpret data to provide actionable insights that will inform important commercial decisions.
• Advanced Excel skills are essential, as is proficiency using data manipulation / data visualisation tools such as Power BI.

Application

For more information please apply now