Data Engineer

What makes the perfect pub? It’s great ales, delicious food, a welcoming atmosphere, and the warm welcome from a team that’s at the heart of everything we do.

The Inn Collection Group is a multi-award-winning pubs with rooms company, proudly located in some of the most outstanding destinations across the North of England and Wales. At ICG, we deliver exceptional hospitality by living and breathing our core values of respect, customer focused, warmth, , and honesty, all with the goal of Making People Happy.

How we say thank you!

Celebrate your birthday with an extra paid holiday.
Enjoy 50% off food at any of our Inns
Relax with a stay at any of our Inns during January, February, and March for just £1.
Take advantage of the chance to explore our beautiful locations, with 1/3 off room bookings all year round.
Experience a spontaneous trip away with £50 on same day bookings
It’s not just for you—your loved ones can enjoy 15% off bed and breakfast too!
24/7 confidential support is always there when you need it with our Employee Assistance Programme
Contribute to a company that gives back through our Give-inn back scheme
Join an award-winning team recognised as the Best Pub Employer at the Publican Awards.
Enjoy the convenience of free on-site parking

Rooted in the North, our support hub at Quorum Business Park in Newcastle serves as a central space where all our departments come together to collaborate and innovate. Located in a thriving business community, it reflects our strong connection to the region while providing a modern, dynamic environment to drive our collective success.

You'll Fit Right Inn

We have an exciting new opportunity for a Group Data Engineer to join us. You will be a key part of the BI and analysis function, building and delivering timely, accurate and insightful data.

Candidates should understand the importance of exceptional personable skills to accompany technical knowledge. We’re seeking intelligent, diligent, and friendly colleagues who can draw on their technical expertise to revolutionise our data-driven decision making and be a central part of our highly valued team. You will be reporting to the Head of IT.
Responsibilities & Duties

Responsible for obtaining and organising all company data from various systems (e.g. EPOS, PMS, Loyalty etc)
Building and maintaining a group data warehouse and entire ETL pipeline on Azure platform
Use technical expertise to ensure data is highly available, accurate and high quality for management information
Using automated tools to extract data from all locations and sources
Resolving data integrity issues across source and data systems
Develop and maintain our group’s Database and data systems to a highly usable format for our BI and FP&A Analysts
Working with 3rd parties to understand all our company data to present in the Data Warehouse or appropriate reporting database
Administration of existing SQL server database alongside the data warehouse
Daily monitoring of all databases and data sets, ensuring availability and accuracy
Protect data through application of secure by design principles
Keeps up to date with technological developments
Deliver ad hoc data projects (e.g. system data migrations) where required

Required Skills

Good Experience and technical skills in Programming languages such as SQL, Python, Spark SQL and others
Experience providing BI data sets, especially utilising Kimball Data Warehouse concepts
Experience of cleansing, Analysing, Preparing and Exploring data through ETL techniques
Ability to breakdown and deliver the needs of the business
Excellent analytical and communication skills.
Work experience as a Data Engineer or Data Analyst in a related field
Liaison and collaboration skills to work with others to undertake the role
Good interpersonal skills and the ability to relate to a wide range of people
Strong personal organisational skills with the ability to take responsibility for managing his/her own workload
Ability to create and manage databases to ensure maintainable, secure and optimised data availability to the business

Desirable

Minimum of 2-3 years of experience in database and project management, including programming, data mining, analysis, and reporting.
BA or master's in computer science, information systems, mathematics, machine learning, or similar (or a data analytics certification acquired through a specific program).
Experience of SQL Server Azure stack (Azure DevOps, Azure SQL Server, Data Factory, etc) or similar.
Experience working with large structured and unstructured datasets.
Evidence of good coding standards and development within Agile framework

This role will be based in our Head Office in Newcastle, but with the option of some home working once the initial training period has been successfully completed.