So, what will I be doing?
We are looking for a Planning & Forecasting Analyst to join our Customer Demand, Planning & Replenishment Team on a 12 month FTC. The working hours for this role are 40 hours per week (Monday - Friday) and the role is based at our Acorn House office in Highbridge.
The purpose of this role is to provide essential analytical and technical support to the Planning function, ensuring continuity, accuracy, and efficiency across reporting, forecasting, and system processes.
This role will play a key part in maintaining and enhancing existing Power BI and Excel‑based tools, supporting the transition to new planning systems, and enabling data‑driven decision making throughout the supply chain.
You will ensure high‑quality reporting, robust data models, and well-governed analytical processes, while supporting wider system improvements—including the migration of reporting assets and semantic models into modern data architecture frameworks.
This role is critical in sustaining operational performance, strengthening analytical capability, and enabling both the Senior Planning Analyst and wider team to deliver strategic projects and transformation activities.
Your responsibilities will include:
Analytics -
1. Develop and implement data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
2. Identify, analyse, and interpret trends or patterns in complex data sets to provide key business insights
3. Keep management informed of project status through periodic status reporting and project updates
Power BI & Reporting -
4. Develop, maintain, and migrate Power BI reports and semantic data models
5. Audit, streamline, and retire redundant or legacy Power BI reporting
6. Produce clear documentation and user guides for Planning Power BI reports
7. Ensure data integrity and consistent report performance across the department
Systems Support -
8. Support and maintain Planning & Replenishment Excel-based tools, including VBA-driven models (VBA expertise essential)
9. Troubleshoot system and reporting issues, ensuring minimal downtime and quick resolution
10. Assist with system testing, data validation, and workflow alignment during the new planning system implementation
Sounds interesting, what do I need?
Essential:
11. Demonstrable skills in statistical analysis.
12. Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention to detail and accuracy
13. Power Bi Report design and data manipulation
14. Familiarity with SQL for data extraction and troubleshooting
15. Practical knowledge of DAX for Power BI model development
16. Understanding of data modelling principles and semantic layer design.
17. Excellent IT Skills (Microsoft Excel including Excel VBA)
18. An ability to influence people at all levels
19. Positive attitude & Good Interpersonal skills
20. Proactive and self-motivated
21. Being able to work to strict deadlines
Desirable:
22. OneLake & Lakehouse Architecture Understanding
23. Data Engineering Awareness
24. Experience working with ERP and/or planning systems
25. Experience of Dashboard reporting
26. Evidence of self-development
27. Drivers Licence
Why should I join the family?
We’re independent, British and proud to be making the highest quality yogurts, desserts and ice cream under the Yeo Valley brand and for many of the UK’s major retailers. Operating from four dairies and two logistics centres in Somerset and Devon, we employ over 1900 staff and produce more than 25% of the UK’s packaged yogurt.
We’re sure you don’t need convincing, but there’s a whole host of benefits that we offer. It goes without saying that you'll have access to free parking, top of the range personal protection equipment (PPE) and your own locker. You'll also receive the following:
28. Competitive holiday allowance
29. non-contributory pension scheme
30. life cover
31. healthcare cash back plan
32. cycle to work scheme
33. subsidised Yeo Valley products and services
34. preferential rates with our partners
35. learning and development opportunities; we’re committed to ensuring all of our employees have the chance to grow