As our new Senior Data and Analytics Engineer, you'll 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 Senior Data and Analytics Engineer, you’ll have access to a wide range of benefits including:Remote workingAnnual pay reviewsAccess to a generous discretionary profit share schemeAt Jet2.com and Jet2holidays we’re working together to deliver an amazing journey, literally! We work together to really drive forward a ‘Customer First’ ethos, creating unforgettable package holidays and flights. We couldn’t do it without our wonderful people.What you’ll be doing: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 will transform, cleanse and model our data into our enterprise data warehouse for consumption by both technical users 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.You’ll have experience working with data from a wide variety of data sources including different database platforms, flat files, API’s and event-driven data feeds.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! #J-18808-Ljbffr