Overview

We’re Travel Chapter - the holiday home people - and we’re on a mission to showcase great places to stay in the UK. While we’ve grown over the years from a small South West holiday letting agency to one of the market leaders in the industry, we’ve never lost sight of our strong family ethos, and we keep the same values at the heart of everything we do. We are looking for an experienced senior data engineer to join our growing Data Team. You’ll be working on exciting projects to take the business to the next level with building out the data held within our data warehouse. You will be involved in designing, building, testing and operating data transformations, working closely with colleagues within the product engineering team and other departments. The Travel Chapter is a data-led business, and the work that you carry out will enable Travel Chapter to provide staff, clients and owners a great experience when using our systems.

Responsibilities

• Develop and maintain data pipelines and ETL processes to integrate and transform diverse data sources into a unified data model.
• Design and implement data models and database schemas to store and manage large volumes of structured and unstructured data.
• Collaborate with people across the business, including product managers and developers, to define data requirements and understand data usage patterns.
• Optimise data solutions by leveraging techniques such as partitioning, indexing, and caching.
• Assist in troubleshooting production issues to resolution, ensuring that measures are put in place where possible to stop recurrence.
• Provide out-of-hours support as required in line with the organisation SLAs.
• Mentor and provide technical guidance to junior data developers and engineers.
• Develop and maintain data quality assurance processes to verify the accuracy, completeness, and consistency of the data.
• Stay updated with the latest industry practices and technologies.

Qualifications

• Minimum 5 years of working experience in data engineering.
• An excellent understanding of databases and SQL.
• Possess excellent written and oral communication skills.
• Essential commercial experience of: data warehousing, Snowflake, Python, SQL, JSON, XML, MySQL, MSSQL Server, AWS Glue, understanding of testing strategies, understanding of Agile methodologies.

Desirable

• Experience of ELT tools like Fivetran / Kleene / DBT.
• Experience using source code management tools (ideally git).
• PHP.
• Experience with Salesforce data models.
• Experience in the travel industry.

Benefits

• 25 days' paid holidays plus bank holidays
• A special day off for your or a loved one’s birthday
• £500 paid towards a holiday of your choice
• A paid day to volunteer with a charity close to your heart
• A friends and family discount scheme
• Life assurance for your peace of mind
• Social clubs for pet lovers, fitness enthusiasts, gardeners, sustainability champions, nutrition enthusiasts and more
• Exciting social events, including our famous Christmas parties