Master Data Engineer - Hybrid

Pegasus Airlines; Pendik; On-site; TRY 2,561,000 - 3,416,000; Full time

Job summary

A leading airline company in Turkey is looking for a Master Data Engineer with extensive experience in data warehousing. The ideal candidate should hold a degree in a quantitative field and have significant experience with PL-SQL and ETL tools. Responsibilities include developing data infrastructure and collaborating on reporting solutions. The position offers a flexible work environment and several employee benefits, including discounted flights and health insurance. Join us in shaping the future of aviation.

Benefits

Discounted flight tickets

Private health insurance

Food voucher

Remote working options

Social activity clubs

Performance-based bonus

Qualifications

• Minimum 12 years of data warehousing experience.
• Fluent in both written and spoken English.
• Ability to analyze, understand, and extract insights from complex datasets.

Responsibilities

• Design, model, develop and maintain data infrastructure.
• Ensure efficiency, scalability, and reliability of the Data Warehouse.
• Collaborate with analysts to identify reporting needs.

Skills

PL-SQL programming

Data warehousing

Analytical skills

Problem-solving

Team collaboration

Communication

Experience with ETL tools

Experience with BI tools

Python

Data analysis

Education

University degree in Engineering or related field

Tools

ETL tools (ODI, Informatica, ABInitio)

Oracle DWH concepts

BI tools (Power BI, Cognos, MSTR)

Job description

We are Pegasus Airlines!

We are Pegasus. We represent the new generation in Turkish aviation. With our motto: Everyone has the right to fly, we inspire our guests to travel with low fares thanks to our business model.

As your digital airline, our guest‑centric approach offers digital technologies and unique innovations that enhance the travel experience.

Today, we operate connecting flights to more than 50 countries across Türkiye, Europe, North Africa, the Middle East, Russia, and Central Asia. We have one of the youngest fleets in Turkey, which exceeds 110 aircraft in 2025.

Are you ready to embark on your Pegasus career path as our Master Data Engineer, flight number PC-2025?

Requirements

• University degree in a highly quantitative field such as Computer Engineering, CTIS, Statistics, Mathematics or any other Engineering Sciences
• Minimum 12 years of data warehouseing experience
• Ability to analyze, understand, and extract meaningful insights from complex datasets
• Proficiency in PL‑SQL database programming language and ability to write code from scratch
• Proficiency in ETL tools such as ODI, Informatica, ABInitio, etc. and minimum 10 years' experience at least one of them.
• Proficiency in Oracle DWH concepts
• Experience in Python and most common data manipulation and data science packages is a plus (e.g. Pandas, Numpy, SKLearn, …)
• Experience in BI tools such as Power BI, Cognos, MSTR, etc. is a plus (e.g. Pandas, Numpy, SKLearn, …)
• Demonstrated problem‑solving skills, ability to multi‑task and set priorities.
• Strong analytical mindset with good attention to details, focus on both technical and business aspects
• Fluent in both written and spoken English
• Team player with strong collaboration skills
• Good communication skills

In this role you will

• Design, model, develop and maintain the data infrastructure to effectively leverage technology and data.
• Ensure the efficiency, scalability and reliability of the Data Warehouse and the data sets within your area of responsibility.
• Design, develop, maintain and optimize the data pipeline from source systems to Data Warehouse.
• Carry out project‑based integration and modeling efforts, in addition to existing application software.
• Develop BI reports.
• Collaborate with analysts and stakeholders to identify and develop solutions for analytical and reporting needs.
• Stay updated on new technologies, suggesting innovations to improve efficiency, reduce costs, increase revenue, or align with Pegasus's goals.
• Research developments in air transportation and IT applications, presenting suggestions to benefit Pegasus.

What Pegasus Airlines can offer you

• Discounted domestic and international flight tickets that includes first‑degree family members, For single candidate can add +1 person, Discounted flight with contracted airlines to destinations where there are no flights
• Private health insurance
• Food voucher
• Remote and flexible working hours on certain days according to working model, allowance for remote working days
• Fun@Fly Social Activity Clubs (Social clubs such as theatre club, sailing, trekking, running, basketball , volleyball and football teams, e‑sports team)
• Kindergarten opportunity for female employees (Istanbul, Izmir, Antalya)
• Performance based bonus system
• Shuttle

Discover Pegasus Airlines!

Our Framework for a Sustainable Future prioritises our impact on the environment and society, as well as economic development. We call our route Sustainable Future. By 2050, we aim to eliminate carbon emissions from our operations, and we are working towards this goal. We are proud of a rich governance culture that is developed through a perspective open to continuous improvement and the feedback of our stakeholders. We regularly and transparently share our targets and performance on these issues with the public. Gender equality is at the foundation of our corporate culture. We are one of the pioneering airlines that have signed IATA's voluntary initiative "25by2025" to increase the representation of women in all areas of the aviation industry, including pilot, technician and management ranks. We were the first airline in the world to join the UN Women's Empowerment Principles (WEPs) platform. Listen to every different voice in our quest for a more equal tomorrow for future generations and we call our voice #PegasusHarmony 💛