Vacances Air Canada Vacations - Montreal Office, 1440 St-Catherine West, Montreal, Quebec, Canada — full-time
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 forma