Lead Data Engineer

About the RoleReporting to the Head of Data, Insights & Analytics you will lead a team of Data Engineers in the design, development and maintenance of Travel Counsellors’ data infrastructure. This role will be a high impact, multi-faceted working on data pipelines, our new strategic Data Platform and operationalising our analytical / data science solutions.

Principal Accountabilities

Support the design and implementation of data pipelines to ensure accurate, consistent and timely data across our analytical and reporting needs
Work closely with Data Scientists, Analysts and business SMEs to automate and scale our machine learning and AI capabilities
Support the development of our new cloud-based Data Platform, transforming systematic data into a business view for reporting and analytics
Take ownership of 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.

Benefits·       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

Requirements

Highly proficient in SQL
Highly proficient in Python
Strong understanding of data modelling techniques, e.g. 3NF, Kimball
Experience using cloud-based data platforms and infrastructure, e.g. Snowflake, BigQuery 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
Experience in deploying and maintaining machine learning models desirable
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