Senior Data Engineer

The Company

SSP is a leading operator of food and beverage outlets in travel locations worldwide, with c.42,000 colleagues in over 600 locations across 37 countries.

We operate sit-down and quick service restaurants, cafes, lounges and food-led convenience stores, principally in airports and train stations, with a portfolio of around 550 international, national and local brands. These include our own brands Upper Crust, Millies Cookies etc. as well as franchise brands such as M&S, Starbucks and Burger King.

Our purpose is to be the best part of the journey, and this is underpinned by our aim to bring leading brands and innovative concepts to our clients and customers around the world, with an emphasis on great value, taste, quality and service.

The Role

SSP are world leaders, but in many ways the Data and Analytics function feels like a start-up, with a twist. There’s the buzz of innovative projects, the thrill of shaping compelling customers experiences, the chance to surprise and stretch yourself in response to a fresh challenge. And then there’s all the resources, technology and high profile projects of a major corporate entity. Crucially, we also offer the benefit of clear career progression. SSP are undergoing a technology transformation with board support for IT investment. We have a portfolio of strategic priorities and a clear vision. We require a Senior Data Engineer to join Group Digital and Technology as part of the Analytics team to become a member of a new engineering practice delivering strategic analytics and insight solutions for the SSP business. You will be designing, implementing and improving data pipelines as we migrate our SQL 2016 environment into the Azure Cloud. Building out Net New API solutions and digital pipelines. You will work in conjunction with our Data Analyst and QA as you engineer 21st century digital solutions. Beyond just the Power BI Univariate and into the multivariate modelling world. We are modernising our core systems of record and enabling digital and technology innovation. A key aspect to this journey is the data driven enterprise, with data management, analytics and insight and intelligent solutions as fundamental building blocks. This role will need to develop high quality data, BI and ML/AI solutions primarily with Microsoft Azure data and BI services and Microsoft Power BI.

Main Duties

• Designing and delivering data pipelines
• Designing and building Azure Data Factory data flows
• Ingesting data into an Azure Data Lake
• Designing data models for large datasets, including creating dimensional multivariate models as outputs for ingested data
• Exposure to non-relational data storage such as mongo DB type design
• Experience in SQL Server Integration Services (SSIS)
• Good experience with ETL
• SSIS, SSRS, T-SQL (On-prem/Cloud)
• Experience with NoSQL type environments, Data Lakes, Lake-Houses (Cassandra, MongoDB or Neptune)
• Have experience with Python
• Knowledge of statistics principles necessary to interpret data and apply models. For example, knowledge of errors and confidence intervals to understand whether a relation seen in the data is real
• Exposure to high performing, low latency or large volume data systems (i.e. 4 billion+ records, terabyte size database)
• Work within a continuous integration environment with automated builds, deployment and unit testing

Essential

• SQL, Python, R or other similar language
• An interest in machine learning engineering or a desire to skill up
• Retail, Food & Beverage or Hospitality industry experience
• Experience using data within an analytics environment from core enterprise solutions including Oracle Simphony, SAP S4, SAP SuccessFactors

Desirable

• Multi International Geo experience
• An interest in data science, ML and AI
• Be passionate about food and drink

Diversity and Inclusion is a priority at SSP. We are an equal opportunities employer committed to engaging all of our people, so they feel valued and motivated; we champion diversity, promote inclusion, and ensure equality. We respect and protect human rights and prevent discrimination; and we positively impact our communities. We encourage and welcome applications from a diverse range of candidates regardless of background, gender, race, religious beliefs, disability, sexual identity and orientation or age.