We have an exciting opportunity for a Data Analyst to join our award-winning Business Change and Technology team on a permanent basis. Reporting into the Data and Integration Manager you will design, build and optimise data and integration solutions to meet the needs of our internal customers using Microsoft and SAP toolsets. You’ll interpret data, analysing results using statistical techniques and provide ongoing reports. You will work with our architecture community to bring technology to life in-line with our technology strategy and architectural plans and roadmap.

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 20% 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 Data Analyst…

• Enabling our mission to ingest, store, cleanse, model and transform data for Insights, Machine Learning models, AI, dashboards and reports.
• Bringing to life our strategy to centralise multiple different domains of data and support production of 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.
• Where possible, creating extensible and re-usable models that our business colleagues can use
• Data Modelling & strong analytics skills in Analytics.
• Enabling a Lambda Architecture and develop solutions that support fast and slow moving data.
• Making use of coding languages such as C#, Python, R, SQL or PowerShell to develop solutions.
• Working with multiple different file types and formats such as JSON, XML, Parquet, CSV.
• 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.
• Ensuring alignment with GDPR and PCI standards where appropriate.
• Building re-usable datasets that business colleagues can safely and effectively discover and consume.

What you’ll need to bring to this Data Analyst role…

• Problem-solving attitude
• Excellent written and oral communication skills
• Highly self‐motivated, self‐directed, and attentive to detail
• Ability to effectively prioritize and execute tasks.
• Adept at queries, report writing and presenting findings
• Willingness to learn new technology and technical skills to solve problems and bridge gaps
• Developing and integrating with JSON and REST API’s
• Azure Data Factory
• Azure DevOps
• Azure Storage/ Data Lake
• SAP BI
• Extraction, Transformation and Loading 
• Report and Analytics Development
• Relational database and SQL language
• Kusto Query Language (KQL)
• Azure Data Explorer
• Databricks
• Azure Synapse

Qualifications Required…

• Previous experience as a Data Analyst or similar role
• Technical expertise regarding data models, database design development, data mining and segmentation techniques
• Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks)

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

Closing date: Wednesday 19th June 2024 at 11.59pm