At a Glance
- Tasks: Lead sales reporting, deliver commercial insights, and manage pricing tools.
- Company: Join a successful international business in Woking with great career progression.
- Benefits: Competitive salary up to £50k, annual bonus, 25 days holiday, hybrid working, and more.
- Why this job: Make a mark in a dynamic role that drives commercial decisions and impacts the business.
- Qualifications: Proven data analysis skills, advanced Excel, and proficiency in data visualisation tools like Power BI.
- Other info: Enjoy free parking, private healthcare, and staff discounts on company products.
The predicted salary is between 36000 - 60000 £ per year.
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.
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.
Responsibilities include:
- 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.
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.
For more information please apply now!
Commercial Analyst employer: Morgan McKinley (Guildford)
Contact Detail:
Morgan McKinley (Guildford) Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Commercial Analyst
✨Tip Number 1
Network like a pro! Reach out to current employees on LinkedIn or attend industry events. We can’t stress enough how personal connections can give you the inside scoop on job openings and company culture.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your data analysis skills. We recommend using real-life examples from your past experiences to demonstrate how you’ve driven sales or provided actionable insights.
✨Tip Number 3
Don’t forget to follow up after your interview! A quick thank-you email can keep you fresh in their minds. We suggest mentioning something specific from your conversation to show your genuine interest.
✨Tip Number 4
Apply through our website for the best chance at landing that Commercial Analyst role. We make it easy for you to showcase your skills and experience directly to the hiring team!
We think you need these skills to ace Commercial Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Commercial Analyst role. Highlight your data analysis skills and any relevant experience that aligns with the responsibilities mentioned in the job description. We want to see how you can make a mark in our team!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Share specific examples of how you've used data to drive sales or improve processes in the past. We love a good story!
Show Off Your Excel Skills: Since advanced Excel skills are essential, don’t forget to mention any specific projects where you’ve used Excel to analyse data or create reports. If you’ve worked with tools like Power BI, give us the details – we’re keen to know how you visualise data!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and get you into our system quickly. Plus, it shows you’re serious about joining our fantastic team!
How to prepare for a job interview at Morgan McKinley (Guildford)
✨Know Your Numbers
As a Commercial Analyst, you'll be dealing with a lot of data. Brush up on your Excel skills and be ready to discuss how you've used data analysis in previous roles. Prepare examples of reports you've created or insights you've provided that led to significant business decisions.
✨Understand the Business
Research the company and its market position. Familiarise yourself with their products and competitors. This will not only help you answer questions more effectively but also show your genuine interest in the role and the organisation.
✨Prepare for Scenario Questions
Expect questions that ask how you would handle specific situations, especially related to sales reporting and data analysis. Think of scenarios where you've had to analyse data to drive sales or make recommendations, and be ready to explain your thought process.
✨Communicate Clearly
Since the role involves acting as a conduit between teams, practice explaining complex data insights in simple terms. During the interview, focus on clear communication and ensure you can articulate your thoughts logically and concisely.