Analyst - Commercial Automation and Systems

AIR CANADA; Dorval; On-site; CAD 90,000 - 120,000; Full time

Job summary

Air Canada, a Canadian symbol, seeks a skilled analyst to join the AI Laboratories - Revenue Management team. You will analyze, develop and maintain automated and AI-based solutions for Revenue Management and Commercial Affairs, supporting PROS RMA and related systems.

You will gather requirements, monitor KPIs, prepare reports and participate in testing, training and implementation activities, contributing to forecasting, optimization and data modeling initiatives across the Revenue Management

Qualifications

• Master's degree in mathematics, statistics, computer science, economics, operations research, engineering or the equivalent.
• Three years of relevant experience in revenue management, analytics, automation, systems support, or a related field.
• Proven experience in a revenue management environment in an origin and destination context (PROS RMA or equivalent).
• Excellent design, analysis and problem-solving skills.
• Ability to synthesize analytical and business information, formulate solutions and recommendations, and present results clearly.
• Strong interpersonal and communication skills; ability to explain technical information and support tool adoption.
• Ability to translate business needs into documented technical requirements with stakeholders, suppliers and developers.
• Experience with Microsoft Excel and AI-powered tools; familiarity with large databases and data modeling.

Responsibilities

• Support automation and AI initiatives by gathering requirements, coordinating input data, and monitoring development activities.
• Define and monitor KPIs, reports and dashboards to evaluate revenue benefits, adoption, forecast accuracy and user workflows.
• Maintain understanding of Revenue Management tools and systems, including internal and third-party solutions.
• Identify automation opportunities and ensure development and maintenance of automated solutions.
• Perform analyses of business issues and develop options for review with the AI Laboratories team.
• Adjust priorities based on production issues in collaboration with the team.
• Participate in evaluating, testing and implementing new tools and system updates; prepare analyses and reports.
• Provide training to new and current Revenue Management team members on new features.

Skills

SQL

R language

Excel

PowerPoint

Data visualization

AI tools

Communication

Education

Master's degree in mathematics, statistics, computer science, economics, operations research, engineering or the equivalent

Tools

Microsoft Access

VBA

PowerPivot

R language

Job description

Belonging to Air Canada is about belonging to a Canadian symbol, Air Canada recently named Best Airline in North America. Let your career take flight by joining our innovative and diverse team at the forefront of passenger air transport.

This position, which is part of the AI and Commercial Automation Laboratory team - Revenue Management, aims to support the delivery, development and ongoing operation of automated and AI-based solutions intended for Revenue Management and Commercial Affairs professionals. The successful candidate performs analyses, develops assigned automation solutions, and participates in the monitoring, testing and maintenance of the Revenue Management System (PROS RMA), in accordance with operational requirements and established priorities.

Responsibilities:

• Commercial Automation
  • Contribute to the delivery of automation and AI initiatives by gathering requirements, coordinating input data, collaborating with internal and third-party partners, monitoring development and implementation activities, and escalating risks and issues as appropriate.
  • Contribute to the definition and monitoring of key performance indicators, reports and dashboards used to evaluate revenue benefits, adoption, forecast accuracy, user workflows and other relevant outcomes related to automation and AI solutions.
  • Maintain a solid understanding of the various tools and systems used within Revenue Management involving automation, whether developed internally or provided by third parties.
  • Help identify automation opportunities; ensure the development and maintenance of assigned automated solutions, in accordance with defined business requirements, technical standards and project priorities.
  • Perform detailed analyses of defined business issues, summarize findings and impacts, and develop options for review with the Specialist - Artificial Intelligence Laboratories - Revenue Management. Keep abreast of new developments in automation and AI, both in the industry (particularly in the airline sector) and in academia.
  • Adjust assigned priorities based on production issues or other major challenges, in collaboration with the Specialist - Artificial Intelligence Laboratories - Revenue Management.
  • Participate in the evaluation, testing and implementation of new tools and system modifications by performing assigned analyses, test cases and documentation. Prepare analyses, progress reports and supporting documents for relevant forums, and participate in meetings as needed.
  • Provide new and refresher training to new and current members of the Revenue Management team as new automation and AI updates and projects become available.
• Revenue Management System Support
  • Perform preliminary analysis and provide support when issues arise related to RMA systems, log findings and communicate relevant updates through established escalation channels.
  • Ensure the development and maintenance of automated tools, emails, dashboards and reports assigned to them that are used to facilitate the monitoring of RMA systems and processes. Acquire a solid understanding of how RMA systems work, including the various data sources and their relevance in the end-to-end process.
  • Create reports to monitor the daily overall status of RMA systems using several of our key performance indicators, including daily fares, bid prices, demand, availability, etc.
  • Monitor the quality of raw input and output data of forecasting, optimization and availability systems, identify anomalies and escalation findings through established channels.
  • Support the planning and validation of system upgrades, including conducting pre-implementation test cases and post-implementation health checks.
  • Collaborate with the PROS system, Revenue Management, and Application Development and Maintenance teams to facilitate effective system monitoring, and perform analysis or updates in relevant forums upon request.
  • Provide existing training materials and user guides to new and current members of the Revenue Management team as new features become available in our revenue management systems.

Qualifications

• Master's degree in mathematics, statistics, computer science, economics, operations research, engineering or the equivalent.
• Three years of relevant experience in revenue management, analytics, automation, systems support, or a related field. Proven experience in a revenue management environment in an origin and destination context (PROS RMA or equivalent).
• Excellent design, analysis and problem-solving skills
• Ability to synthesize analytical and business information, formulate solutions and recommendations, and present results in clear terms.
• Strong interpersonal and communication skills; ability to clearly explain technical or analytical information, collaborate with stakeholders, and support the adoption of new tools and processes. Ability to contribute to translating business needs into documented technical requirements in collaboration with business stakeholders, suppliers and developers.
• Ability to perform assigned tasks following general guidelines, promptly flag risks and recommend next steps within established processes. Demonstrate a clear sense of accountability when resolving problems, providing updates and determining next steps.
• Skills for using the Microsoft suite (Excel, PowerPoint, etc.) as well as AI-powered assistants and technologies.
• Advanced technology skills, particularly for working with large databases (expertise in coding and debugging SQL, Microsoft Access, VBA, PowerPivot and R languages is a definite asset) and transforming them into clear business insights.
• Advanced skills with Power Automate or equivalent tools, an important asset.
• Experience in creating agentic AI agents, an important asset.
• Experience in revenue management, forecasting, optimization and data modeling in industry or an academic environment, an asset.
• Demonstrate punctuality and reliability to support the team's overall success in a fast-paced environment.

Employment conditions:

Candidates must be eligible to work in the country concerned at the time a job offer is presented and are responsible for obtaining the necessary work permits, visas or other authorizations. Proof of eligibility must be provided before the start date.

Language Requirements

Equal skills being equal, 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 that showcases the unique contribution of our employees to the success of our business.

As an equal opportunity employer, we encourage diverse applications in order to build a workforce that is varied and representative of our customers and the communities where we live and offer our services.

Air Canada thanks all applicants for their interest, but only those selected for an interview will be contacted.