Operations Excellence and Business Process Analyst

Role overview

Responsibilities

• Gather and document business and system requirements and current- and future-state process maps; verify developed solutions meet requirements.
• Mine, reorganize, and integrate data from primary and secondary sources into accessible formats for stakeholders.
• Write, optimize, and maintain SQL queries, views, and Snowflake transformations for reliable, reusable datasets.
• Build and maintain Power BI reports, dashboards, and semantic models using data modeling, DAX, Power Query, and row-level security; manage publication, refreshes, and access.
• Prepare executive reports that communicate trends, patterns, forecasts, and operational insights.
• Use Python, R, Excel, and other analytical tools for trend, diagnostic, and predictive analysis.
• Develop automated data pipelines and reporting workflows using Python, Power Automate, and related tools.
• Create data-quality checks, validation rules, and reconciliation controls for accurate, complete, auditable operational and regulatory data, including Transport Canada submissions.
• Document KPIs, metric definitions, and data lineage for consistent reporting across Flight Operations.
• Support Microsoft Fabric adoption, including lakehouses, Dataflows Gen2, pipelines, and Snowflake integration for Power BI reporting.
• Support responsible AI and advanced analytics use for forecasting, reporting, and operational decisions.
• Support project planning and change management, including meetings, issue and approval tracking, status updates, minutes, and milestone communications.

Qualifications

• University degree in engineering, computer science, statistics, mathematics, or a related quantitative field.
• At least two years of experience in data analytics, business intelligence, or business process improvement.
• Advanced SQL and Power BI proficiency, including data modeling, DAX, and Power Query.
• Working knowledge of Snowflake or another cloud data platform; experience with or exposure to Microsoft Fabric, including Lakehouse, Data Factory, or notebooks.
• Experience using Python or R for data analysis and automation.
• Familiarity with Microsoft Power Platform, SharePoint, Azure, Excel, and VBA.
• Strong analytical, applied-logic, and creative problem-solving skills; attention to detail; and process-improvement or lean-method experience.
• Ability to assess financial implications of operational decisions and develop cost-benefit analyses.
• Strong communication, listening, relationship-building, and stakeholder-management skills, including explaining technical findings to non-technical audiences.
• Assets include airline or regulated-industry knowledge, statistical or forecasting methods, Lean Six Sigma certification, Microsoft PL-300, or SnowPro Core certification.

Additional role expectations

Employment conditions