Analyst - Operational Excellence and Management Methods

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.

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

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