Data Engineer

Reporting to the Lead Data Engineer, you will be part of the Data Engineering team building scalable, secure and available data products and our modern Data Intelligence Platform. This multifaceted role spans data pipelines, integrations, cloud data engineering and semantic models, alongside operationalising AI / ML products and building and managing AI agents and agentic workflows. You will work closely with Data Science / AI, Insights and wider business colleagues to ensure solutions are trusted, observable, governed and connected to measurable business value., * Work closely with Insights, Data Science / AI, Technology teams and business stakeholders to translate business problems, decisions and workflows into secure, reusable data and AI engineering solutions.

• Design, build and operate reliable data pipelines, integrations and data products that provide accurate, consistent and timely data for reporting, analytics, automation and AI.
• Develop our modern Data Intelligence Platform, using Snowflake, dbt, Airbyte and associated cloud services to transform source data into reusable business models.
• Ensure data platform remains trusted, governed and cost-effective by proactively monitoring data quality, platform health, operational performance and governance controls.
• Maintain our existing Microsoft technology (SQL Server, SSIS, SSAS and SSRS) where required, while delivering controlled migration and legacy decommissioning plans.
• Build, integrate and manage AI agents and agentic workflows, including orchestration, tool and API integration, governed data access, evaluation, guardrails, observability, human oversight and lifecycle management.
• Work with the Data Science / AI team to operationalise and scale machine-learning models and AI products through repeatable deployment, validation, monitoring and support processes.
• Create and maintain tests, documentation, lineage, data-quality controls and operational runbooks; contribute to code review, shared standards and knowledge transfer across UK and offshore colleagues.
• Own the delivery of assigned workstreams, clearly communicating progress and dependencies.
• Stay updated on industry trends and best practices in data engineering, advocating for continuous improvement within the team.

• Proficient in SQL, with experience writing clear, performant and maintainable production code.
• Practical Python programming for data engineering, automation, integration and production support.
• Strong understanding of data modelling and semantic-layer techniques, including dimensional, relational and dbt-based approaches.
• Experience using modern cloud data platforms and services, particularly Snowflake, with the ability to support and migrate legacy Microsoft data technologies (SQL Server, SSIS, SSAS and SSRS).
• Experience building resilient data integrations using modern ELT, orchestration, API, batch or event-driven patterns.
• Good understanding of the software development lifecycle, including Git, peer review, automated testing, CI / CD and infrastructure-as-code principles.
• Experience or strong practical understanding of AI agent engineering, including LLM APIs, tool calling, orchestration, grounding / retrieval, evaluation, guardrails, monitoring and secure operation.

Pulled from the full job description

• Company pension
• Paid volunteer time
• Private medical insurance
• Company events, * Competitive salary + annual bonus
• Flexible hybrid working
• Career development opportunities
• 25 days holiday (increasing to 28 after 5 years)
• Enhanced Maternity/Paternity pay
• 1 day paid charity day
• Company events and incentives
• 3x salary death in service benefit
• Pension scheme
• Private Medical Insurance or Healthcare Cash Plan
• Free breakfast and beverages

At Travel Counsellors, our customers, communities, and colleagues are at the heart of everything we do. For over 30 years, we’ve empowered 2,200+ independent travel agents worldwide, helping them build successful businesses while providing deeply personal, human connections with their customers. Supported by a talented team of over 400 people in our Support Offices, we create unique travel experiences that keep customers coming back. Named the Best Place to Work in Travel (2022) and ranked in the Sunday Times Best Places to Work (2023, 2024 & 2025), we’re expanding rapidly and looking for exceptional individuals to join our Head Office team.