Data Analyst - Research and Development

Air Canada; Montreal (administrative region); On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading Canadian airline is seeking a Data Analyst R&D to optimize its Aeroplan loyalty program. This role involves developing data models, visualizing data, and improving pricing strategies for over $1B in redemption expenses. Candidates should have a strong background in SQL and Python, experience with data visualization tools, and a passion for analytics. The ideal candidate can communicate complex findings simply and contribute to maximizing profitability through data-driven insights.

Benefits

Diversity and inclusion initiatives

Career development opportunities

Qualifications

• Experience with data visualization tools is mandatory.
• Strong coding skills in SQL and Python are required.
• Ability to communicate complex concepts simply.
• Experience with predictive modeling and machine learning is an asset.

Responsibilities

• Develop data models and analytical solutions.
• Create analytics and data pipelines.
• Design predictive models to forecast impact on revenue.
• Produce ad hoc analysis for financial KPIs.
• Visualize data findings for other departments.

Skills

SQL coding

Python coding

Data visualization

Analytical skills

Problem-solving skills

Attention to data quality

Education

Bachelor’s degree in Statistics, Mathematics, Economics, Business

Master’s degree (asset)

Tools

Tableau

Power BI

Job description

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.
The Aeroplan Currency Management team is responsible for managing the profitability of the Aeroplan accrual and rewards portfolio. The team is therefore constantly developing levers and program constructs allowing the optimization of the Aeroplan contribution to revenue and profitability of Air Canada, while delivering great value to our members.

As a Data Analyst R&D, you need to be passionate about using data and your analytic skills to guide business decisions. You will learn to be an expert in the performance of ticket sales, points issuance and the overall travel & loyalty industry. You will also have to identify and develop potential improvements to actual and future way the Air Canada incentivize customer behavior through earn of points using different methods (e.g: data mining, forecasting and visualization). You will have the responsibility of translating these findings into high value, easy to understand stories that will be presented to department leaders in the pursuit of maximization of the profitability of Air Canada.

Responsibilities

• Develop data models and analytical solutions to improve pricing capabilities and optimize the team’s productivity.
• Create analytics and data pipelines from proof of concept to production ready tools.
• Develop advanced knowledge of all data assets and processes relevant to core business support.
• Built the foundation of tools useful to drive effectiveness in action undertaken to optimize a pricing of $1B+ of redemption expenses.
• Responsible for the QA of tools developed by the R&D team ensuring risks are minimized when deployed in PROD.
• Responsible for investigating and creating fixes onto the flight pricing pipeline and tools when issues are found.
• Design predictive models to forecast the impact of bonus points and promotions on flight bookings and overall revenue.
• Work closely with Revenue Management, Loyalty and Marketing teams to align incentive strategies with organizational objectives.
• Produce ad hoc analysis and support of quantification of business initiative impact of financial KPIs and associated risk assessments through financial modeling.
• Understands and analyzes complex business problems, then formulates data-driven hypotheses to drive business value.
• Defines innovative data solutions to loosely defined business problems by leveraging pattern detection over potentially large datasets.
• Support quantification of impacts and risks of product parameter management and marketing activities using various forms of interrelated subjects like mathematics, statistics, finance, economics, behavioral economics and computer science.
• Represent the team’s interests in corporate initiatives, making sure profitability levers and efficiency of processes are taken into consideration. Provide value-added support to other departments by performing various analyses on redemption data.
• Use data visualization techniques to disseminate the discoveries to other departments in an interesting manner.
• Build knowledge base of insights for proper internal dissemination.

Qualifications

• Bachelor’s degree in Statistics, Mathematics, Economics, Business, Business Intelligence or a related field – master’s degree is an asset.
• Thrilled to tackle business challenges and identify new opportunities for growth.
• Advanced knowledge and concrete experience coding in SQL and python.
• Experience with data visualization tools like Tableau and/or Power BI is mandatory.
• Analytical and problem-solving skills.
• Ability to highlight insights when presenting findings (communicate complex concepts into simple ones).
• Particular attention to data and code quality.
• Mathematics and statistics skillsets including predictive modeling, time series, optimization techniques, machine learning, etc. is an asset.
• Knowledge of the travel and loyalty industry is strong asset.
• Ability to multi-task and meet deadlines while paying attention to details.
• Positive thinking and sense of humor.
• 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 seeking any required work permits/visas or other authorizations which may be required is the sole responsibility of the candidates applying for this position.

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.