At a Glance
- Tasks: Support Demand Planning & Supply Chain with data analysis and reporting.
- Company: Leading manufacturing business with a focus on innovation.
- Benefits: Hybrid working, competitive salary, and opportunities for European travel.
- Why this job: Transform complex data into actionable insights and drive impactful decisions.
- Qualifications: Experience in data analysis, strong Excel skills, and ability to communicate insights.
- Other info: Fast-paced environment with excellent career growth and international exposure.
The predicted salary is between 36000 - 60000 £ per year.
Location: Cheshire (Hybrid Working). We are recruiting a highly analytical Data Analyst supporting the Demand Planning & Supply Chain function, to join a leading manufacturing business. This role is ideal for a data focused analyst who may not have owned demand planning previously but has worked closely alongside Demand Planning and Supply Chain teams, providing large-scale data, insight, and analysis to support forecasting and planning decisions.
The role plays a critical part in transforming complex customer and SKU-level data into accurate, decision-ready insight that feeds Demand Planning, S&OP, and Supply Chain execution. Although the role is UK-based full time, there is European travel requirements (typically once per month), alongside monthly customer visits across the UK. We are looking for someone who is driven, adaptable, and flexible, and comfortable working in an international environment.
Key Responsibilities- Act as the primary analytical support to Demand Planning and Supply Chain teams, owning the extraction, validation, and transformation of large customer and SKU-level data sets to support accurate forecasting and planning decisions.
- Analyse and consolidate 13-week customer forecasts, critically reviewing forecast submissions for accuracy, bias, and anomalies.
- Compare historical sales data against new forecasts, identifying trends, seasonality, volatility, and variance to support robust demand planning.
- Produce detailed, decision-ready reports and dashboards using advanced data analytics tools (e.g. SQL, Python, Power BI) to support forecasting accuracy and performance tracking.
- Support the monthly S&OP process by providing analytical insight, scenario modelling, risks, and opportunities to senior stakeholders.
- Work closely with Demand Planning, Sales, Production, and Supply Chain teams, attending customer reviews and internal planning meetings to ensure alignment.
- Provide customers and internal teams with clear forecasting data, performance reports, and demand updates, ensuring complex data is communicated clearly and effectively.
- Monitor FGI (Finished Goods Inventory) data, highlighting risks relating to shortages, excess stock, or demand volatility.
- Support production lifecycle management, including product introductions, phase-outs, and stock build strategies through data-driven insight.
- Identify performance trends, inefficiencies, and value opportunities within demand and supply data to support continuous improvement initiatives.
- Operate effectively in a fast-paced manufacturing environment, managing multiple data streams and changing priorities.
- Support European teams and cross-regional projects, particularly those involving the introduction or enhancement of new data analytics and planning software.
- Proven experience in a Data Analyst, Supply Chain Analyst, or Commercial Analyst role within manufacturing, FMCG, or a complex operational environment.
- Strong experience working with large, complex data sets, particularly SKU-level, customer-level, and time-phased data.
- Demonstrated ability to validate, challenge, and interpret data to support forecasting and planning decisions.
- Advanced Excel skills (pivot tables, lookups, data modelling, reporting).
- Strong communication skills with the ability to translate complex data into clear, actionable insight for non-technical stakeholders.
- High attention to detail with strong ownership of data accuracy and integrity.
- Comfortable working in a highly fast-paced, change-driven environment.
- Experience working alongside Demand Planning or S&OP teams, providing analytical support rather than owning the plan.
- Hands-on experience with SQL, Python, Power BI, Tableau, or similar analytics tools.
- Exposure to ERP / planning systems such as SAP, SAP IBP, APO, or similar.
- Experience supporting system implementations, upgrades, or analytics-led transformation projects.
- Understanding of demand planning, forecasting, and supply chain processes, even if not previously owned.
- Experience working within European or international supply chain environments.
Data Analyst - Demand Planning & Supply Chain in Ellesmere Port employer: Frank Wills Recruitment
Contact Detail:
Frank Wills Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Demand Planning & Supply Chain in Ellesmere Port
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those working in demand planning and supply chain. A friendly chat can lead to insider info about job openings or even a referral.
✨Tip Number 2
Show off your skills! Prepare a portfolio of your data analysis projects, especially those using SQL, Python, or Power BI. This will give potential employers a taste of what you can do and how you can add value.
✨Tip Number 3
Ace the interview by being ready to discuss real-world scenarios. Think about how you've tackled data challenges in the past and be prepared to explain your thought process and the impact of your work.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and engaged with our company.
We think you need these skills to ace Data Analyst - Demand Planning & Supply Chain in Ellesmere Port
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Data Analyst in Demand Planning & Supply Chain. Highlight your experience with large data sets and any relevant tools like SQL or Python. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and how your background fits into our manufacturing environment. Don’t forget to mention your adaptability and flexibility, as these are key traits we value.
Showcase Your Analytical Skills: In your application, provide examples of how you've used data to support decision-making in previous roles. Whether it's through reports, dashboards, or insights, we want to see your analytical prowess in action!
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 shows you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at Frank Wills Recruitment
✨Know Your Data Tools
Make sure you brush up on your skills with SQL, Python, and Power BI. Be ready to discuss how you've used these tools in past roles, especially in relation to demand planning and supply chain analytics.
✨Understand the Supply Chain
Familiarise yourself with the basics of demand planning and supply chain processes. Even if you haven't owned a demand plan before, showing that you understand how these elements work together will impress your interviewers.
✨Prepare for Scenario Questions
Expect questions that ask you to analyse data or solve problems on the spot. Practise interpreting data sets and presenting your findings clearly, as this is crucial for the role.
✨Communicate Clearly
Since you'll be translating complex data for non-technical stakeholders, practice explaining your past projects in simple terms. Highlight your ability to convey insights effectively, as strong communication skills are key for this position.