Data Engineer

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 setting up a brand-new Data Engineering program with an aim to make the data assets high quality & available for scientific study leading higher monetization in terms of increased revenue, improved operational efficiency and high-quality service. We are looking for a Data Engineer to join our Data Engineering practice and help us fulfil our aspiration and journey to become a data first organization

The successful candidate will play a key role in the success of the Data Engineering team, the incumbent would work closely with Date Engineering Team Lead and other members of the wider data team to build a high quality data platform on new edge technology consisting of Cloud Datawarehouse, Advanced Data Ingestion framework and Data Science Toolkit to enable organization leverage data for analytics and decision making. The person is expected to bring high level of expertise and execution in the field of data engineering and help build a highly effective data platform for consumers across Jet2.

Key Responsibilities:

The successful candidate will work independently on data engineering projects with zero or minimal guidance, the incumbent is expected to operate out of Pune location and collaborate with various stakeholders in Pune, Leeds and Sheffield.

Comprehend the existing Datawarehouse / Datamart environment of Jet2, build solid understanding of existing ETL/ELT, Storage and Reporting mechanism

Design and develop scalable solutions to store and retrieve high volume of data on cloud; gathering business requirements to design and create conceptual, logical workflows in Snowflake

Work on migrating data in RDBMS & Datawarehouse to Cloud Datawarehouse or Data lake (Snowflake)

Develop and maintain data pipelines to ensure high quality data availability for key data science and analytics projects for Jet2 business

Deliver projects small or big with perfection leading to high customer satisfaction; focus on building reusable code/framework to accelerate development.

Experience in implementing dimensional models in Datawarehouse.

Technical Skills & Knowledge

Advance SQL knowledge and experience of working with a variety of databases

Exposure in data modelling (dimensional modelling and data vault 2.0 desirable)

Expertise in the delivery of Data Engineering and Data Warehousing to Cloud Platforms (AWS Preferred)

Experience of or exposure to Cloud Data Warehouse platforms (Snowflake Preferred) Experience in Python

Experience in the design and implementation of API's would be beneficial as would experience interacting programmatically with third-party API endpoints

Experience with source control tools and automated deployment pipelines (Git, TFS, Cloud Build, etc.)

Experience of Infrastructure as Code would be beneficial (preferred)

Knowledge & experience of building containers using Docker would be beneficial

Experience of working in Agile Scrum framework to deliver high quality solution

Experience in building streaming data pipelines Kafka, Kinesis etc (preferred)

Experience with no-SQL DBs Mongo. DynamoDB, Cosmos (preferred)

Soft Skills

Good communication skill Written & Verbal

Ability build strong relationship with people across teams

Experience of working with people from different geographies particularly UK & US

Leadership & Organizational Skill

Collaborate with broader Data team including Data Architects, Business Analysts, Product stakeholders, peer Data Engineering Teams, Business Intelligence and Visualisation Teams.

Work closely with Data Engineering Team Lead and Senior Data Engineers to execute the projects with an eye on details

Qualifications & Certification

B.E./ B. Tech / MTech in IT or Computer Science from reputed institute (preferred) or Master Degree in Quantitative Subjects e.g. Mathematics, Statistics & Economics

Cloud Certification in GCP/AWS/Azure (Desirable)

Snowflake Certification (Desirable)

Certification or Specialization in Data Engineering (Desirable)

Certification on Airflow (Astronomer etc.). (desirable)

Training/Certification in DBT (desirable)