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.