Data Engineer

Overview WELCOME TO SITA 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. You'll find us in 95% of international airports, working closely with over 2,500 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 don't just move the world forward-we're 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. PURPOSE 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. KEY 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 Qualifications EXPERIENCE 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 NICE-TO-HAVE Experience with airline operational systems such as Netline, SCHEDOPS, XCREW or similar WHAT WE OFFER We're all about diversity. We operate in 200 countries and speak 60 different languages and cultures. We're 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 it's 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 team's 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, 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: Competitive benefits that make sense with both your local market and employment status. SITA is an Equal Opportunity Employer. We value a diverse workforce. In 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. Starting Compensation Compensation Note Hidden (-999) Starting Compensation Compensation Note Hidden (-999)