At a Glance
- Tasks: Analyse data to drive sales and profitability in Electricals & Toys categories.
- Company: Join a dynamic team at a leading retail company focused on innovation.
- Benefits: Flexible working, 30 days holiday, £1,000 benefits allowance, and bonus potential.
- Other info: Inclusive culture with opportunities for personal and professional growth.
- Why this job: Make an impact by turning data into actionable insights for strategic decisions.
- Qualifications: Strong Excel skills; PowerBI and SQL experience preferred; analytical mindset.
The predicted salary is between 35000 - 45000 £ per year.
We are looking for a driven, ambitious Commercial Planning Analyst to join the Commercial team focusing on the Electricals & Toys categories. This role will report into the Senior Commercial Manager and support the delivery of the category budgets and day to day trade by providing data-driven recommendations to maximise sales and profitability.
You will be able to draw relevant insights from complex internal and external data sets, synthesising information into clear, actionable recommendations to support decision making across the wider category teams. You’ll gain a deep understanding of the commercial drivers within the Electrical and Toys categories and be able to identify the impact of decisions on category P&Ls. This role is highly dependent on cross-functional working, influencing and challenging the category teams and wider internal and external stakeholders to drive the most profitable results for the business.
- Draw commercial insights from complex datasets to enable strategic decision-making with the aim of maximising profitability.
- Utilise your deep knowledge of data manipulation to build comprehensive models, reports and dashboards (knowledge of Excel is essential, PowerBI and SQL/Teradata experience is preferred).
- Present data in clear, easy to understand formats for senior leaders.
- Use the data-driven insights to engage and influence category teams, suppliers and cross-functional stakeholders.
- Support the Senior Commercial Manager and Category teams with trading decisions by providing performance insight, scenario planning, promo planning and financial forecasts.
- Track, report and unlock opportunities by creating and sharing insights on price, customer and market data to drive profitability.
- Partner closely with the Trade Planning team to help coordinate a high impact trading calendar by bringing a deep understanding of current commercial performance to maximising sales and margin.
- Support promotional reporting by tracking trends against last year, maintaining compliance, and ensuring our forecasts accurately reflect the latest plans and profit goals.
About you:
- Knowledge of Microsoft Excel is essential, PowerBI and SQL/Teradata experience is preferred with experience handling a variety of data sources.
- Strong analytical and problem-solving skills with strong attention to detail.
- Demonstrates strong commercial acumen with the ability to interpret results and identify key drivers and trends.
- Positive, driven & brings energy to the role.
- Comfortable balancing multiple priorities, both short and long-term.
- Strong PowerPoint skills, with the ability to synthesise data led insights into clear, easy to understand presentations.
Some of our benefits:
- Flexible, hybrid working model
- Inclusive culture and environment
- £1,000 flexible benefits allowance to suit your needs
- 30 days holiday + bank holidays
- Linked In learning access
- Bonus potential (performance and business-related)
- Up to 25% discount on Very.co.uk
- Matched pension up to 6%
Diversity, inclusion and equal opportunities:
We’re building a culture of everyday inclusion, and welcome applications from anyone who believes they can do the job. We don’t discriminate based on age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex, or sexual orientation. We want our recruitment process to be accessible to everyone. If you need reasonable adjustments to apply, interview, or perform a role, let us know via talentacquisition@theverygroup.com. We’ll be happy to support you. We’re proud to be a Disability Confident Committed Employer and have nine brilliant colleague networks - including DAWN (Disability Awareness at Very) and Think (Neurodiversity at Very) - that are helping us make Very an even more inclusive place to work.
Commercial Planning Analyst in Liverpool employer: Very Group
Contact Detail:
Very Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Commercial Planning Analyst in Liverpool
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those who work at companies you're interested in. A friendly chat can lead to insider info and even job referrals.
✨Tip Number 2
Prepare for interviews by practising common questions and scenarios related to commercial planning. Use your analytical skills to showcase how you can draw insights from data and make impactful decisions.
✨Tip Number 3
Don’t underestimate the power of follow-ups! After an interview, send a thank-you email to express your appreciation and reiterate your enthusiasm for the role. It keeps you fresh in their minds.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in joining our team and contributing to our success.
We think you need these skills to ace Commercial Planning Analyst in Liverpool
Some tips for your application 🫡
Show Off Your Data Skills: Make sure to highlight your experience with Excel, PowerBI, and SQL/Teradata in your application. We love seeing how you’ve used these tools to manipulate data and draw insights, so don’t hold back!
Be Clear and Concise: When presenting your experiences, keep it straightforward and easy to understand. We appreciate clarity, especially when it comes to complex data insights. Use bullet points if it helps!
Tailor Your Application: Take a moment to align your skills and experiences with the job description. Show us how your background fits into the Commercial Planning Analyst role and how you can contribute to our team.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Very Group
✨Know Your Data Inside Out
As a Commercial Planning Analyst, you'll be working with complex datasets. Make sure you brush up on your Excel skills and get familiar with PowerBI and SQL/Teradata. Prepare to discuss how you've used data to drive decisions in the past, and be ready to showcase your analytical prowess.
✨Understand the Business
Dive deep into the Electricals and Toys categories before your interview. Research current trends, key players, and market dynamics. This knowledge will not only impress your interviewers but also help you articulate how you can contribute to maximising sales and profitability.
✨Practice Your Presentation Skills
You'll need to present data-driven insights clearly and effectively. Prepare a few examples of how you've synthesised complex information into easy-to-understand formats. Practise presenting these insights to friends or family to build your confidence.
✨Show Your Collaborative Spirit
This role involves cross-functional working, so be prepared to discuss your experience in collaborating with different teams. Think of specific examples where you've influenced stakeholders or worked together to achieve a common goal. Highlight your ability to balance multiple priorities while maintaining strong relationships.