Analyst - Management Systems - Technical Services

AIR CANADA; Dorval; On-site; CAD 73,000 - 98,000; Full time

Benefits offered by this job

Pension plan

Employee share ownership plan

Profit-sharing plan

Health, dental, and life insurance for

Travel privileges

Job summary

Air Canada is seeking a data analyst to extract and analyze large datasets using Excel, SQL, and Power BI while designing reporting solutions for business leaders. You will own reporting processes, monitor KPIs, and partner with teams to improve processes and customer experience.

The role emphasizes data-driven decisions, timely reporting, and strong Excel skills including VBA and Pivot Tables, with a preference for candidates who can operate in a fast-paced, in-person Montreal setting.

Qualifications

• 3+ years as a business/data analyst or similar role.
• Experience with Excel including VBA, Pivot Tables, and Power Pivot.
• Experience with SQL language for data extraction.
• Experience in data visualization and deriving business insights.
• Bachelor's degree or equivalent in business, engineering, mathematics, or statistics.

Responsibilities

• Retrieve and analyze large datasets using Excel, SQL, and other data management systems.
• Design and implement reporting solutions to enable stakeholders to manage the business and make effective decisions.
• Own reporting communication processes to ensure accuracy and timely delivery with customer focus.
• Develop and manage KPIs to measure and control reporting processes and benchmark them.
• Monitor indicators and develop new ones; partner with internal teams for process and system improvements.
• Support cross-functional teams in daily execution of program implementation.
• Generate complex queries for in-depth process issue reviews.
• Innovate to improve the customer experience.

Skills

Excel advanced

Data analysis

Stakeholder influence

Education

Bachelor's degree in business, engineering, mathematics, or statistics

Tools

SQL

Power BI

Python

R

Power Pivot

Job description

Location: Montreal, QC, Canada (in-person)
Starting salary: $41.18 per hour
Branch: Air Canada Maintenance
Category: Unionized personnel (IAMAW)

Joining Air Canada is joining an iconic Canadian company. Are you passionate about reaching new heights, teamwork, and the opportunity to make a significant contribution? Launch your career by joining our diverse and dynamic team at the forefront of passenger air transport.

Important elements to know

• Vision drives maintenance excellence: Solid understanding of an airline's maintenance operations and ability to envision how this role supports the broader air transport landscape.
• Data-driven decisions: Advanced proficiency in Excel is essential – you must be able to extract and analyze complex datasets and make decisions based on them.
• Building connections fosters collaboration: Strong interpersonal skills to engage colleagues of different generations and collaborate effectively with them.

Main functions

• Retrieve and analyze large datasets using Excel, SQL, and other data management systems.
• Design and implement reporting solutions to enable stakeholders to manage the business and make effective decisions.
• Own reporting communication processes to ensure that each report is accurate and produced in a timely manner, with a high degree of customer orientation in resolving data discrepancies.
• Develop and manage key performance indicators to measure and control reporting processes and benchmark them.
• Monitor existing indicators and develop new ones, and partner with internal teams to identify opportunities for process and system improvement.
• Support cross-functional teams in the daily execution of existing program implementation.
• Generate complex queries for in-depth review of process issues.
• Innovate to improve the customer experience.

Qualifications

• At least three years of experience with Excel (including VBA, Pivot Tables, table functions, and Power Pivot) and data visualization tools such as Power BI;
• Experience in defining requirements and using data and metrics to derive business insights;
• Experience with SQL language for data extraction;
• Experience in formulating business recommendations and influencing stakeholders;
• Bachelor's degree or equivalent in business, engineering, mathematics, or statistics;
• At least three years of experience as a business analyst or data analyst, or in a similar role;
• Experience in operations, supply chain, or logistics;
• Understanding of data warehousing and modeling;
• Proficiency in a modeling language such as Python or R;
• Experience with one or more statistical modeling languages or toolkits;
• Demonstrate punctuality and reliability to foster overall team success in a fast-paced environment;

Benefits

• Financial benefits: Pension plan, Employee share ownership plan, Profit-sharing plan.
• Well-being and healthcare: Health, dental, and life insurance plans for you and your family (as needed).
• Recognition: Shine, Air Canada's recognition program, allows you to highlight exceptional efforts.
• Travel privileges: A generous travel facility program for you and other eligible persons once you have accumulated twenty-eight (28) weeks of service. The program notably offers space-available travel, discounts on hotel stays and car rentals, Air Canada Vacations discounts, and more.

Employment conditions

Candidates must be eligible to work in the country concerned at the time a job offer is presented and are responsible for obtaining work permits, visas, or other necessary authorizations. Proof of eligibility must be provided before the start date.

Language requirements

Equal skills being equal, 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 workplace that highlights the unique contribution of our employees to our business success.

As an equal opportunity employer, we encourage diverse applications so that we can have a workforce that is varied and representative of our customers and the communities where we live and offer our services.

Air Canada thanks all candidates for their interest, but only those selected for an interview will be contacted.