The Role: We are looking for an experienced Senior Data Engineer to join our data team. You will work with the UK’s largest hospitality operator to help transform our data by building unified datasets and using best-in-class engineering processes. You will be working with senior data engineers and data scientists on an exciting loyalty project. You will play a pivotal role in developing datasets to support our data monetisation and loyalty strategy for our revolutionary consumer-facing app (MiXR). The initial scope of the role will be to: You will focus on the project that connects our loyalty app ecosystem with POS data and data from the Digital Media Screen management platform to create powerful datasets for further monetisation and deep analysis of media effectiveness. Work with other members of the data team to ingest GA4 data and build clean datasets that will allow us to transform behavioural app data into insights Work with stakeholders across the business to understand their requirements around data provisioning Work with the documentation and external teams to understand the structure of the data sources and the best way to connect to them Implement data ingestion and data transformation following the DevOps spirit Build automated data quality tests Key Skills and Character Demonstrates a passion for and deep knowledge of advanced data analytics Operationally proficient with the ability to plan, prioritise and deliver clear results A team player with excellent interpersonal skills; able to collaborate across organisational boundaries, embrace change, and work in matrix management arrangements Strong negotiation, influencing and presentation skills Self-reliant, resilient and proactive An evident passion for the hospitality industry is essential Experience working with consumer data and/or digital media data is preferable but not essential Technical skills you must have SQL (4 years of experience) Python (4 years of experience) Experience extracting and transforming data from GA4 Tools you will be using Python for data ingestion and complex data transformation DBT for data transformation and documentation Snowflake – our data warehouse A little bit about us… The Solihull Pub Support Team offices are light and airy offices in Shirley, Solihull, where you will be greeted by our Welcome Team. We have free onsite secure parking with EV charging and cycle storage, a subsidised canteen serving breakfast and lunch, as well as an onsite pub used for social events. The offices are fully accessible. What's in it for you? 25 days annual leave Annual Leave Purchase Scheme Pension Vitality Healthcare Opt in dental insurance programme Annual bonus scheme The Stonegate discount card offering discounts across our managed estate Online benefits portal offering discounts across the High Street and other retailers At Stonegate Group, we're proud to be the biggest operator of pubs, bars, and late-night venues in the United Kingdom. Our leading brands are diverse and well-known, including names like Slug & Lettuce, Be At One and Popworld. Find out more about a career with Stonegate Group at www.stonegatecareers.co.uk. If you have a disability as outlined by the Equality Act 2010 and require reasonable adjustments to be made during the recruitment process, please let us know in advance so that any support, aids or adaptations can be put in place to assist you. You can contact us on pstrecruitmentstonegategroup.co.uk. LI-HR1