Senior Analyst, Strategy Modelling

WestJet Group; Calgary; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

WestJet Group is seeking a Senior Analyst, Strategy Modelling within the Transformation organization. The role builds forecasting, scenario modelling, and analytical capabilities to evaluate business decisions, market changes and transformation initiatives.

You will convert complex data into credible forecasts, business-case simulations and executive-ready recommendations. Reporting to Transformation Strategy & Intelligence, you will own modelling methodologies, data quality controls and

Qualifications

• Bachelor’s degree in Business, Finance, Economics, Computer Science, IT, Data Science or related field.
• Progressive experience in strategy, financial analysis, data analytics or forecasting.
• Experience developing forecasting models, scenarios, financial models or business cases.
• Advanced SQL skills for data extraction and validation.
• Advanced Excel skills for flexible models and executive outputs.
• Power BI or similar BI tools for data visualization.

Responsibilities

• Develop and maintain enterprise forecasting models for strategic planning and executive decision-making.
• Build scenario models and business-case simulations for transformation initiatives and investments.
• Integrate data from multiple sources and ensure data availability and quality.
• Maintain analytical logic, forecasting assumptions and reporting tools.
• Provide executive-ready analyses and recommendations to senior leaders.
• Identify data-quality gaps and opportunities to improve processes and models.

Skills

Strategic mindset

Analytical thinking

Executive communication

Data integrity

Forecasting

Problem solving

Cross-functional collaboration

Attention to detail

Continuous improvement

Education

Bachelor’s degree in related field

Master’s degree or MBA is an asset

Tools

SQL

Excel

Power BI

Python

Oracle EPM

Job description

Overview of role:

The Transformation organization sits at the core of the WestJet Group and is accountable for translating enterprise strategy into delivered, measurable outcomes. The team supports executive decision-making by connecting strategic priorities, operational performance, financial impacts and transformation investments through rigorous analysis and enterprise modelling.

The Senior Analyst, Strategy Modelling builds and maintains the forecasting, scenario modelling and analytical capabilities used to evaluate business decisions, market changes and transformation initiatives. The role combines strategic and executive decision support with the data management, system development, quality assurance and reporting capabilities required to make those insights reliable, scalable and repeatable.

Reporting within Transformation Strategy & Intelligence, this role works closely with Finance, Technology and business leaders to convert complex operational and financial data into credible forecasts, business-case simulations and executive-ready recommendations. The role also owns the underlying modelling methodologies, data quality controls and analytical tools that support effective enterprise decision-making.

Key Responsibilities

• Develop and maintain enterprise forecasting models that quantify future demand, operational performance, financial impacts and business outcomes to support strategic planning and executive decision-making.

• Build scenario models and business-case simulations that evaluate transformation initiatives, emerging opportunities, strategic risks and investment decisions across the organization.

• Obtain, process and integrate operational, financial and market data from multiple source systems, working with Technology and data owners to ensure required information is available, captured and appropriately structured.

• Maintain and enhance analytical logic, allocation methodologies, forecasting assumptions and associated outputs, including scheduled and ad hoc reporting, dashboards and decision-support tools.

• Produce executive-ready analyses, forecasts and recommendations for Directors, Vice Presidents and Executive Leadership, translating complex analytical outputs into concise insights, strategic implications and recommended actions.

• Conduct detailed analysis of existing systems, models and business processes to identify abnormalities, data-quality concerns, control gaps and opportunities for improvement.

• Perform rigorous quality assurance, validation and reconciliation to ensure the accuracy and integrity of data, analytical models and information used for executive and enterprise decision-making.

• Monitor industry trends, competitor performance and market dynamics to identify emerging opportunities, risks and implications for WestJet’s business plans and transformation agenda.

• Partner with Finance, Technology and business teams to design, implement and deploy new analytical capabilities and enhancements to existing models, systems and reporting solutions.

• Own enterprise modelling methodologies, forecasting standards and analytical tools, continuously improving model accuracy, scalability, usability and decision-making effectiveness.

• Translate ambiguous strategic and operational questions into structured analytical approaches, clearly articulating assumptions, sensitivities, constraints and trade-offs.

• Create and maintain detailed documentation, including model specifications, business rules, data definitions, workflow diagrams, user guides and operating procedures.

• Support enterprise planning, investment prioritization and transformation governance by providing objective analysis of potential value, cost, risk, timing and organizational impact.

Competencies & Attributes

• Strategic and analytical mindset, with the ability to connect operational, financial and market inputs into credible forecasts and defensible recommendations.

• Advanced quantitative problem-solving skills and the ability to develop structured analytical approaches for complex or ambiguous business questions.

• Strong financial and commercial acumen, including an understanding of value drivers, business cases, investment trade-offs and financial performance.

• Exceptional attention to detail and a strong commitment to data integrity, quality assurance and analytical rigour.

• Ability to communicate complex methodologies, assumptions and findings in clear business language for executive and non-technical audiences.

• Strong executive writing and data-visualization skills, with the ability to produce concise, compelling and decision-oriented materials.

• Intellectual curiosity and a willingness to challenge assumptions, investigate anomalies and identify alternative explanations or scenarios.

• Collaborative and team-oriented, with the ability to work effectively across Transformation, Finance, Technology and operational functions.

• Self-directed and comfortable managing multiple priorities, analytical workstreams and stakeholder expectations in a dynamic environment.

• Highly trusted and discreet, with the judgement required to handle sensitive financial, strategic and operational information.

• Continuous-improvement mindset, with a focus on making analytical tools, models and processes more accurate, scalable and effective.

Professional Experience & Qualifications

• Bachelor’s degree in Business, Commerce, Finance, Economics, Computer Science, Information Technology, Data Science, Mathematics, Engineering or a related field required.

• Progressive experience in strategy, financial analysis, data analytics, business intelligence, forecasting, financial modelling or a related analytical discipline.

• Demonstrated experience developing forecasting models, strategic scenarios, financial models, business cases or quantitative decision-support tools.

• Advanced SQL skills, including experience obtaining, transforming, validating and analyzing data from complex relational datasets.

• Advanced Microsoft Excel skills, including experience building flexible models, scenario analyses, sensitivity analyses and executive-ready outputs.

• Experience performing data validation, reconciliation and quality assurance across analytical models, reporting solutions or enterprise datasets.

• Experience translating business requirements into analytical, reporting or system solutions in partnership with business and Technology teams.

• Proven ability to synthesize complex analysis into clear recommendations for senior leaders and executive decision-makers.

• Experience creating and maintaining model documentation, system specifications, process maps, workflow diagrams or user guides.

• Power BI or comparable business-intelligence and data-visualization experience preferred.

• Python or comparable analytical programming experience preferred.

• Experience with Oracle EPM, Microsoft Access or comparable enterprise planning, modelling or database platforms considered an asset.

• Financial Modelling, Data Science or Analytics certification considered an asset.

• Master’s degree or MBA considered an asset.

• Aviation, transportation or another complex operating-environment experience preferred.