Data Engineer

At SITA we keep airports moving airlines flying smoothly and borders open. Our technology and communication innovations power the success of the global air travel industry.

Youll find us in 95% of international airports working closely with over 2500 transportation and government clients. Each partnership brings unique challenges and we thrive on delivering fresh solutions and cutting-edge tech to keep operations running like clockwork. We dont just move the world forward-were proud to be recognized as a Great Place to Work by 79% of our employees and certified in most of our growing locations. Here we feel empowered supported and inspired to grow.

Are you ready to love your job

The adventure begins right here with you at SITA.

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 SITAs 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 OCCams 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

• Experience with airline operational systems such as Netline SCHEDOPS XCREW or similar

Were all about diversity. We operate in 200 countries and speak 60 different languages and cultures. Were really proud of our inclusive environment. Our offices are comfortable and fun places to work and we make sure you get to work from home too. Find out what its like to join our team and take a step closer to your best life ever.

Flex Week: Work from home up to 2 days/week (depending on your teams needs)

Flex Day: Make your workday suit your life and plans.

Flex-Location: Take up to 30 days a year to work from any location in the world.

Employee Wellbeing: 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.

Professional Development: 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 Microsofts 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: Competitive benefits that make sense with both your local market and employment status.

SITA is an Equal Opportunity Employer. We value a diverse support of our Employment Equity Program we encourage women aboriginal people members of visible minorities and/or persons with disabilities to apply and self-identify in the application process.