Data Analyst

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 to manage 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 membersAs 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.QualificationsBachelor’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 growthAdvanced knowledge and concrete experience coding in SQL and pythonExperience with data visualization tools like Tableau and/or Power BI is mandatoryAnalytical and problem-solving skillsAbility to highlight insights when presenting findings (communicate complex concepts into simple ones)Particular attention to data and code qualityMathematics and statistics skillsets including predictive modeling, time series, optimization techniques, machine learning, etc. is an assetKnowledge of the travel and loyalty industry is strong assetAbility to multi-task and meet deadlines while paying attention to detailsPositive thinking and sense of humorDemonstrate 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 RequirementsBased on equal qualifications, preference will be given to bilingual candidates.Diversity and InclusionAir 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.