We have an exciting opportunity for an Azure Data and Integration Engineer to join our award-winning Business Change and Technology team on a permanent basis. Reporting into the Data & Integration Manager you will Design, Build and optimise data and integration solutions to meet the needs of our internal customers using Microsoft Azure Cloud services, Data Bricks, Google Apigee, and our Customer Data Platform where appropriate. You’ll Design, build and optimise pipelines that store code and deploy solutions using Azure DevOps. You will work with our Architecture community to produce roadmaps, strategies and guardrails that align to the business domains in-line with Enterprise Architecture plans and Technology strategy.

 This role will involve a mixture of office and home working, with our Head Office based in Birmingham City Centre.

About us…

Serving with pride since 1898, Mitchells & Butlers are the heart of UK hospitality. In fact, you already know us, even if you don’t realise it! We own and run more than 1,600 pubs, bars and restaurants including the stylish All Bar One brand, legendary Miller & Carter steakhouses, and the iconic Toby Carvery. We are Mitchells & Butlers, and we set the industry standard.

You’ll be well rewarded…

• Annual bonus scheme with the potential to earn up to 30% of your salary annually. We’re all about rewarding hard work
• Permanent contract
• Working 35 hours per week, Monday to Friday, with flexibility with working hours to fit around your personal commitments (e.g., 7am to 2pm, 8am to 3pm, etc.)
• 33% off at all our brands, including our hotels. Whether it’s date night at Miller & Carter or a family roast at Toby Carvery, we’ve got you covered
• A pension that pays, where we’ll more than match your contributions (x1.5 of your contributions, up to a maximum of 5% of your salary)
• Private healthcare, dental plan, cycle to work, and keep fit schemes
• 26 days annual leave plus bank holidays, plus option to buy up to 2 weeks extra holiday
• Opportunity to opt in to Sharesave Plan, enabling you to save to buy shares or have money returned

What makes Mitchells & Butlers a great place to work?

To us, a career isn’t just about ‘clocking in’. We really care about our colleagues, and we’re an employer that keeps a promise. In fact, as one of the largest employers in the country, with over 44,000 people working for us, we have the responsibility of valuing every contribution from a diverse workforce that are representative of our guests, and who make us stronger. We continue to build a culture that values our differences and embraces them as strengths, and we recognise that there is always work to be done.

What you’ll be doing as our Azure Data and Integration Engineer…

• Collaborating with the business and technical stakeholders to maximise the value of data and information within Mitchells and Butlers
• Using Mitchells & Butler’s architecture method to lead the identification of potential solutions able to fulfil business requirements and make recommendations to the business based on architecture principles & guidelines.
• Presenting findings & recommendations to IT Architectural Forum, identifying where the proposed solution does not adhere to architecture principles and why.
• Building market & sector knowledge to ensure awareness of potential solutions / solution providers.  Share knowledge with other IT teams to enable engagement with the business.
• Working with 3rd party solution providers to support the production of roadmaps for all architecture components within the responsibility of data and integration.
• Maintaining documentation on the current architecture related to Data and integration ensuring changes are reflected in a timely manner.

• Enabling our mission to ingest, store, cleanse, model and transform data for Insights, Machine Learning models, dashboards and reports.
• Bringing to life our strategy to centralise multiple different domains of data and support production of curated data models, reports and dashboards that draw together data from Sales, Labour, Energy, Stock and more.
• Assuring that data is cleansed, mapped, transformed, and otherwise optimised for storage and use according to business and technical requirements.
• Solution design using Microsoft Azure services and other tools.
• The ability to automate tasks and deploy production standard code (with unit testing, continuous integration, versioning etc.)
• Loading transformed data into storage and reporting structures in destinations including data warehouse, high speed indexes, real-time reporting systems and analytics applications.
• Building and managing data pipelines.
• Strong data modelling & data analytics skills.
• Enabling a Lambda Architecture and develop solutions that support fast and slow moving data.
• Making use of coding languages such as Python, SQL, C#, R or PowerShell to develop solutions.
• Working with multiple different file types and formats such as Delta Parquet, JSON, XML, CSV.
• Designing solutions, development and work within a Delta Lake eco-system and architecture
• Implementing security to ensure data can be accessed appropriately based on ACL and or RBAC.
• Ensuring data is catalogued and appropriately labelled according to our Information Classification policy and recorded in our data catalogue.
• Ensuring alignment with GDPR and PCI standards where appropriate.
• Building re-usable datasets that business colleagues can safely and effectively discover and consume.
• Use knowledge of API Management tools and techniques to develop API proxies and make use of out of the box functionality to quickly add value, build composite api’s and enable data consumption

What you’ll need to bring to this Azure Data and Integration Engineer role…

• Problem-solving attitude
• Excellent written and oral communication skills
• Good understanding of Integration methodologies 
• Good Understanding of data architecture, engineering (including warehousing and transformation) methodologies
• Highly self‐motivated, self‐directed, and attentive to detail
• Ability to effectively prioritize and execute tasks.
• The ability to think laterally and constructively question established process.
• Willingness to learn new technology and technical skills to solve problems and bridge gaps
• Developing and integrating with Python, JSON and REST API’s
• Data Bricks
• Azure Data Factory
• Azure DevOps
• Azure Storage / Data Lake
• Azure Logic Apps
• Extraction, Transformation and Loading 
• Data modelling and data curation
• Analytics development 
• Report Development
• Relational database and SQL language
• Kusto Query Language (KQL)
• Microsoft Fabric and Power BI
• Azure Synapse
• Experience in developing and working with multiple Database languages
• Python

Qualifications Required…

• Previous experience as an Azure Data Engineer or similar role
• Understanding of software development lifecycle
• Demonstrable understanding of architecture methodologies.

Could you be a great addition to our team? Apply for this Azure Data and Integration Engineer role today and we’ll be in touch to explore how you could be part of our exciting future.

Closing date: Friday 5th July 2024