Job Description: As our new Lead Data and Analytics Engineer , you will work as part of a multi-disciplinary, agile, data delivery team focused on the delivery of innovative, robust, and efficient data solutions to complex business problems.
You'll work alongside a team of passionate data professionals including other data and analytics engineers, test engineers, data scientists and data visualisation specialists.
As our Lead Data and Analytics Engineer , you'll have access to a wide range of benefits including: Mostly remote, with just one day each month at our Leeds Holiday House office.
Annual pay reviews Access to a generous discretionary profit share scheme What you'll be doing: Working alongside our solution and data architects, you'll be responsible for delivery of complex data and analytics solutions including the ingest of data from a wide variety of data sources into our analytics platforms (typically cloud-based but some work on our on-premise data analytics platforms) and the production of a range of data and analytics products including our data warehouse, analytical data sets and visualisations (supported by our central visualisation team).
You'll manage several Senior, Mid and Junior Level Data and Analytics Engineers an get involved with the recruitment and ongoing development of the team.
You'll design and lead modelling, transformation and cleansing of data into our enterprise data warehouse for consumption by both technical users such as our data science and data visualisation teams and non-technical business users.
You'll drive a data-first culture both within the data team and across the business by supporting continual learning and development within your team and data enablement activity across the wider business.
You will demonstrate a passion for data and encourage a similar passion within your team.
As part of a data-first culture you may also be involved in supporting production data assets.
What you'll have: Demonstrable experience in development of data pipelines working with data from a wide variety of data sources including different database platforms, flat files, API's and event-driven data feeds.
Experience building complex data transformations ideally using dbt.
Ideally, you'll have experience working on the design and data modelling stages of data warehouse projects and be comfortable with conceptual, logical and physical data modelling techniques as well as dimensional modelling techniques.
Experience using cloud data warehouse technology- Snowflake (preferred), Google BigQuery, AWS Redshift or Azure Synapse and experience working with key services on either GCP, AWS or Azure.
Key services include cloud storage, containerisation, event-driven services, orchestration, cloud functions and basic security/user management.
Experience working in an Agile delivery environment, ideally using Scrum and\or Kanban.
Able to demonstrate strong written and verbal communication skills and be comfortable communicating and building relationships with stakeholders at all levels.
Any experience developing or supporting data CI\CD pipelines regardless of tooling would be beneficial.
We use Microsoft Azure DevOps to run most of our CI\CD pipelines.
A strong understanding of SQL and be comfortable reading and writing complex SQL queries ideally across multiple platforms.
Knowledge of programming languages such as Python would be beneficial.
Although we have dedicated data visualisation specialists within the team, ideally you'll have experience in the design, development and implementation of visualisation solutions - Tableau (preferred), PowerBI, Quicksight.
Join us as we redefine travel experiences and create memories for millions of passengers.
At Jet2.com and Jet2holidays , your potential has no limits.
Apply today and let your career take flight!
#LI-Remote