Analyst - Operational Excellence and Management Methods

AIR CANADA; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

Air Canada seeks an Analyst to drive Operational Excellence by building data models, dashboards and automated reports for Flight Operations. You will harmonize processes, apply lean principles, and collaborate with experts to ensure compliant, reliable data and insightful decision support.

Responsibilities include data integration, SQL/Snowflake development, Power BI report creation, and aiding the adoption of Fabric-based analytics. Strong communication and problem-solving are essential.

Qualifications

• University degree in engineering, computer science, statistics, mathematics or related quantitative discipline.
• At least two years of experience in data analytics, BI or process improvement.
• Strong SQL and Power BI skills; working knowledge of Snowflake and Fabric; Python or R for data analysis.

Responsibilities

• Collect, document, and translate requirements for current and future state processes.
• Extract and integrate data from multiple sources for reports and dashboards.
• Design and maintain Power BI reports, dashboards, and semantic models.
• Prepare senior management reports with trends, forecasts and insights.
• Develop automated data pipelines and data quality controls.

Skills

SQL

Power BI

Python

Data modeling

Communication

Lean methodology

Education

University degree in engineering, computer science, statistics, mathematics or related quantitative discipline

Tools

Snowflake

Microsoft Fabric

Azure

Excel/VBA

Job description

Belonging to Air Canada is to belong to a Canadian symbol, Air Canada recently voted best airline in North America. Take your career off by joining our innovative and diverse team at the forefront of passenger air transport.

The Analyst – Operational Excellence and Management Methods supports the Flight Operations Operational Excellence team in the implementation of initiatives related to data analytics, business intelligence, process excellence, financial analysis, strategy development and continuous improvement. The incumbent creates and maintains data models, dashboards and automated reports relied upon by Flight Operations, using tools such as SQL, Snowflake, Power BI and Python, and ensures that operational and regulatory data are accurate, consistent and well-managed. This role also involves harmonizing process standards, integrating lean management principles and helping ensure that Flight Operations processes are effective, efficient and compliant with company expectations, external regulations, standards and industry benchmarks. The incumbent collaborates with management and subject matter experts to establish quality controls and performance indicators, and to deliver sustainable process improvements.

Responsibilities :

• Collect and document operational and technical requirements, current and future state process schemas, and ensure that developed solutions meet defined requirements.
• Extract, reorganize and integrate data from primary and secondary sources into formats accessible to various stakeholders.
• Write, optimize and maintain SQL queries, as well as views and transformations in Snowflake to produce reliable and reusable datasets for reporting and analysis purposes.
• Design, build and maintain Power BI reports, dashboards and semantic models (data modeling, DAX, Power Query, row-level security), and manage their publication, scheduled updates and access in the Power BI service.
• Prepare reports for senior management that clearly present relevant trends, patterns, forecasts and operational insights.
• Use statistical and analytical tools (e.g., Python, R, Excel) to interpret datasets, focusing on trends and patterns underlying diagnostic and predictive analysis.
• Develop and maintain automated data pipelines and reporting workflows using Python, Power Automate and related tools to improve data integration, reporting efficiency and analytical capabilities.
• Implement data quality controls, validation rules and reconciliation controls so that operational and regulatory data (including submissions to Transport Canada) are accurate, complete and verifiable, in accordance with company standards for data governance, security and privacy.
• Define and document key performance indicators, measure development and data traceability to ensure reporting consistency and reliability across Flight Operations.
• Support the development and adoption of Microsoft Fabric to contribute to Flight Operations analytics work, including the establishment of data lakes, Dataflows Gen2 and data pipelines, as well as the integration of Snowflake data into Fabric (e.g., mirroring or OneLake shortcuts) to power Power BI reports.
• Define and promote the responsible use of AI and advanced analytics tools to improve data analysis, forecasting, reporting and operational decision-making.
• Contribute to project planning and change management activities, including organizing and leading meetings, tracking issues and approvals, preparing progress reports and minutes, and communicating key milestones.
• Perform Failure Mode and Effects Analysis (FMEA), SWOT analysis and gap analysis, as well as process risk assessments, where appropriate.
• Establish and maintain effective working relationships with management, subject matter experts and stakeholders across various domains.
• Perform other assigned duties.

Qualifications

• University degree in engineering, computer science, statistics, mathematics or a related quantitative discipline.
• At least two years of experience in data analytics, business intelligence or business process improvement.
• Advanced proficiency in SQL and Power BI (data modeling, DAX, Power Query); working knowledge of Snowflake or another cloud data platform; experience or knowledge of Microsoft Fabric (Lakehouse, Data Factory, Notebooks); experience using Python (or R) for data analysis and automation.
• Good knowledge of Microsoft Power Platform (Power Automate, Power Apps), SharePoint, Azure, Excel and VBA.
• Strong analytical, applied logic and creative problem-solving skills, coupled with great attention to detail; experience in process improvement or lean methods.
• Ability to assess the financial consequences of operational decisions and conduct cost-benefit analyses.
• Excellent written and verbal communication skills, active listening, relationship building and stakeholder management, including the ability to explain technical findings to a non-technical audience.
• Assets: understanding of airline operations or another regulated industry; knowledge of statistical or forecasting methods; Lean/Six Sigma certification; Microsoft PL-300 (Power BI Data Analyst) or SnowPro Core certification.

Conditions of employment :

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

Linguistic Requirements

All things 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 serve.

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