Crew Data Solutions Analyst

JobCubby; Canada; On-site; CAD 90,000 - 130,000; Full time

Job summary

Air Canada is seeking a Crew Data Solutions Analyst to design, build, and maintain scalable data pipelines for crewing data, enabling analytics and decision support across the enterprise.

You will collaborate with data scientists, software engineers, and IT partners to ensure robust, secure data platforms and adherence to governance standards, with production-grade deployment mindset.

Qualifications

• Bachelor’s degree in Computer Science, Data Engineering, Software Engineering, or equivalent practical experience.
• 3–6+ years of experience in data engineering or related technical role.
• Strong experience with SQL and programming languages such as Python, Scala, or Java.
• Hands-on experience building and maintaining data pipelines using modern frameworks.

Responsibilities

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

Skills

SQL

Python

Scala

Java

Education

Bachelor's degree in CS/Data Eng

Tools

Spark

Kafka

CI/CD

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.

The Crew Data Solutions Analyst is responsible for designing, building, and maintain scalable, reliable and high‑quality data pipelines and platforms that enable advanced analytics, reporting and data science initiatives. The role focuses on transformation raw data from multiple internal and external sources into trusted, well‑governed data assets that support operational decision‑making, optimization initiatives and enterprise analytics. Working closely with business stakeholders, data scientists, software engineers and IT partners, the Crew Data Solutions Analyst ensures data solutions are robust, performance, secure and aligned with enterprise data and engineering standards.

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.

• 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.