Data engineer in air travel

SITA; Barcelona; Hybride; EUR 45 000 - 70 000; Plein temps

Avantages offerts par ce poste

Удаленная работа 2 дня/неделя

Гибкость локации — до 30 дней в году

EAP и поддержка благополучия

Обучение и развитие — доступ к мировым

Конкурентные льготы

Résumé du poste

SITA ищет Data Engineer в Барселоне для ускорения onboard­ing авиакомпаний через интеграцию разнородных систем и создание единого datalake OCCam.

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

Qualifications

• Опыт работы с Python и SQL в Реляционных СУБД (PostgreSQL, MSSQL или Oracle).
• Опыт с Airflow и дизайном ETL/ELT.
• Понимание DatLakes, моделирования данных и канонической модели.
• Опыт работы с MSSQL linked servers, сопоставление схем.
• Опыт AWS data services и фреймворков качества данных.
• Понимание Airline Operations Management и GDPR/конфиденциальности данных.

Responsabilités

• Интеграция разнородных авиационных систем в платформу OCCam.
• Создание общего datalake и канонической модели данных.
• Обеспечение качества данных на уровне пайплайна и расследование инцидентов.
• Сотрудничество с Back-End и Data Science для надежности данных.
• Работа над несколькими интеграциями одновременно, ускоряя онбординг клиентов.
• Документация предположений и подходов к данным.

Connaissances

Python

SQL

Data modeling

Data quality

Documentation

Outils

Airflow

ETL/ELT

PostgreSQL

MS SQL Server

Oracle

AWS data services

Data lakes

Description du poste

Описание

As a Data Engineer, you will accelerate new airline onboarding by ingesting heterogeneous airline systems and external sources, and turning them into trusted data for OCCam, SITA's AI-powered Operations Control Center solution that helps airlines manage and recover from operational disruptions. You will be accountable for building a common datalake and canonical data model that the product, Back-End and Science teams can rely on. Reporting to the Head of Engineering - Disruption Management Solutions (OCCam), you will be part of the OCCam team. We are hiring two Data Engineers to grow the team.

Задачи

• 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

Требования

You are proficient in Python and SQL across relational databases such as PostgreSQL, Microsoft SQL Server and Oracle You have hands-on experience with Airflow and ETL or ELT design You understand datalakes, data modeling and canonical data model design You can work with MSSQL linked servers, schema mapping and source-system reverse engineering You have experience with, or can quickly ramp up on, AWS data services and data-quality frameworks You understand airline operational data such as schedules, crew, assignments and qualifications, or are ready to build that domain knowledge quickly You bring structured problem-solving to messy real-world data and can collaborate in client-facing onboarding situations You have strong documentation discipline and a data-trust mindset You understand the importance of handling personal data, including crew data, under GDPR and client data-privacy requirements You possess Airline Operations Management knowledge and understand the operational, commercial, and customer service challenges faced by airlines. Будет плюсом: Experience with airline operational systems such as Netline, SCHEDOPS, XCREW or similar

Условия

• Our offices are comfortable and fun places to work, and we make sure you get to work from home too.
• Work from home up to 2 days/week (depending on your team's needs)
• Make your workday suit your life and plans.
• Take up to 30 days a year to work from any location in the world.
• We have got you covered with our Employee Assistance Program (EAP), for you and your dependents 24/7, 365 days/year.
• We also offer Champion Health - a personalized platform that supports a range of wellbeing needs.
• At SITA, we believe growth fuels innovation. Our learning ecosystem offers access to world-class platforms and programs designed to help you thrive.
• From LinkedIn Learning, Microsoft's Enterprise Skills Initiative, and Airport Council International -available to all employees-to specialized solutions like Pluralsight for technology upskilling, Harvard Business Publishing for people leadership, Stanford for strategic development and many others, we align learning opportunities with your Development Plan and our business priorities.
• Your development journey is supported every step of the way.
• Competitive benefits that make sense with both your local market and employment status.