JOB TITLE: Senior Reporting Analyst
POSITION STATUS: Temporary – Full Time
DEPARTMENT: Commercial Planning
LOCATION: Montreal
WHO WE ARE
At Air Canada Vacations, we’re in the business of making dreams travel. That’s why we offer vacation packages, tours, cruises and more tailored to everyone’s individual needs. We like to say we have a vacation for every traveler because we do!
If you're someone who's passionate about exploring the world and sharing that enthusiasm with our customers, we'd love to welcome you to our team.
For over 50 years, Air Canada Vacations has been making travel easy, so come and join us in helping fellow Canadians create unforgettable memories wherever they go.
WHAT YOU'LL BE DOING
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:
- 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.
KNOWLEDGE AND SKILLS REQUIRED:
- 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
WHY WORK WITH US?
- Our team loves to travel, and we have one of the most generous employee travel programs in the industry. You’ll be eligible for travel privileges for yourself and other eligible persons once you’ve completed 6 months of service
- Hybrid work model : Corporate Mandate of 4 days in office (Tuesday, Wednesday, Thursday + 4th day of your choice) and 1 day from home
- We value your wellbeing and offer a wide variety of benefit plans, including health and dental, for you and your family
- We offer training and development tools to help unlock your full potential
Please note that these benefits apply to permanent, full-time employees.
Visit our Careers page for a full list of benefits.
OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION
Air Canada Vacations is committed to ensuring a Diverse, Equitable, and Inclusive Workplace, fundamental to its core values. We celebrate the uniqueness of every individual, listen to every voice, and instill a sense of belonging in our people that allows each team member’s authentic self to truly shine.
We encourage individuals of all backgrounds to apply as we strive to create a diverse team that mirrors the diversity of the customers and communities we serve as an equal opportunity employer. Should you require any accommodation, please inform us and we will work with you to meet your accessibility needs. For any accessibility-related assistance, requests for information in accessible alternative formats or to report any accessibility problems, please share in your application.
Linguistic Requirements
When qualifications are equal, preference will be given to bilingual candidates. The position involves daily interactions with partners, clients, and colleagues located outside of Quebec.
