Senior Analyst Data

5 days ago


Dorval Quebec HS, Montréal, Canada Air Canada Full time
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.

We are seeking a highly skilled Senior Analyst Data & Analytics (Data Developer) to join our dynamic team. The ideal candidate will have extensive experience in the design and development of Data pipelines and possess a strong understanding of data engineering principles, standards, and data warehousing concepts. This role involves designing, developing, unit testing, maintaining, deploying, and scheduling data pipelines in an agile environment.

Responsabilities:
  • Design, develop, and maintain robust, scalable data pipelines using Talend, Snowflake, Azure Data Factory, and Azure Databricks. These data pipelines will ingest, transform, and load data from diverse sources and formats, including both structured and unstructured data, received as batch and streaming inputs
  • Implement and maintain data engineering patterns, ensuring data integrity and consistency.
  • Collaborate with Product Owners, data architects, data analysts, data modelers, and business stakeholders to understand data requirements, data solutions, mapping documents, and data models.
  • Implement data security measures and best practices to ensure data privacy, integrity, and compliance with company standards.
  • Provide technical assistance to the Data Analyst in analyzing defects and issues.
  • Ability to analyze complex data sets and develop actionable insights.
  • Ability to understand the existing data warehouse application and be able to fix.
  • Conduct code reviews and ensure adherence to coding standards and best practices.
  • Create pull requests, perform code merges, create/update deployment documents, and provide support to the release team during deployments.
  • Monitor and troubleshoot data pipelines to ensure smooth operation and performance.
Qualifications
  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • 3+ years of experience in pipeline design and development (Batch and Streaming) using Azure/snowflake cloud services and Talend.
  • At least 5 years of IT experience, including 3 years dedicated to designing and developing ETL/ELT pipelines for Enterprise Data Warehouse applications.
  • Proficiency in complex SQL, Stored procedures and experience with PySpark, Python, or Scala.
  • Strong knowledge of Azure cloud services and tools, including ADLS, Azure DevOps, Azure Event Hubs, AAD, RBAC, and AzCopy.
  • Collaborate with Cloud Administrators to create and configure cloud services.
  • Ability to configure alerts and monitoring in cloud services to track incoming data and pipeline execution.
  • Strong understanding of data warehousing concepts and dimensional modeling.
  • Experience with understanding of data vault modeling is a plus.
  • Familiarity with Agile methodologies and agile project management tools.
  • Strong analytical, decision-making skills and demonstrated ability to learn new tools and systems.
  • Acquired Snowflake certification is a plus.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills.
Conditions of Employment:
  • Candidates must be eligible to work in the country of interest, at the time any offer of employment is made and seeking any required work permits/visas or other authorizations which may be required is the sole responsibility of the candidates applying for this position.
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.


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. We are seeking a highly motivated, energetic, and ambitious individual to learn and progress in their career...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. We are seeking a highly motivated, energetic, and ambitious individual to learn and progress in their career...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. Air Canada Cargo is seeking an Analyst, Cargo AI Transformation to help drive our data-driven initiatives. In...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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 Income Tax Analyst will be reporting into the Manager, Income Tax Optimization. The Analyst will be...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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 Specialist, Data & Analytics (Snowflake Database Administrator) will respond as a Technical Data steward...

  • Pension Analyst

    3 weeks ago


    Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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 Manager, HR Data Audit & Governance is responsible for ensuring the integrity, accuracy, and governance...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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 Senior Analyst, Application Development and Maintenance, develops, delivers and maintains applications as...


  • Saint-Laurent, Quebec, H1E, Montréal, Canada Fed Supply Full time

    I'm Lou REYMOND, Recruitment Advisor at Fed Supply, and I am looking for the next Senior Supply Analyst for one of our clients, a Canadian company specializing in nationwide distribution. The Senior Supply Analyst plays a critical role in enhancing and optimizing supply chain processes to improve performance and reduce costs. This individual will...

  • Analyste principal

    5 days ago


    Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    Description Appartenir à Air Canada, c'est appartenir à un symbole canadien, Air Canada récemment élue meilleur transporteur aérien en Amérique du Nord. Faites décoller votre carrière en vous joignant à notre équipe novatrice et diversifiée à l'avant-garde du transport aérien de passagers. Nous sommes à la recherche d'une...

  • Data Engineer

    1 week ago


    Dorval, Quebec, Montréal, Canada SageBeans RPO Full time

    Job Title: Data EngineerLocation: Dorval (Montreal) hybrid 2x/week in DorvalJob Type: Permanent Must be fluent in French and some English · With at least 5-7 years of experience in data engineering.· This is a back-end position; we are not looking for a BI analyst or developer here but a data engineer.· Must is to do data acquisition (REST API)· Carry...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. Do you enjoy developing cloud-based solutions to complex problems? Air Canada Digital Development teams are...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. Reporting to the Director of Revenue Management and Business Strategy, the successful candidate will lead and...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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 Manager, Loyalty Science and Innovation is a pivotal role responsible for driving the strategic...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. We are looking for a highly motivated person for a Manager, Commodity Taxes position in Montreal (YUL),...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. We are currently searching for a Labour Relations Specialist reporting to the Senior Manager, Labour...


  • Saint-Laurent, Quebec, H1E, Montréal, Canada Fed Supply Full time

    Je suis Lou REYMOND, Conseillère en recrutement chez Fed Supply, et je recherche le·la prochain·e Analyste Senior aux approvisionnements pour un·e client·e, une entreprise canadienne spécialisée dans la distribution à l'échelle nationale. L'Analyste Senior en Approvisionnement joue un rôle clé dans la performance de la chaîne...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. We are seeking a Strategic Procurement Manager, based out of our Montreal Headquarters to become part of Air...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. Reporting to the Senior Director Human Resources, the Manager, International Payroll is responsible for all...


  • Dorval, Quebec, H0S, Montréal, Canada Air Canada Full time

    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. This is an alignment of job title and function within the Network Strategy team. The Manager, Network...