So, what will I be doing?
We have an opening for a Data Engineer to join our Data and BI Team as part of the wider IT Team who cover Applications, Infrastructure, Service Desk, Cybersecurity and Data & BI across Yeo Valley.
We are looking for an experienced, pipeline-centric data engineer to join our team. The ideal candidate will have a rare curiosity and creativity. Beyond technical prowess, the data engineer will need soft skills for clearly communicating highly complex data trends to a variety of stakeholders.
Yeo Valley is at a time of exciting business growth. We are also making strides in the industry, taking on a huge sustainability journey, as we look to promote key environmental initiatives including soil health through organic farming. We are passionate about feeding the nation with real, healthy organic food that doesn’t impact our planet.
This role is a great opportunity for anyone looking to work in a company that is passionate about the planet and expanding their experience in line with new technologies and digital approaches. You will be based as part of our IT team in our Acorn House location in Highbridge, our newly refurbished spacious offices (decorated with a local twist!), only half an hour from Bristol and just off of the M5 Junction 22.
The role will have opportunities for a mixture of on-site and working from home options, plus there is a great staff canteen!
Your responsibilities:
1. Build data pipelines that clean, transform, and aggregate data from disparate sources.
2. Create and improve dimension and fact tables to allow better reporting and deep dives.
3. Test, deploy, maintain, and review regular updates for the data warehousing systems.
4. Work closely with our analysts and BI developer to help build complex algorithms that provide unique insights into our data.
5. Create and update documentation of processes using ClickLearn.
6. Good understanding & adherence of best practice BI and reporting governance.
7. Work with our implementation partners and support a range of activities centred around the building of data pipelines and associated configuration.
8. Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability, etc.
9. Ensure the smooth and efficient handover of the platform support from our implementation partners to in-house support.
10. Undertake 2nd line support duties for IT Data Warehouse related incidents & resolve issues within IT Service Level Agreements.
Sounds interesting, what do I need?
Essential:
11. A very good understanding of Data Warehouse architecture, and the concepts of ETL/ELT.
12. Experience with Cloud technology, ideally Azure.
13. Strong knowledge of one or more programming languages, such as SQL.
14. 3+ years’ experience of managing data pipeline development.
15. Strong communication skills to be able to explain technical concepts to nontechnical stakeholders.
16. Good understanding of data governance frameworks.
Desirable:
17. University degree (or equivalent) in Computer Science, Mathematics, Statistics, or related field.
18. Python coding experience for configuration in cloud.
19. Understanding of the full MS BI stack (SSIS, SSAS).
20. Proficient in Matillion and Snowflake.
21. Someone who wants to learn, and further their own knowledge as well as support the team by sharing knowledge and experience.
Knowledge of IFS ERP systems.
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 1700 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 including:
22. 25 days holiday allowance
23. non-contributory pension scheme
24. life cover
25. healthcare cash back plan
26. cycle to work scheme
27. subsidised Yeo Valley products and services
28. preferential rates with our partners
29. annual bonus (as part of the Employee Benefit Trust, based on company performance for the year)
30. learning and development opportunities; we’re committed to ensuring all of our employees have the chance to grow