Senior Data & Analytics Engineer

• Build and maintain analytics-ready data models in our cloud data warehouse, transforming raw and curated data into trusted, well-documented datasets for business and analytical use
• Implement complex data models and transformations using SQL and dbt, with a strong understanding of how upstream transformations feed downstream analytical use cases
• Work with existing enterprise data models and dimensional structures, extending them to support new analytics requirements
• Own and contribute to the enterprise data warehouse, including dimensional models and analytical data sets for both technical users and non-technical business stakeholders
• Collaborate with data engineers on the ingestion and orchestration of data from databases, flat files, APIs, and event-driven feeds, ensuring downstream analytics requirements are considered early
• Work closely with analytics, data science, and visualisation teams to ensure data products are fit for purpose, performant, and trusted
• Support production data assets, including monitoring, issue resolution, and continuous improvement
• Help drive a data-first culture through data enablement activities, analytics best practices, and knowledge sharing across the data community
• Act as a senior technical contributor within the team, influencing standards, patterns, and ways of working

Technologies:

• Airflow
• AWS
• Redshift
• Azure
• BigQuery
• CI/CD
• Cloud
• Data Warehouse
• GCP
• Support
• Kanban
• Python
• SQL
• Snowflake
• dbt
• DevOps

• Strong experience building and maintaining analytics pipelines using SQL-first transformation patterns, ideally with dbt
• Solid understanding of data warehousing concepts, including how dimensional and analytical models are used downstream
• Advanced SQL skills, with the ability to write, read, and optimise complex queries across large datasets
• Experience working with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Synapse
• Experience working in a modern cloud environment such as AWS, GCP, or Azure, with exposure to core services such as cloud storage and orchestration
• Experience working in an Agile delivery environment such as Scrum and/or Kanban
• Strong communication skills and the confidence to work directly with stakeholders at all levels
• Experience contributing to or supporting data ingestion pipelines, including APIs and event-driven data sources
• Familiarity with orchestration tools such as Airflow and ELT architectures
• Experience implementing or working with data CI/CD pipelines, such as dbt tests, deployment pipelines, or automated checks
• Working knowledge of Python for data-related tasks, automation, or light engineering work
• An interest in data quality, observability, and analytics engineering best practices

hackajob is partnering directly with Jet2.com and Jet2holidays to hire for this role. At Jet2.com and Jet2holidays, we are here to deliver amazing journeys, guided by a Customer First mindset that creates unforgettable holidays and flights. We work as part of a multi-disciplinary, agile data delivery team alongside analytics and data engineers, data scientists, test engineers, and data visualisation specialists. We offer remote working, annual pay reviews, a generous discretionary profit-share scheme, and the opportunity to work with a modern data stack and shape analytics at scale. This role is analytics engineering first, focused on the analytics layer of our platform and on implementing and maintaining complex models in our Silver and Gold data layers. We use a contemporary stack including AWS, Snowflake, dbt, Airflow, SQL, and Python, and this role gives us the opportunity to influence how data is modelled, trusted, and used across the organisation.