apetito Trowbridge, UK
Overview The Role and Team 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. Who We Are About apetito apetito is the UK’s leading supplier of food to the health and social care sectors. Servicing over 400 hospitals, 450 care homes and thousands more through our work with Local Authorities, we produce delicious, nutritious and sustainable meals for people at home or in care. Through our food we look to ‘ make a real difference’ to all our customers, up and down the country. Our Values Established in 1958, as a family-owned business, our values sit at the very heart of what we do. We are proud to be a business that ‘ makes a real difference’ , committed to producing ‘ great food to be proud of’ . We have developed a range of products designed to ‘ enhance health and well-being’ for all our customers. We are proud supporters of British food and farming and focus on using the best ‘ ethical and sustainably’ sourced produce. We are driven by a ‘ passion for service’ , dedicated to feeding some of the UK’s most vulnerable people, offering healthy and delicious meals to customers across the UK. Ethical & Sustainable As a business which operates within food manufacturing, we believe we have an obligation to make a positive contribution on society. With over 300 products in our range, we ensure our produce is ethically and sustainably sourced, working only with suppliers who share our commitment to making a positive impact. We’re a proud member of the Ethical Trade Initiative (ETI), a leading alliance of companies, trade unions and NGOs, that promote respect for workers rights globally. All our new suppliers now operate under the ETI’s guidelines. We are also a member of The UK’s Plastics Pact, an initiative looking to transform the plastic packaging industry in the UK. As part of the initiative, we have committed, along with other ambitious targets, to eliminate unnecessary single-use plastic completely by 2025. We have also made a commitment to our employees – we’re recognised as an accredited Living Wage employer by the Living Wage Foundation. Joining an elite group of FTSE 100 companies and public sector organisations. Responsibilities As the Data Engineer, you will be an integral part of the team that is working on strategic data analysis and business intelligence projects that enable effective decision making within the organisation. The role offers you an opportunity to work on diverse data sets across geographies (we support UK, Ireland and North America) and across B2C and B2B businesses. You will lead the implementation of emergent technologies and tools and work in a fantastic, closely knit team as the technical guru. This is a fantastic opportunity to build and own the operations of a leading-edge data infrastructure that is fit-for-purpose, resilient, scalable and future-proof. You would be responsible for building and managing the data warehousing in Azure for all geographies and markets above. You would evaluate a wide range of data sources and develop and implement best practice in secure data integration. You will also support the analytics team in data mapping, building robust reporting and support the data requirement for data analytics and advanced predictive modelling. Qualifications You are a skilled Data Engineer with a strong SQL background and experience in building complex ETL pipelines. You would have extensive experience in data integration, ingestion and designing and implementing ETL architecture using a range of ETL tools and techniques. Our tech stack is primarily Microsoft and we are progressively moving to Azure so we are looking for demonstrated expertise on the Microsoft tech stack (Data Factory, SSIS, SSAS, SSRS, PowerBI etc.). You would have handled large amounts of data from multiple sources, internal and external, establishing secure data exchange protocols and would have skills in MDM and data governance. Any experience with SAP, Microsoft NAV, Business Central and/or in warehouse design with Kimball method would be a distinct plus. Have a strong understanding of Information Security principles to ensure compliant handling and management of client data 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. We are looking for a collaborative and enquiring mindset, an aptitude to problem solving and a keen focus on continued optimisation.