Analyst, Data Analytics

Overview of role

The Revenue Analytics team provides business intelligence analytics and reporting solutions for the Revenue Management & Pricing department within WestJet. Transforming data into meaningful information is an art form that requires the combination of technical skills and business acumen. In Revenue Analytics, we approach information from the perspective of the business user, creating and developing accurate and reliable solutions that speak to both Executive and front-line audiences.

The Revenue Analytics team is rapidly evolving the intelligent landscape of WestJet – implementing creative ideas to capture efficiencies and promote cutting edge analytics.

Reporting to the Manager of Revenue Analytics, you will help build a grassroots analytics function to propel WestJet to a new level of competitiveness. You will actively participate in the conceptualization, development, integration, and troubleshooting of new and existing analyses, tools, and reports - ensuring these solutions land with both Executive audiences and front-line analysts. You are an integral part of the growth of our airline as you ensure a consistent understanding, communication of, and approach to meeting strategic goals.

Key deliverables include

Translate Revenue Management, Pricing, and Ancillary business problems into advanced solutions by developing data models and assets, experimenting with innovative ideas, creating insight to support the strategic direction of the company

Develop and implement systems and technology to produce decision support data and tools that enable WestJetters to take strategic action in a dynamic competitive environment

Develop and maintain automated systems to perform strategic pricing and inventory activities. Select the best methodologies to approach business problems

Improves productivity and quality by automating routine tasks. Seeks to eliminate the need for human intervention and proactively identifies opportunities for quality improvement

Contribute to system adaptation and migration strategy and perform system administration tasks (user setup, system configuration) for all business unit applications

Identifies and conducts required testing efforts for business initiatives and assists, conducts, and supports testing efforts for various stakeholder groups as appropriate

Represent the business unit on large cross-business unit projects, proactively identify potential areas of improvement, and lead plausible solutions from ideation to delivery

Experience and qualifications

Bachelor’s Degree (Computer Science, Quantitative Economics/ Math/ Stats/ Business/ Engineering or similar)

5+ years with a minimum of 3 years in an analytical role incorporating decision making and project coordination in a fast-paced environment

In-depth understanding of database management systems, online analytical processing (OLAP) and ETL framework and strong proficiency in SQL is mandatory

Proficiency in one or more of the following is a bonus –Alteryx, Tableau, Oracle, Sabre, VBA, Python, R, SAS, ATPCO, Snowflake

Excellent communication and presentation skills and a unique ability to bridge the communication gap between executive and front-end users

Highly motivated, organized, and autonomous individual who can collaborate cross-functionally and lead deliverables and/or projects

At WestJet we pride ourselves on our fun and friendly customer focus