Senior Data & Analytics Engineer

Jet2.com Limited; Leeds; Remote; GBP 50,000 - 70,000; Full time

Job summary

A major travel company based in the UK is seeking a Senior Data and Analytics Engineer to deliver complex data solutions and drive a data-first culture. The ideal candidate will have extensive experience with data pipelines, cloud data warehouses like Snowflake, and skills in SQL. This role provides opportunities for remote work and professional growth within a dynamic, agile team.

Benefits

Remote working

Annual pay reviews

Generous profit share scheme

Qualifications

• Demonstrable experience in development of data pipelines.
• Experience building complex data transformations ideally using dbt.
• Strong understanding of SQL with complex query capability.
• Any experience developing or supporting data CI/CD pipelines would be beneficial.

Responsibilities

• Deliver complex data and analytics solutions for various data sources.
• Transform, cleanse, and model data into the enterprise data warehouse.
• Drive a data-first culture and support continual learning and development.

Skills

Data pipeline development

Data transformation using dbt

Cloud data warehouse technology (Snowflake, BigQuery)

Agile delivery environment (Scrum/Kanban)

Strong SQL skills

Tools

Microsoft Azure DevOps

Cloud platforms (AWS, GCP, Azure)

Job description

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 working
• Annual pay reviews
• Access to a generous discretionary profit share scheme

At 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!