In-flight Service Business Intelligence Analyst

1 month ago

Dorval, 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, IFS Business Intelligence, this role focuses on fostering a data-driven culture, aligning data priorities with the In-Flight Service (IFS) branch strategies, and enhancing data collection for analytics. Responsibilities include data preprocessing, proposing solutions, guiding report development, maintaining data quality, and automating processes.

This role also involves designing and maintaining tools like Power Apps, identifying automation opportunities, adhering to data governance, and promoting innovation. The role supports decision-making by ensuring accurate data availability and contributes to team skill development.

**Responsibilities**:

- Responsible for providing technical guidance and hands-on support in creating reports, dashboards, and self-service solutions to various departments, including Onboard Experience, Cabin Services, Catering Operations and IFS Operations Excellence.
- Understand and translate stakeholder requirements into actionable tools, ensuring alignment with business objectives.
- Provide value-added analytical support across the branch by conducting various analyses on IFS metrics.
- Assist the Manager, IFS Business Intelligence in ensuring dashboard design is standard, current and applied across all functions.
- Enhance and automate data collection procedures to ensure comprehensive and efficient gathering of all relevant information for developing analytical systems.
- Propose and implement technological solutions and strategies to tackle business challenges.
- Process, clean, and validate the integrity of data to be used for analysis.
- Participate and assist the Manager, IFS Business Intelligence in the elaboration of a long-term data platform architecture.
- Work closely with IT data collection teams to provide the necessary data to IFS key stakeholders.
- Provide technical guidance on tools for managers and cabin crew, ensuring their maintenance (e.g., Power App solutions).
- Identify, develop and coordinate the deployment of process automation technology solutions for the entire department (such as Power Automate solutions).
- Streamline and centralize the validation process and trend analysis of Onboard Report (OBR) data to ensure accuracy and efficiency. Provide dashboard trends to the Cabin Experience team, Cabin Services, and Catering for follow-up, along with a summary report in the branch QBR
- Promote a data-driven culture in the organization, aligning the data and BI priorities with IFS strategies.
- Adhere to and promote enterprise data governance policies and practices. Keep the stakeholders informed about the data quality evolution over time.
- Automate the detection and identification of business deviations from forecasts.
- Expand knowledge of new/different industry best practices while incorporating innovative thinking in all areas of work.
- Provide support to the Manager, IFS Business Intelligence and Manager, IFS Planning & Performance as required.

**Qualifications**
- Bachelor's degree in computer science, statistics, mathematics, or a related field.
- Minimum of 3+ years of experience in a similar role.
- Proficiency in data warehousing, ETL processes, and BI tools (Power BI).
- Experience with the MS Power Platform (Power BI Services, Power Apps, Power Automate).
- Power BI certification is considered a strong asset.
- Strong skills in SQL and data modeling.
- Knowledge of programming languages (SQL, Python, R, M, DAX).
- Experience with cloud databases (e.g., Snowflake) and data transformation tools (e.g., Azure Data Factory).
- Advanced Excel skills, including macros and pivot tables.
- Exceptional analytical and problem-solving abilities with expertise in mathematics and statistics (e.g., predictive modeling, machine learning).
- Ability to correlate data to business objectives and identify improvement opportunities.
- Effective communication skills, with the ability to simplify complex concepts.
- Flight Attendant qualification is considered a strong asset.
- Willingness to travel as required.

**Indoctrination Training (mandatory)**
- Job orientation
- CARs (Canadian Aviation Regulations)
- Safety Management System
- Flight Attendant Training
- Initial Service Director Training (an asset)
- Violence & Harassment for Management
- Canada Labour Code Part II
- Policy on Alcohol and Drugs

**Conditions of Employment**:
**Linguistic Requirements**

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

  • In-Flight Service Business Intelligence Analyst

    3 weeks ago

    Dorval, Canada Air Canada Full time

    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, IFS Business Intelligence, this role focuses on fostering a data-driven culture, aligning data...

  • In-Flight Service Business Intelligence Analyst

    3 weeks ago

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

    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, IFS Business Intelligence, this role focuses on fostering a data-driven culture, aligning data...

  • Analyst, Cargo Artificial Intelligence

    7 months ago

    Dorval, 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 has become over the last years a more and more data driven organization and we are...

  • Data & Business Intelligence Analyst

    2 months ago

    Dorval, Canada Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies._ **Why join us?**: At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it...

  • Flight Experience Specialist

    6 months ago

    Dorval, Canada Skyservice Business Aviation Full time

    **SKYSERVICE BUSINESS AVIATION** Skyservice is a North American leader in business aviation. Built on the key principles of safety and service excellence, we provide a full service experience from Aircraft Management, Aircraft Charter, Maintenance and Aircraft sales from our Fixed Base Operations that span Canada and the western United States. People and...

  • Analyst, Data

    2 weeks ago

    Dorval, Canada Bombardier Full time

    _When applicable, Bombardier promotes flexible and hybrid work policies._ **Why join us?**: At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it...

  • Analyst, Data

    3 months ago

    Dorval, Canada Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies._ **Why join us?**: At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it...

  • Analyst, Data

    3 months ago

    Dorval, Canada Bombardier Full time

    When applicable, Bombardier promotes flexible and hybrid work policies._ **Why join us?**: At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it...

  • Supervisor, In-flight Service

    2 months ago

    Dorval, Canada Air Transat Full time

    **Company Description** Be part of the Journey!** Our mission is to be the preferred airline of our customers and our team. Open-mindedness, concern for others, intelligence at work and, above all, a healthy dose of fun enable us to achieve great things every day, such as becoming the first international tour operator to obtain Travelife certification for...

  • Supervisor, In-flight Service

    7 months ago

    Dorval, Canada Air Transat Full time

    **Company Description** Be part of the Journey!** Our mission is to be the preferred airline of our customers and our team. Open-mindedness, concern for others, intelligence at work and, above all, a healthy dose of fun enable us to achieve great things every day, such as becoming the first international tour operator to obtain Travelife certification for...

  • In-Flight Data Intelligence Specialist

    3 weeks ago

    Dorval, Quebec, Canada Air Canada Full time

    About Air CanadaAir Canada is an iconic Canadian symbol and one of the leading airlines in North America. With a diverse and vibrant team, we are committed to providing exceptional service to our customers.Job OverviewWe are seeking a highly skilled In-Flight Data Intelligence Specialist to join our team. This role is a key part of our efforts to create a...

  • Retail Business Intelligence Analyst

    7 months ago

    Dorval, Canada Aer Rianta International Full time

    _English will follow_ Aer Rianta International Inc. (North America) est l'un des principaux exploitants de boutiques hors taxes dans les aéroports internationaux. Nous recherchons un(e) analyste de l’intelligence d'affaires afin de soutenir notre développement futur. **Objectif du poste**: Relevant du chef des finances, l'analyste suivra et surveillera...

  • Retail Business Intelligence Analyst

    7 months ago

    Dorval, Canada Aer Rianta International Full time

    **Analyste en intelligence d'affaires commerce de détail / Retail Business Intelligence Analyst** Aer Rianta International Inc. est l'un des principaux exploitants de boutiques hors taxes dans les aéroports internationaux. Nous recherchons un(e) analyste de l’intelligence d'affaires pour soutenir notre développement futur. **Objectif du...

  • Flight Revenue Analyst

    6 months ago

    Dorval, 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 has an ideal opportunity for a dynamic individual who wants to make a difference and who is...

  • Manager, Customer

    6 months ago

    Dorval, 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, Customer & Loyalty Business Intelligence participates in all stages of the BI process from...

  • Manager, In-flight Service Operations

    7 months ago

    Dorval, 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.** Responsible for managing the Montreal (YUL ) operations as a whole in the interest of In-Flight...

  • Business Intelligence Analyst

    2 weeks ago

    Dorval, Canada Bombardier Full time

    _When applicable, Bombardier promotes flexible and hybrid work policies._ **Why join us?**: At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it...

  • Supervisor, In-Flight Service

    1 month ago

    Dorval, Canada Air Transat Full time

    Job DescriptionReporting to the Base Manager, the In-Flight Service Supervisor has an everyday crucial role towards the success of the cabin crew members. The In-Flight Service Supervisor is responsible for motivating, informing and coaching all crew members on a daily basis. They contribute to the promotion of a professional, motivating and pleasant work...

  • Analyst , Cargo Ai Transformation

    2 months ago

    Dorval, 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...

  • Dispatch & Flight Coordinator

    7 months ago

    Dorval, Canada IMP Group Full time

    **Dispatch & flight Coordinator***: It’s an exciting time at Innotech-Execaire Aviation Group. For more than 50 years, we have provided a full range of services for business and commercial aviation customers. IEAG is also a leading provider of aviation and technical support solutions with its full-service aircraft sales, management & charter group,...