Senior Data Engineer

at  apetito

Overview:
apetito has been on an exciting journey to embed data at the heart of strategy and the data analytics team is leading the journey.
We are exploring apetito’s rich data assets with the exciting new technologies and tools that are now available and identifying new opportunities to deliver superior customer satisfaction and to grow the business.
Our data infrastructure is in the Cloud (Azure) mainly and one environment is scheduled to be migrated to Azure, a project that you will lead.
You be a part of the Data and Analytics team, a fantastic, closely knit team that is working on strategic data analysis and business intelligence projects across our businesses in UK, Ireland, and North American across B2C and B2B businesses.
As a key member of the Data and Analytics Leadership team, you would be driving the strategy for data analytics across all markets.
You will manage a Data Engineer (apprentice) and support their development.
This is a fantastic opportunity to manage a leading-edge data infrastructure and ensure that it continues to be resilient, scalable and future proof.
The role offers you an opportunity to evaluate, deploy and work with new technologies and tools.
Who we are:
apetito is the UK’s leading food supplier to the health and social care sectors serving more than 1,300 care homes, health care and education settings.
Our meals are expertly crafted by our dieticians and chefs, and then frozen to lock in the goodness.
Wiltshire Farm Foods, our sister company, is the UK’s largest ready meal supplier cooking and delivering over 330 different delicious frozen ready meals across the UK.

Responsibilities:

• Lead the management of the Data infrastructure for our B2C businesses -Wiltshire Farm Foods, UK and Ireland, Heart to Home Meals, Canada and Heart to Home Meals, USA, ensuring that the ETLs run consistently, and data is always available at high integrity and governance
• Develop and deliver a development road-map to enhance and improve the performance of the data infrastructure. Provide development support to the analytics and the Business Intelligence teams
• Maintain the Dev, Test and Production environments with synchronicity across environments. Manage the development cycle with a strong DevOps process
• Evaluate the data quality and develop a robust plan for tracking and improving data quality in these environments
• Work with the CISO and the IT colleagues to ensure security compliance on the infrastructure
• Manage migration of the Wiltshire Farm Foods, UK and Ireland infrastructure to the Cloud from the data perspective.
• Deploy the One DTC framework across all the environments
• Support the data privacy policy in close collaboration with the DPO, IT and the business owners
• Support delivery of a comprehensive business intelligence suite across the B2C businesses
• Support the Business Intelligence, Marketing Analytics, Forensic Analytics and AI/Predictive analytics teams with advice and documentation
• Develop a robust set of performance reporting for each of the environments
• Address any failures in the production environments within the internal SLA. Log and analyse the causes of failures and develop robust countermeasures to eliminate causes of failure
• Build a deep understanding of our products, processes, systems, and data, and build strong relationships with the stakeholders across the business.
• Be the technical guru for the Data and Analytics colleagues

Qualifications/Personal Qualities:

Essential skills and experience:

• A skilled data engineer with a strong SQL background and extensive experience in data integration, data modelling and ingestion.
• Demonstrated expertise and experience with Azure, SSIS and DataBricks is essential.
• Collaborative and enquiring mindset, an aptitude to problem solving and a keen focus on continued optimisation.
• Strong analytical skills you can apply to a commercial setting and business processes.

Desirable:

• Handling large amounts of data from multiple sources, internal and external, through APIs and SFTP with secure data exchange protocols and have experience in data structuring/warehouse design.
• Hands-on experience with a visualisation tool (ideally Tableau), in setting up and managing the technical infrastructure and access management.
• Strong understanding of Information security principles and technologies and demonstrated experience in working with the IT infrastructure colleagues and the CISO in building and managing a secure, efficient data infrastructure.
• Experience with SAP, Microsoft NAV, Microsoft Business Central, Erwin would a plus.
• Good stakeholder skills are vital with demonstrated experience of working with business analysts and data analysts on one side and with IT colleagues and external suppliers on the other.

• Lead the management of the Data infrastructure for our B2C businesses -Wiltshire Farm Foods, UK and Ireland, Heart to Home Meals, Canada and Heart to Home Meals, USA, ensuring that the ETLs run consistently, and data is always available at high integrity and governance
• Develop and deliver a development road-map to enhance and improve the performance of the data infrastructure. Provide development support to the analytics and the Business Intelligence teams
• Maintain the Dev, Test and Production environments with synchronicity across environments. Manage the development cycle with a strong DevOps process
• Evaluate the data quality and develop a robust plan for tracking and improving data quality in these environments
• Work with the CISO and the IT colleagues to ensure security compliance on the infrastructure
• Manage migration of the Wiltshire Farm Foods, UK and Ireland infrastructure to the Cloud from the data perspective.
• Deploy the One DTC framework across all the environments
• Support the data privacy policy in close collaboration with the DPO, IT and the business owners
• Support delivery of a comprehensive business intelligence suite across the B2C businesses
• Support the Business Intelligence, Marketing Analytics, Forensic Analytics and AI/Predictive analytics teams with advice and documentation
• Develop a robust set of performance reporting for each of the environments
• Address any failures in the production environments within the internal SLA. Log and analyse the causes of failures and develop robust countermeasures to eliminate causes of failure
• Build a deep understanding of our products, processes, systems, and data, and build strong relationships with the stakeholders across the business.
• Be the technical guru for the Data and Analytics colleague