Business Analyst - Temporary

The Business Analyst, Crew Resources is primarily to support the Manager, Crew Analysis in the research, development and implementation of modelling, forecasting and monitoring tools for the Crew Resources departments – Crew Planning, Crew Administration, in addition to supporting Crew Scheduling. The position includes data mining, statistical modelling, forecasting and reporting for various pilot and flight attendant operational and financial measures. The position also will support branch and cross-functional projects that require reporting and analysis functions. This accountability is also extended to support crew data analysis and reporting for Air Canada rouge.

Key Function & Accountabilities:

Scope:

Responsible to provide analysis, forecasting, and reporting services for Pilot and Flight Attendant Operational and Financial data

Key Accountabilities:

• Convey complex information using a variety of formats in a way that is easy to understand.
• Develop, implement, and maintain statistical models for optimum planning of pilot and flight attendant operations and improvement of current processes.
• Provide statistical and analytical expertise in support of Pilot and Flight Attendant manpower requirements, including short-term and long-term plans.
• Responsible to design and program queries for extracting information and metrics from data stored in a variety database sources.
• Analyze data, identify trends, produce statistical reports to increase operational efficiencies.
• Monitor, investigate, correct, and prevent data quality problems.
• Use available benchmarking data to review current processes and provide recommendations for improvements.
• Provide analysis, forecasting, and reporting services for Pilot and Flight Attendant Operational and Financial data
• Measure and report on compliance to regulatory and contractual agreement standards
• Provide knowledge transfer of technical skills, report generation, software programming, data management, and analysis procedures.
• Provide supporting data and analysis for business case development for various Crew Resources projects
• Serve as an internal statistical sciences resource.

Qualifications

• Creative problem solver who thinks strategically, is results oriented and attentive to details.
• Bilingualism in English and French, an asset.
• University degree in engineering or related quantitative field
• Proficiency in programming and/or knowledge in: Teradata, Azure, SQL, R, MS Power BI, WebFocus, MS Excel, VBA, MS Sharepoint, Hyperion Essbase, Crystal Reports
• Ability to understand financial implication of operational decisions and develop cost-benefit studies.
• Sound experience with mathematics / statistical analysis and modeling.
• Strong analytical and applied logic skills.
• Ideal candidate must be self-motivated, have the ability to multi-task, and work effectively in an unstructured environment.
• Understanding of airline operations preferred

Please refer to the Air Canada Careers page for full job details.