Senior Data Engineer

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

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

To be considered for this role you must have at least 5 years experience in handling a SQL production environment as a DBA/ Data Engineer, including:

• Strong SQL & T-SQL skills, applied to dynamic loading of a data warehouse, gained in a work context
• Extensive experience in data integration, data modelling and ingestion
• Expertise and experience with Azure, SSIS and DataBricks
• Collaborative and enquiring mindset
• 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.

This role has a clear requirement to be in the office for 3 days per week you will need to live within a reasonable commutable distance from our Trowbridge Head Office to be considered for this role.

Company Benefits

• Competitive salary - accredited Living Wage employer
• 25 days holiday per year, plus bank holidays
• Option to purchase up to 5 additional days holiday per year
• Discretionary annual bonus scheme
• Pension scheme - employer matched contributions up to 4%
• Life assurance scheme worth at least 1x annual salary
• Subsidised canteen
• Free parking
• Free turkey or voucher at Christmas
• apetito perks scheme including salary sacrifice options and retail discounts

Our Values

As a family-owned business, we take great pride in being a company that makes a real difference and is dedicated to creating outstanding meals to be proud of.

We develop a range of products designed to enhance health and well-being for all our customers.

We are driven by a passion for service and dedicated to feeding some of the UK's most vulnerable people.

We proudly support British food and farming, focusing on using the best ethical and sustainable produce in alignment with our goal to reach Net Zero by 2040.

Our ethical standards are recognised by the ETI and we are an accredited Living Wage employer.
Learn more about apetito's commitment to a more sustainable future.

We embrace inclusion, empowering individuals from diverse backgrounds.

Our commitment to making a real difference extends to customers, communities, and staff and we're on a mission to build an inclusive workplace where everyone reaches their full potential.