Operations Excellence and Business Process Analyst

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 Operations Excellence and Business Process Analyst supports the Flight Operations Operational Excellence group in delivering data analytics, business intelligence, process excellence, finance analytics, strategy development and continuous improvement initiatives. The role builds and maintains the data models, dashboards and automated reporting that Flight Operations relies on, using tools such as SQL, Snowflake, Power BI and Python, and ensures that operational and regulatory data is accurate, consistent and well governed. The role also aligns process standards, integrates lean enterprise principles, and helps ensure Flight Operations processes are efficient, effective and compliant with company expectations, external regulations, standards and industry benchmarks. The position partners with management and subject-matter experts to develop quality controls, performance measures and sustainable process improvements.

Responsibilities:

• Gather and document business and system requirements, current-state and future-state process maps, and confirm that developed solutions meet identified requirements.
• Mine, reorganize and integrate data from primary and secondary sources into formats that are accessible to varied stakeholders.
• Write, optimize and maintain SQL queries, views and transformations in Snowflake to produce reliable, reusable datasets for reporting and analysis.
• Design, build and maintain Power BI reports, dashboards and semantic models (data modelling, DAX, Power Query, row-level security), and manage their publication, scheduled refreshes and access in the Power BI Service.
• Prepare executive-level reports that clearly communicate trends, patterns, forecasts and relevant operational insights.
• Use statistical and analytical tools (e.g., Python, R, Excel) to interpret data sets, with emphasis on trends and patterns supporting 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.
• Establish data-quality checks, validation rules and reconciliation controls so that operational and regulatory data (including submissions to Transport Canada) is accurate, complete and auditable, in line with company data governance, security and privacy standards.
• Define and document KPIs, metric definitions and data lineage to ensure consistent, trusted reporting across Flight Operations.
• Support the development and adoption of Microsoft Fabric for Flight Operations analytics, including building lakehouses, Dataflows Gen2 and data pipelines, and integrating Snowflake data into Fabric (e.g., mirroring or OneLake shortcuts) to power Power BI reporting
• Identify and support the responsible use of AI and advanced-analytics tools to enhance 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 status updates and minutes, and communicating key milestones.
• Conduct process failure mode and effects analyses, SWOT analyses, gap analyses and process risk assessments, as appropriate.
• Establish and maintain effective working relationships with management, subject-matter experts and cross-functional stakeholders.
• Perform other duties as assigned.

Qualifications

• University degree in engineering, computer science, statistics, mathematics or a related quantitative field.
• Minimum of two years of experience in data analytics, business intelligence or business process improvement.
• Advanced proficiency in SQL and Power BI (data modelling, DAX, Power Query); working knowledge of Snowflake or another cloud data platform; experience with or exposure to Microsoft Fabric (Lakehouse, Data Factory, notebooks); experience using Python (or R) for data analysis and automation.
• Familiarity with Microsoft Power Platform (Power Automate, Power Apps), SharePoint, Azure, Excel and VBA.
• Strong analytical, applied-logic and creative problem-solving skills, with a high level of attention to detail; experience with process-improvement or lean methods.
• Ability to assess the financial implications of operational decisions and develop cost-benefit analyses.
• Strong written and verbal communication, active listening, relationship-building and stakeholder-management skills, including the ability to explain technical findings to non-technical audiences.
• 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 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.