Senior Data Engineer
Role details
Job location
Tech stack
Job description
- 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
Requirements
Do you have experience in Warehouse experience?, 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.
Benefits & conditions
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 annual leave 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. If you require alternative methods of application or screening, you must approach the employer directly to request this as Indeed is not responsible for the employer's application process.
