remote
Data Architect - Airline Operations - WestJet Airlines
Systems Engineer
Design and govern end‑to‑end data architecture for airline operations, ensuring data integrity, scalability, and alignment with business goals using SQL, data modeling, ETL pipelines, and cloud‑based data warehousing solutions.
About the role
Key Responsibilities
- Define and maintain the enterprise data architecture for airline operations, covering data models, integration patterns, and storage solutions.
- Design, develop, and optimize ETL pipelines to ingest, transform, and load operational data from multiple sources.
- Collaborate with business analysts, engineers, and operations teams to translate functional requirements into robust data solutions.
- Establish data governance standards, data quality metrics, and security controls to ensure data integrity and compliance.
- Evaluate and implement cloud‑based data platforms and big‑data technologies to support scalability and performance.
Requirements
- 5+ years of experience in data architecture, data modeling, and data warehousing, preferably in transportation or airline domains.
- Strong proficiency with SQL and relational database design; experience with NoSQL or columnar stores is a plus.
- Hands‑on experience building and managing ETL processes using tools such as Apache Airflow, Informatica, or similar.
- Knowledge of cloud platforms (AWS, Azure, or GCP) and modern data lake/warehouse solutions.
- Demonstrated ability to enforce data governance, data quality, and security best practices.