Data Engineer

About Us

At Travel Counsellors, our customers, communities, and colleagues are at the heart of everything we do, and this is what sets us apart. We prioritise relationships over transactions, connecting deeply with our customers through the moments that matter. For over 30 years, we’ve been changing lives as the UK’s leading travel marketplace for self-employed travel entrepreneurs, empowering over 2,000 independent agents to build successful leisure and corporate travel businesses.

With the support of a talented team of 400+ people in our Support Offices, our Travel Counsellors create exceptional experiences and build lasting personal connections, ensuring customers return time and time again. Our unique approach has earned us numerous accolades, including "Best Place to Work in Travel" at the 2022 TTG Travel Industry Awards, a spot on the Sunday Times Best Places to Work list (2023-2024), and the Queen’s Award for Enterprise in Innovation.

As we experience exceptional growth, with record revenues exceeding £1bn, we’re looking for outstanding individuals to join our expanding Head Office team and help us continue to thrive.

Role Description

Reporting to the Head of Data, Insights & Analytics you will be part of a team of Data Engineers who are building out scalable, secure and available data products. This role will be multi-faceted working on data pipelines as well as our new strategic Data Platform and supporting our analytical / data science workstreams.

Principal Accountabilities

• Work closely with data analysts, data scientists, and business stakeholders to gather requirements and deliver actionable insights through robust data models.

• Support the design and implementation of data pipelines to ensure accurate, consistent and timely data across our analytical and reporting needs

• Develop our new Data Platform, transforming systematic data into a business view for reporting and analytics

• Maintain our existing Microsoft technology (SQL Server, SSIS, SSAS, SSRS) whilst delivering on our migration plans to cloud-based technology

• Create and maintain comprehensive documentation for data processes and architectures. Provide training and support to team members and stakeholders.

• Stay updated on industry trends and best practices in data engineering, advocating for continuous improvement within the team.

• Lead data-related projects, ensuring timely delivery while balancing multiple priorities and stakeholder needs.

Educational/Professional Standards

• Highly proficient in SQL
  
• Python programming desirable
  
• Strong understanding of data modelling techniques, e.g. 3NF, Kimball
  
• Experience using cloud-based data platforms and infrastructure, e.g. Snowflake, AWS, GCP etc
  
• Experience building data integrations and understanding of best practices
  
• Understanding of the development lifecycle and best practices
  
• Desire to build relationships with an ability to deliver solutions to meet customers needs
  
• Experienced in the use of BI tools such as PowerBI / Tableau desirable
  
• Understanding of the regulatory environment and the need for data to comply with GDPR.

Our Benefits

Working here at Travel Counsellors, we value the hard work and effort that our colleagues put in. Because of this, you can expect a wide range of employee benefits including:

• A competitive basic salary + annual company bonus
• Flexible hybrid working model
• Career development and promotional opportunities
• 25 days holidays (increasing to 28 after 5 years of service)
• A Moments That Matter day (annually)
• Enhanced Maternity / Paternity pay
• Holiday buy and sell (up to 5 days per year)
• 3 paid days charity leave
• Company events, socials, and incentives
• 3x annual salary death in service benefit
• Company Pension scheme
• Costco Membership
• Salary sacrifice, company car scheme
• Cycle to Work Scheme
• Employee Assistance Programme
• Free breakfast, fruit, and hot/cold beverages
• Referral scheme
• Employee discount
• Private Medical Insurance (taxable benefit) or Healthcare Cash Plan (costs incurred by employees)