Route Profitability and Reporting Analyst

Air Canada; Dorval; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading airline in Canada is seeking a Route Profitability & Reporting Analyst in Dorval to manage financial performance systems. Responsibilities include validating data, producing executive reports, and developing dashboards for business insights. Ideal candidates will hold a degree in Finance or Accounting, possess strong analytical skills, and be proficient in MS Office and BI tools. The organization values diversity and encourages bilingual candidates to apply.

Benefits

Diversity and Inclusion initiatives

Support for professional development

Qualifications

• Complete proficiency with MS Office is required.
• Experience with BI tools, data visualizations, and data analysis.
• Ability to work under strict deadlines with limited supervision.

Responsibilities

• Produce monthly Flight Profitability reports.
• Load and validate incoming data.
• Develop dashboards and KPIs for end user reporting.

Skills

Strong analytical/problem solving skills

Strong organizational skills

Detail oriented

Interpersonal and communication skills

Education

Bachelor’s degree in Finance, Accounting, or Business

Tools

MS Office

BI tools

SAP

Job description

Overview

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

Reporting to the Partner, Route Profitability & Reporting, the Route Profitability & Reporting Analyst is responsible for maintaining the route financial performance (Flight Profitability) system. The individual will be responsible for the load and validation of incoming data, the validation of route results and for providing support and training to users. The individual will work with end users to develop dashboards and KPIs that are relevant to the business. This position is ideal for a person who is interested in understanding revenue and cost relations within the airline.

Responsibilities

• Responsible to produce on a monthly basis the Flight Profitability results:
  • Load data from source systems
  • Error checking, validation and troubleshooting of data
  • Validating revenue and cost allocations
  • Verify route results
• Work with other branches to maintain data feeds to Flight Profitability.
• Manage feeds to downstream applications, providing them with data contained in the Flight Profitability system.
• Produce monthly executive Flight Profitability reports.
• Provide Flight Profitability end user support and training.
• Lead continuous improvement activities; evaluating data sources/requirements, improving revenue and cost allocation rules, etc.
• Develop data visualizations, dashboards, KPIs for end user reporting
• Maintain Flight Profitability documentation.
• Lead discussions with the vendor for best practice reporting, cost allocation methodology and route profitability visualization.
• Collaborate with the Financial Evaluations group by:
  • Performing benchmarking studies with other carriers: labour productivity, unit costs and profitability analysis.
  • Conducting route profitability financial evaluations pertaining to new services, code share agreements, joint ventures and schedule changes.

Qualifications

• Bachelor’s degree or college diploma in a relevant field of study (Finance, Accounting, Business)
• Strong organizational skills, ability to shift priorities on an ad hoc basis and with a keen interest in Information Technology and Finance type work.
• Strong analytical/problem solving skills.
• Very detail oriented.
• Complete proficiency with MS Office is required.
• Experience with BI tools, data visualizations, data analysis.
• Knowledge of SAP is an asset.
• Strong interpersonal and communication skills both oral and written.
• Ability to work under strict deadlines with limited supervision, and to manage own time.
• Demonstrate punctuality and dependability to support overall team success in a fast-paced environment.

Conditions Of Employment

Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.

Linguistic Requirements

Based on equal qualifications, 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 which highlights employees’ unique contributions to our company’s success. As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.

Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.