Current jobs related to Commercial Data Developer - Dorval Quebec HS, Montréal - Air Canada

  • Senior Analyst Data

    7 days 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. We are seeking a highly skilled Senior Analyst Data & Analytics (Data Developer) to join our dynamic team....


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


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

    Description Location: Montreal, QC, Canada (Onsite) Starting Salary: $23.14/hour Branch: Maintenance Category: Unionized (IAMAW) 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...


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

    Description Location: Montreal, QC, Canada (Onsite) Starting Salary: $23.14/hour Branch: Maintenance Category: Unionized (IAMAW) Being part of Air Canada is to become part of an iconic Canadian symbol. Are you passionate about reaching new heights, teamwork and making a meaningful contribution? Let your career take flight by joining our...


  • 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. 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. Drive financial evaluations of new and existing airline relationships to maximize revenues associated with 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. Air Canada Cargo is seeking a Manager, Cargo Science and Innovation to help drive our data-driven...


  • 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 Manager, Cabin Interior and Maintenance Programs, this position will manage the Cabin...


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

  • 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. Reporting to the Senior Director Human Resources, the Manager Human Resources will act as a business partner to...


  • 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. Reporting to the Director, Network Optimization, this position will lead the branch to build the medium 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. 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...


  • 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, recognized as one of Canada's top diversity employers and one of Montreal's top...


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

    Description B eing 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, Operations Digital Solutions supports the vision of the digital transformation strategy and...

Commercial Data Developer

2 months 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.

Reporting to the Senior Manager, Commercial Data, the Commercial Data Developer is responsible for supporting Revenue Management, Sales, Network Planning and Alliance data teams by preparing data assets for reporting consumption. The individual will create/modify and monitor automated ETL scripts which merge/aggregate and prepare commercial data for downstream reporting and analysis.

Responsibilities:
  • Develop SQL and scripts to merge and aggregate data for the purpose of reporting or to feed commercial applications.
  • Develop SQL views of Commercial data assets for use by Commercial BI teams.
  • Monitor automated jobs to ensure data is available and accurate.
  • Extract and/or load data from AC or 3rd party systems if required.
  • Prepare and assist in prototyping new data assets for BI consumption.
  • Monitor data exchange between AC systems and 3rd party if required
  • Responsible for documenting back end ETL scripts and usage which are created/supported by the commercial data team.
Qualifications
  • University degree in related field (Mathematics, Statistics, BI, Operations Research, Computer science) or 5 years of pertinent experience in a similar position
  • Excellent knowledge of SQL programming is a pre-requisite
  • Knowledge of Snowflake is a pre-requisite
  • Knowledge of Linux shell programming is a pre-requisite
  • Experience working with large data set is a strong asset
  • Knowledge of travel industry data is a strong asset
  • Ability to understand and relate required analysis to business implications
  • Proven organizational skills and ability to multi-task.
  • Self-starter with strong interpersonal skills and ability to take initiative.
  • Experience with MS Office applications (Excel and Powerpoint) is a requirement.
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.