Senior Data Engineer
Senior Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 apetitos 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 analyticsacross all markets.
You will manage a Data Engineer (apprentice) and support their development.
This is a fantastic opportunity to manage a leadingedge 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 UKs leading food supplier to the health and social care sectors serving more than 1300 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 UKs 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 roadmapto 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
About you
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 & TSQL 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.
- Handson 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 familyowned 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 wellbeing for all our customers.
We are driven by a passion for service and dedicated to feeding some of the UKs 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 apetitos 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 were on a mission to build an inclusive workplace where everyone reaches their full potential.
Required Experience:
Senior IC
Employment Type
Full-Time
