Data Architect – Aviation Domain (AWS / PostgreSQL / IATA)

Job summary

Design and implement scalable enterprise data architectures for aviation applications using AWS and PostgreSQL. Collaborate with cross-functional teams to integrate complex airline data systems while ensuring data quality, security, and compliance.

Job details

Job Title: Data Architect – Aviation Domain Location: Canada (Remote) Experience: 8–12+ Years Employment Type: Contract Job Summary We are looking for an experienced Data Architect with strong Aviation domain expertise to design and implement scalable data architectures using AWS, PostgreSQL, and modern data engineering technologies. The ideal candidate should have hands-on experience with IATA standards, aviation data models, airline systems, and data integration. Key Responsibilities Design and implement enterprise data architecture for aviation and airline-related applications. Develop scalable and secure data solutions using AWS cloud services. Design PostgreSQL database architecture, including data models, schemas, performance optimization, and data governance. Understand and work with IATA standards, aviation data models, and airline industry data. Integrate data from multiple aviation systems, applications, APIs, and external sources. Define conceptual, logical, and physical data models. Establish data architecture standards, principles, and best practices. Design data pipelines and integration patterns for batch and real-time data. Collaborate with Data Engineers, Application Architects, Business Analysts, and Aviation SMEs. Ensure data quality, security, scalability, availability, and compliance. Analyze existing data architectures and recommend modernization opportunities. Provide technical guidance and architectural documentation. Required Skills Aviation / IATA Strong experience in the Aviation / Airline domain. Knowledge of IATA standards, airline data models, and aviation industry processes. Experience with airline systems such as PSS, reservations, ticketing, passenger, flight operations, baggage, loyalty, or revenue management is preferred. Understanding of aviation data standards and formats is highly desirable. PostgreSQL Strong hands-on experience with PostgreSQL. Database architecture, schema design, indexing, partitioning, query optimization, and performance tuning. Experience with large-volume transactional and analytical datasets. Data Architecture Strong understanding of Data Modeling, ETL/ELT, Data Warehousing, Data Lakes, APIs, and Data Integration. Experience with OLTP and OLAP architecture. Knowledge of data governance, metadata, data quality, security, and lineage. Experience designing scalable and highly available data architectures.

What you’ll do

Design and implement scalable enterprise data architectures for aviation applications using AWS and PostgreSQL. Collaborate with cross-functional teams to integrate complex airline data systems while ensuring data quality, security, and compliance.

Requirements

Requires 8-12+ years of experience with strong expertise in the aviation domain and IATA standards. Candidates must possess hands-on experience in PostgreSQL database architecture and AWS cloud services.

Listed skills

• PostgreSQL · Preferred
• Amazon Web Services · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Architecture
• AWS
• PostgreSQL
• IATA Standards
• Aviation Domain
• Data Modeling
• ETL/ELT
• Data Warehousing
• Data Lakes
• API Integration
• Data Governance
• Database Schema Design
• Performance Tuning
• Airline Systems
• Data Pipelines

Job areas

• Data & Analytics
• Technology
• Software
• Transportation
• Consulting