Crew Data Solutions Analyst

Air Canada; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Air Canada is seeking a data engineer to design, build, test, and maintain end-to-end data pipelines for crewing related data, enabling batch and near-real-time ingestion and delivery. You will develop scalable architectures, ensure data quality, and collaborate with data scientists to empower analytics and model development.

The role requires strong SQL, experience with Python/Scala/Java, and familiarity with cloud platforms.

Qualifications

• Bachelor’s degree in CS or related field or equivalent practical experience.
• 3–6+ years of experience in data engineering or related technical role.
• Strong SQL and programming in Python, Scala or Java.
• Hands-on experience building and maintaining data pipelines.
• Experience with data warehousing, data modeling, and distributed processing.

Responsibilities

• Design, build, test, and maintain end-to-end data pipelines for crewing data.
• Develop scalable data architectures to support analytics and modeling.
• Integrate data from multiple sources, ensuring data quality and consistency.
• Optimize pipelines and storage for performance, reliability, and cost.
• Collaborate with data scientists and analysts to enable access to clean data.

Skills

SQL

Python

Scala

Java

Data pipelines

Education

Bachelor’s degree in Computer Science or related

Tools

Azure

AWS

GCP

Spark

Kafka

Job description

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

Responsibilities

• Design, build, test, and maintain end‑to‑end data pipelines of crewing related data for batch and near‑real‑time data ingestion, transformation, and delivery.
• Develop and maintain scalable data architectures that support analytics, reporting, and advanced modeling use cases.
• Integrate data from multiple structured and unstructured sources, ensuring data quality, completeness, and consistency.
• Optimize data pipelines and storage for performance, reliability, and cost efficiency.
• Collaborate with data scientists and analysts to enable efficient access to clean, well‑modeled data sets for analysis and model development.
• Implement data validation, monitoring, and alerting to proactively identify and resolve data issues.
• Apply best practices for data engineering, including version control, automated testing, CI/CD, and documentation.
• Ensure adherence to data governance, security, privacy, and compliance standards.
• Support the transition from “laptop‑scale” solutions to production‑grade, enterprise‑scale data platforms.
• Troubleshoot and provide advanced support for data pipeline and platform issues.
• Evaluate and adopt new tools, frameworks, and technologies to continuously improve data engineering capabilities.
• Contribute reusable frameworks, templates, and code to support standardization and scalability across the enterprise.

Qualifications

• Bachelor’s degree in Computer Science, Data Engineering, Software Engineering, or a related quantitative discipline, or equivalent practical experience.
• 3–6+ years of experience in data engineering, software engineering, or a related technical role (level dependent).
• Strong experience with SQL and one or more programming languages such as Python, Scala, or Java.
• Hands‑on experience building and maintaining data pipelines using modern data engineering frameworks and tools.
• Experience with data warehousing, data modeling, and distributed data processing concepts.
• Familiarity with cloud platforms and data services (e.g., Azure, AWS, or GCP).
• Experience with big data technologies (e.g., Spark, Kafka) and relational / NoSQL databases is an asset.
• Understanding of DevOps and DataOps practices, including CI/CD and infrastructure‑as‑code.
• Strong problem‑solving and analytical skills with a pragmatic engineering mindset.
• Ability to collaborate effectively with cross‑functional teams and translate business requirements into technical solutions.
• Strong written and verbal communication skills.
• Demonstrated ability to work independently while contributing to team‑based delivery.
• Experience with Airline data and/or Human Resource data an asset.
• Demonstrate punctuality and dependability to support overall team success in a fast‑paced environment.

Conditions Of Employment

Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.

Linguistic Requirements

Based on equal qualifications, preference will be given to bilingual candidates.

Diversity and Inclusion

Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees’ unique contributions to our company’s success.

As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.

Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.