data engineer airline operations

SITA; Barcelona; On-site; EUR 55,000 - 76,000; Full time

Benefits offered by this job

Гибридная работа

EAP

Champion Health

Job summary

SITA ищет инженера по данным для работы над OCCam — решением, обеспечивающим интеграцию и обработку авиационных данных. Ваша роль: внедрение пайплайнов, поддержка качества данных и совместная работа с командами разработки и науки с ориентацией на клиента.

Требуется знание Python/SQL, Airflow, построение канонических моделей и опыт работы с AWS. Гибридный формат с частичной удалёнкой допускается.

Qualifications

• Знание Python и SQL на уровне, достаточном для работы с реляционными базами данных (PostgreSQL, MSSQL, Oracle).
• Опыт Hands-on с Airflow и ETL/ELT-дизайном.
• Понимание дате-словарей, моделирования данных и канонической модели данных.
• Умение работать с linked servers MSSQL, маппингом схем и реконструкцией источников.
• Опыт работы с AWS data services и фреймворками качества данных.
• Понимание операционных данных авиации (рейсы, экипаж, назначения).
• Структурированное решение задач на «грязных» данных и взаимодействие с клиентами на этапах внедрения.
• Высокий уровень документирования и доверия к данным.
• Понимание обработки персональных данных и требований GDPR.
• Знание операционной деятельности авиакомпаний и связанных вызовов.
• Приветствуется: опыт работы с системами авиационной эксплуатации (NetLine, SCHEDOPS, XCREW).

Responsibilities

• Ingest heterogeneous airline systems and external sources into OCCam's data platform.
• Build a common datalake and canonical data model that the product reads from.
• Own data quality at the pipeline level, including checks, reconciliation and issue investigation.
• Partner closely with Back-End and Science teams so product features and algorithms are built on reliable data.
• Work on several airline integrations in parallel, accelerating client onboarding and keeping delivery organized and well documented.
• Map airline source schemas into a canonical data dictionary and document assumptions clearly.

Skills

Python

SQL

Airflow

ETL design

Data modeling

Data quality

GDPR

Documentation

AWS

PostgreSQL

MSSQL

Oracle

Canonical data model

Tools

PostgreSQL

Microsoft SQL Server

Oracle

AWS data services

Job description

Описание

SITA provides technology and communication solutions that support airports, airlines, and border operations across the global air travel industry. Its OCCam solution helps airlines manage and recover from operational disruptions.

Задачи

• Ingest heterogeneous airline systems and external sources into OCCam's data platform;
• Build a common datalake and canonical data model that the product reads from;
• Own data quality at the pipeline level, including checks, reconciliation and issue investigation;
• Partner closely with Back-End and Science teams so product features and algorithms are built on reliable data;
• Work on several airline integrations in parallel, accelerating client onboarding and keeping delivery organized and well documented;
• Map airline source schemas into a canonical data dictionary and document assumptions clearly.

Требования

• Proficient in Python and SQL across relational databases such as PostgreSQL, Microsoft SQL Server and Oracle;
• Hands‑on experience with Airflow and ETL or ELT design;
• Understanding of datalakes, data modeling and canonical data model design;
• Ability to work with MSSQL linked servers, schema mapping and source‑system reverse engineering;
• Experience with, or ability to quickly ramp up on, AWS data services and data‑quality frameworks;
• Understanding of airline operational data such as schedules, crew, assignments and qualifications, or readiness to build that domain knowledge quickly;
• Structured problem‑solving skills for messy real‑world data and ability to collaborate in client‑facing onboarding situations;
• Strong documentation discipline and a data‑trust mindset;
• Understanding of personal data handling, including crew data, under GDPR and client data‑privacy requirements;
• Knowledge of airline operations management and the operational, commercial, and customer service challenges faced by airlines;
• Nice to have: Experience with airline operational systems such as Netline, SCHEDOPS, XCREW or similar.

Условия

• Work from home up to 2 days/week, depending on the team's needs;
• Flexible workday;
• Up to 30 days a year to work from any location in the world;
• Employee Assistance Program (EAP) for employees and dependents 24/7, 365 days/year;
• Champion Health personalized wellbeing platform;
• Access to professional development platforms and programs;
• Competitive benefits aligned with the local market and employment status;
• Equal Opportunity Employer with an inclusive environment.