Data Analyst Developer

Vacances Air Canada Vacations / Air Canada Rouge • Montreal, QC

7d • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

• Ability to explain complex technical "plumbing" to non-technical business leaders.
• Understanding of data privacy laws (GDPR, Canadian privacy act), scoped data (PCI, PII) and security governance.
• Ability to identify and resolve data-related challenges
• Comfortable working in an evolving environment where technology matures rapidly.
• Ability to document clearly complex pipeline and principles.
• Fully Bilingual an asset.
• Knowledge of the travel industry is a plus.

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.

Benefits

• Generous employee travel program
• Hybrid work model: Corporate Mandate of 4 days in office (Tuesday, Wednesday, Thursday + 4th day of your choice) and 1 day from home
• Health and dental benefits for you and your family
• Training and development tools

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed