Business Analyst - Technical Services

Air Canada; Dorval; On-site; CAD 85,000 - 95,000; Full time

Benefits offered by this job

Pension program

Employee Share Ownership Program

Profit Sharing

Health, dental, and life insurance

Job summary

Air Canada, based in Montreal, QC, is seeking a Data Analyst to drive data-informed decisions in maintenance operations. You will analyze large data sets with Excel, SQL, and Power BI, design reporting solutions, and own KPI tracking to improve service and efficiency.

You will work with cross-functional teams, develop insights from data warehousing concepts, and communicate recommendations to stakeholders in a fast-paced, on-site environment.

Qualifications

• 3+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Power BI experience.
• Experience defining requirements and using data and metrics to draw business insights.
• Experience with SQL for data extraction.
• Experience making business recommendations and influencing stakeholders.
• Bachelor's degree or equivalent in Business, Engineering, Mathematics or Statistics.
• 3+ years of business analyst, data analyst or similar role experience.
• Experience in Operations, Supply Chain, or Logistics.
• Understanding data warehousing and data modeling.
• Fluency in a modeling language such as Python or R.
• Experience with one or more statistical modeling languages/toolboxes.
• Demonstrate punctuality and dependability to support overall team success in a fast-paced environment.

Responsibilities

• Retrieving and analyzing large sets of data using Excel, SQL, and other data management systems.
• Designing and implementing reporting solutions to enable stakeholders to manage the business and make effective decisions.
• Taking ownership of reporting processes to ensure that each report is accurate and timely with a high degree of customer focus in resolving data discrepancies.
• Building and managing related KPIs to measure, control, and benchmark reporting processes.
• Monitoring existent metrics, building new metrics, and partnering with internal teams to identify process and system improvement opportunities.
• Supporting cross-functional teams on the day-to-day execution of the existent program implementation.
• Generating complex queries to dive deep on process issues.
• Innovating to improve customer experience.

Skills

Excel mastery

Data analysis

Business insights

Python/R modeling

Education

Bachelor's degree in Business/Engineering/Math/Statistics

Tools

SQL

Power BI

VBA

Python

R

Job description

Location: Montreal, QC, Canada (onsite)

Starting Salary: $41.18/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 diverse and vibrant team at the leading edge of passenger aviation.

It’s important to know that

• Vision fuels maintenance excellence: Solid understanding of airline maintenance operations and the ability to envision how this role supports the broader aviation landscape.
• Data driven decisions: Advanced Excel proficiency is essential—must be skilled in mining, analyzing, and driving decisions from complex data sets.
• Connection builds collaboration: Strong interpersonal abilities to engage and collaborate effectively with colleagues across multiple generations.

Key duties

• Retrieving and analyzing large sets of data using Excel, SQL, and other data management systems.
• Designing and implementing reporting solutions to enable stakeholders to manage the business and make effective decisions.
• Taking ownership of reporting processes to ensure that each report is accurate and timely with a high degree of customer focus in resolving data discrepancies.
• Building and managing related key performance indicators (KPIs) to measure, control, and benchmark reporting processes.
• Monitoring existent metrics, building new metrics, and partnering with internal teams to identify process and system improvement opportunities.
• Supporting cross-functional teams on the day-to-day execution of the existent program implementation.
• Generating complex queries to dive deep on process issues.
• Innovating to improve customer experience.

Qualifications

• 3+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Power BI experience;
• Experience defining requirements and using data and metrics to draw business insights;
• Experience with SQL for data extraction;
• Experience making business recommendations and influencing stakeholders;
• Bachelor's degree or equivalent in Business, Engineering, Mathematics or Statistics;
• 3+ years of business analyst, data analyst or similar role experience;
• Experience in Operations, Supply Chain, or Logistics;
• Understanding data warehousing and data modeling;
• Fluency in a modeling language such as Python or R;
• Experience with one or more statistical modeling languages/toolboxes;
• Demonstrate punctuality and dependability to support overall team success in a fast-paced environment;

Benefits

• Financial benefits: Pension program, Employee Share Ownership Program, and Profit Sharing.
• Wellbeing & health benefits: Health, dental, and life insurance for you and your family (if necessary).
• Recognition: Air Canada’s recognition program (Shine) allows you to recognize and be recognized for those outstanding moments.
• Travel privileges: A generous employee travel program for you and other eligible once you have completed twenty-eight (28) weeks of service. This includes, but is not limited to standby travel, hotel & car rental discounts, Air Canada Vacation discounts, and more.

Conditions of Employment

Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.

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.