Senior Analyst Data & Analytics - Data Developer

Air Canada

Air Canada, recognized as a premier North American airline, invites a dedicated Senior Analyst in Data & Analytics to join its progressive team. This role is crucial for developing and managing data pipelines and involves close collaboration with various stakeholders to meet data requirements. The team thrives on innovation in data engineering within passenger aviation.

In this role you can expect to have the responsibilities:

• Design and maintain scalable data pipelines with tools like Talend, Snowflake, Azure Data Factory, and Azure Databricks.
• Implement data engineering patterns to ensure integrity and consistency.
• Work with data architects and business stakeholders on solution mapping and data models.
• Ensure data security and compliance with best practices.
• Support data analysts with defect analysis and resolution.
• Review code for compliance with standards and conduct code merges.
• Monitor and troubleshoot data pipelines for optimal performance.

This role comes with the following benefits:

• Diverse and inclusive work environment.
• Opportunity to work with a leading airline in North America.

This role requires you to have:

• Experience in pipeline design and development using Azure and Snowflake.
• Proficiency in complex SQL and scripting languages like PySpark, Python, or Scala.
• Strong understanding of Azure cloud services and data warehousing concepts.
• Experience in ETL/ELT pipeline design and implementation.

You would benefit from having:

• Knowledge of data vault modeling.
• Snowflake certification.

Preference for bilingual candidates. Candidates need responsibility for work permits. Strong commitment to diversity and inclusion.