Job Description:
We, at Jet2 (UK's third largest airlines and the largest tour operator), have set up a state-of-the-art Technology and Innovation Centre in Pune, India. We are recruiting for an experienced and passionate Lead Data Engineer to join our growing Data Engineering program which is focused on making data assets from across our business available in cloud for advanced analytics, data science and automated decision making. These data assets drive mission critical processes across our commercial and operational teams contributing towards profitable growth, competitive advantage, and exceptional customer satisfaction. This is an exciting opportunity to help us become a leading data-driven organisation through the effective use of data.
The successful candidate will play a pivotal role in the success of our Data Analytics and Engineering program working closely with colleagues across our business and technical teams. You will be designing and building complex data solutions encompassing a wide variety of data sources and will ensure data is cleansed, well structured, and appropriately transformed to support a wide variety of use cases ranging from self-service analytics through to data warehousing and data science. We are looking for a thought-leader in the space of Cloud Data Engineering to not only enable us to deliver solutions efficiently but also evolve our Data Engineering processes and practices to ensure we continue to align with industry best-practice and take advantage of new developments in the Data Engineering landscape.
Key Responsibilities:
The successful candidate will be in a lead role with responsibility for both solution delivery and direct management of a team of upto 6-7 Data and QA Engineers (across Senior, Mid, Junior and Graduate levels). They will own delivery commitments for the team, run sprint planning and execute prioritisation order set by Product team, conduct performance reviews and 1:1s, and collaborate closely with stakeholders in Pune and Leeds UK.
- Design and deliver scalable and reliable business data products to support data consumers across Jet2.com and Jet2Holidays
- Ingest, cleanse and transform data from a wide variety of sources systems into our cloud data lake to support advanced analytics, data warehousing and data science
- Own the data modelling practice — develop and present Conceptual, Logical and Physical data models, design dimensional models (star/snowflake schemas, slowly changing dimensions, fact/dimension grain) and define data warehouse architecture standards for the team
- Design complex data analytics and engineering solution on snowflake and AWS.
- Support the continual training and development of your team and the wider data engineering function at Jet2 to keep up to date with developments in data engineering and drive continual improvement across the team
- Help to recruit, train and mentor a team of highly skilled Data and QA Engineers with a wide range of technical knowledge and experience
- Plan, prioritise and oversee end-to-end delivery for the team — managing capacity, sequencing work against business commitments, removing blockers and ensuring quality through robust QA practices
Technical Skills & Knowledge:
- Expert-level SQL — advanced query optimisation, window functions, complex joins and performance tuning across large datasets; experience with a variety of source systems including Microsoft SQL Server
- Deep expertise in Snowflake — warehouse sizing and cost optimisation, RBAC, micro-partitioning, clustering keys, Time Travel, Streams & Tasks, Snowpipe, and zero-copy cloning
- Experience working with DBT to develop, test, deploy and monitor data transformation code
- Expert in dimensional modelling (Kimball methodology — star and snowflake schemas, fact/dimension design, SCD types, grain definition) and data warehouse architecture patterns (medallion/layered architectures, data vault familiarity a plus)
- Expertise in working with and modelling both structured and unstructured data
- Experience working with Infrastructure as Code (IaC), specifically with Terraform (equivalent experience with similar technology also accepted)
- Experience of working in an Agile delivery team using automated build, deployment and testing (CICD, DevOps, DataOps)
- Experience with one or more programming language compatible with developing functionality on the above platform (Python or Java preferred)
- Data Visualisation tool (Tableau) knowledge is a plus
Soft Skills:
- Excellent communication skills – verbal and written
- Strong team and stakeholder management skills – you should have the ability to build strong relationships with people across a wide variety of teams and backgrounds
- Experience working with people across different geographical regions, particularly UK (Leeds and Sheffield) and India (Pune)
- Excellent planning and time management skills to ensure projects are delivered on time and to requirement with issues being escalated and addressed effectively
- Exceptional documentation and presentation skills – you will be responsible for documenting solution designs for presentation and sign-off as well as delivering internal presentation to support continual development of your team
Leadership & Organisation Skills:
- Lead a team of 6 Data and QA Engineers (Senior, Mid, Junior and Graduate level) working across multiple projects, with full accountability for delivery, quality and team development
- Set individual development goals, monitor, and manage performance, provide timely feedback and take responsibility for professional development of team members
