WHO WE ARE
At Air Canada Vacations, we’re in the business of making dreams travel. That’s why we offer vacation packages, tours, cruises and more tailored to everyone’s individual needs. We like to say we have a vacation for every traveller because we do!
If you're someone who's passionate about exploring the world and sharing that enthusiasm with our customers, we'd love to welcome you to our team.
For over 50 years, Air Canada Vacations has been making travel easy, so come and join us in helping fellow Canadians create unforgettable memories wherever they go.
Don’t miss this opportunity! Submit your application by November 6, 2026 to be considered for this exciting opportunity.
JOB TITLE: Data Analyst Developer
POSITION STATUS: Permanent – Full Time
DEPARTMENT: IT - Operations
LOCATION : Montréal or Mississauga
WHAT YOU'LL BE DOING
Reporting to the Lead Data Analyst Developer, the Data Analyst Developer primary function is to participate in the analysis, development, integration and automation of various data pipelines and data infrastructure within the ecosystem of Air Canada Vacations. The Data Analyst Developer is also to support the Data Architect in the transformation of Air Canada Vacation into an agile, cloud centric organization, targeting a replatforming toward a data lake/lake house based environment
Key Responsibilities:
- Develop and maintain Data Pipelines to move and transform data in a medallion based data lake / lake house architecture.
- Participate in all phases of the software development lifecycle including design, development, testing, documentation, quality assurance support and maintenance.
- Adhere to design, coding, testing and change control best practices including version control, code review, user acceptance tests, observability/operationalization and documentation.
- Analyse business requirements with the users and design/implement systems or modifications to meet those requirements.
- Provide third level support for data infrastructure and data transformation pipelines.
- Take an active role in the implementation of Proof Of Concepts to confirm, reinforce or validate technological decisions.
- Create and maintain Technical Specifications documents relating to data pipelines.
- Develop and maintain operational reports.
- Support the BI team in the implementation and maintenance of the semantic layer.
WHAT YOU BRING TO THE TEAM
Training/Certification/Experience
- Communication Skills: Ability to explain complex technical "plumbing" to non-technical business leaders.
- Security & Compliance: Understanding of data privacy laws (GDPR, Canadian privacy act), scoped data (PCI, PII) and security governance.
- Problem-Solving & Analytical Thinking: Ability to identify and resolve data-related challenges
- Agile Mindset: Comfortable working in an evolving environment where technology matures rapidly.
- Technical documents: Ability to document clearly complex pipeline and principles.
Qualifications
- 10+ years experience in an IT role.
- 5+ years hands-on experience developing and maintaining ETL/ELT data pipelines. (SSIS or Spark based platforms)
- 5+ years experience in a multi-cloud environment.
- Advanced knowledge of relational, non-relational databases and data lakes. (MSSQL, Postgres, DynamoDb, redis, Cloud object storage)
- Strong understanding of Star Schema, Snowflake Schema, and Medallion (Bronze/Silver/Gold) architectures.
- Advanced SQL and Python (PySpark) knowledge.
- Hands-on experience with Delta Lake, Apache Spark, and Parquet formats.
- Experience dealing with PCI and PII scoped data.
- Knowledge of agility principles.
- Knowledge of UML.
- Fully Bilingual an asset.
- Knowledge of the travel industry is a plus.
WHY WORK WITH US?
- Our team loves to travel, and we have one of the most generous employee travel programs in the industry. You’ll be eligible for travel privileges for yourself and other eligible persons once you’ve completed 6 months of service
- Hybrid work model: Corporate Mandate of 4 days in office (Tuesday, Wednesday, Thursday + 4th day of your choice) and 1 day from home
- We value your wellbeing and offer a wide variety of benefit plans, including health and dental, for you and your family
- We offer training and development tools to help unlock your full potential
Please note that these benefits apply to permanent, full-time employees.
Visit our Careers page for a full list of benefits.
OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION
Air Canada Vacations is committed to ensuring a Diverse, Equitable, and Inclusive Workplace, fundamental to its core values. We celebrate the uniqueness of every individual, listen to every voice, and instill a sense of belonging in our people that allows each team member’s authentic self to truly shine.
We encourage individuals of all backgrounds to apply as we strive to create a diverse team that mirrors the diversity of the customers and communities we serve as an equal opportunity employer. Should you require any accommodation, please inform us and we will work with you to meet your accessibility needs. For any accessibility-related assistance, requests for information in accessible alternative formats or to report any accessibility problems, please share in your application.
Linguistic Requirements
When qualifications are equal, preference will be given to bilingual candidates. The position involves daily interactions with partners, clients, and colleagues located outside of Quebec.
WHY WORK WITH US?
- Our team loves to travel, and we have one of the most generous employee travel programs in the industry. You’ll be eligible for travel privileges for yourself and other eligible persons once you’ve completed 6 months of service
- Hybrid work model: Corporate Mandate of 4 days in office (Tuesday, Wednesday, Thursday + 4th day of your choice) and 1 day from home
- We value your wellbeing and offer a wide variety of benefit plans, including health and dental, for you and your family
- We offer training and development tools to help unlock your full potential
Please note that these benefits apply to permanent, full-time employees.
Visit our Careers page for a full list of benefits.
OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION
Air Canada Vacations is committed to ensuring a Diverse, Equitable, and Inclusive Workplace, fundamental to its core values. We celebrate the uniqueness of every individual, listen to every voice, and instill a sense of belonging in our people that allows each team member’s authentic self to truly shine.
We encourage individuals of all backgrounds to apply as we strive to create a diverse team that mirrors the diversity of the customers and communities we serve as an equal opportunity employer. Should you require any accommodation, please inform us and we will work with you to meet your accessibility needs. For any accessibility-related assistance, requests for information in accessible alternative formats or to report any accessibility problems, please share in your application.
Linguistic Requirements
When qualifications are equal, preference will be given to bilingual candidates. The position involves daily interactions with partners, clients, and colleagues located outside of Quebec.
Skills Required
- 10+ years of experience in an IT role
- 5+ years of hands-on experience developing and maintaining ETL/ELT data pipelines using SSIS or Spark-based platforms
- 5+ years of experience in a multi-cloud environment
- Advanced knowledge of relational and non-relational databases and data lakes
- Knowledge of MSSQL, PostgreSQL, DynamoDB, Redis, and cloud object storage
- Strong understanding of star schema, snowflake schema, and medallion architectures
- Advanced SQL knowledge
- Advanced Python and PySpark knowledge
- Hands-on experience with Delta Lake, Apache Spark, and Parquet formats
- Experience handling PCI- and PII-scoped data
- Knowledge of agile principles
- Knowledge of UML
- Ability to explain complex technical concepts to non-technical business leaders
- Understanding of GDPR, Canadian privacy legislation, data privacy, and security governance
- Ability to document complex data pipelines and principles clearly
- Fully bilingual capability
- Knowledge of the travel industry
What We Do
Canada's largest airline, the country’s flag carrier and a founding member of Star Alliance, the world's most comprehensive air transportation network celebrating its 25thanniversary in 2022, Air Canada provides scheduled passenger service directly to 51 airports in Canada, 51 in the United States and 86 internationally. It is the only international network carrier in North America to receive a Four-Star ranking from Skytrax, which in 2021 gave Air Canada awards for the Best Airline Staff in North America, Best Airline Staff in Canada, Best Business Class Lounge in North America, and an excellence award for its management of the COVID-19 pandemic.
