Senior Reporting Analyst (12-month contract)

Vacances Air Canada Vacations / Air Canada Rouge•Montreal, QC

3d•Hybrid

About The Position

The Senior Reporting Analyst supports leaders in making strategic business decisions grounded in facts, data, and metrics. This role owns the end-to-end delivery of value-added commercial and operational analysis, translating complex datasets into clear insights and actionable recommendations. The incumbent is also a subject matter expert in the organization’s reporting ecosystem and data assets, ensuring trusted metrics and fit-for-purpose reporting.

Requirements

Master’s degree (preferred) or Bachelor’s degree with equivalent experience in a quantitative field (e.g., mathematics, applied statistics, econometrics, computer science, operations research, business intelligence).
Minimum 4–6 years of experience in an advanced analytics, BI, or comparable data-driven role; travel/tour operator industry experience is an asset.
Advanced proficiency with SAP BusinessObjects / SAP Web Intelligence and/or Microsoft Power BI; dashboarding experience
Advanced Microsoft Excel capability for building models, managing data, and performing robust analysis; strong overall Microsoft Office proficiency.
Demonstrated ability to translate large, complex datasets into clear narratives for decision makers, including executive-level communication.
Bilingualism in English and French (oral and written) preferred.
Strong business acumen with the ability to connect analysis to commercial outcomes.
Excellent analytical, problem-solving, and troubleshooting skills; strong attention to detail and accuracy.
Critical thinking and sound judgment to validate outputs, challenge assumptions, and use pragmatic approaches when information is incomplete.
Ability to synthesize complex situations into simple, compelling messages and data stories.
High autonomy, initiative, and ability to manage multiple priorities in a dynamic, fast-paced environment.
Strong communication skills for presentations, written reporting, and executive-level discussions.
Team mindset and collaborative approach

Nice To Haves

travel/tour operator industry experience is an asset
Bilingualism in English and French (oral and written) preferred.

Responsibilities

Partner with Commercial and cross-functional leaders to frame key business questions, gather requirements, and define success metrics.
Deliver rigorous, decision-ready analysis to identify drivers of performance, emerging opportunities and threats; provide clear recommendations alongside findings.
Analyze, model, and monitor commercial and operational objectives against established criteria; develop diagnostics to explain variances and guide corrective actions.
Prepare detailed analysis and research to support commercial strategy (e.g., pricing actions, revenue opportunities, margin optimization, customer and operational performance).
Develop and standardize analytical templates, methodologies, and storytelling approaches to streamline decision support and improve consistency of insights.
Conceptualize and develop data visualization solutions that synthesize complex concepts for leadership and key stakeholders (e.g., dashboards, executive summaries) using SAP Web Intelligence and related tools.
Own and continuously improve the portfolio of periodic management information reporting (daily/weekly/monthly), including definitions, data lineage, validation checks, and release cadence.
Be a subject matter expert on core data sources and the data warehouse: understand relevant data fields, underlying queries, and reporting structures; troubleshoot data/reporting issues and manage change requests.
Identify gaps in available data and metrics; work with technical BI partners to evolve data capture, data models, and governance to meet new business requirements.
Promote adoption and effective use of reporting/analytics platforms through stakeholder training, enablement, and documentation.
Monitor BI and analytics best practices (data visualization, predictive/diagnostic techniques, automation) and recommend improvements that increase productivity and insight quality.