Analyst, Data Analytics

WestJet Group; Calgary; On-site; CAD 90,000 - 130,000; Full time

Job summary

WestJet Group seeks an experienced Revenue Analytics professional to build and scale analytics for the Revenue Management & Pricing team. You will transform complex data into actionable insights for executive and frontline users, developing models, dashboards, and automated tooling to support strategic actions in a dynamic market.

You will collaborate across departments, own data quality, and help drive competitive advantage through rigorous analytics and well-communicated findings.

Qualifications

• Bachelor’s Degree in Computer Science, Quantitative Economics/ Math/ Stats/ Business/ Engineering or similar.
• 5+ years with at least 3 years in an analytical role including decision making and project coordination.
• In-depth understanding of database management systems, OLAP and ETL; strong SQL proficiency.

Responsibilities

• Translate Revenue Management, Pricing, and Ancillary business problems into advanced data models and assets to support strategic direction.
• Develop and implement systems and technology to produce decision support data and tools for WestJet stakeholders.
• Develop and maintain automated systems for strategic pricing and inventory activities; select appropriate methodologies.
• Automate routine tasks to improve productivity and quality and identify opportunities for quality improvement.
• Contribute to system adaptation and migration strategy and perform system administration tasks for all business unit applications.
• Identify testing needs for business initiatives and support testing across stakeholder groups.
• Represent the business unit on cross-functional projects and drive solutions from ideation to delivery.

Skills

SQL

Analytical thinking

Communication

Education

Bachelor’s Degree (CS/Quant Economics/ Math/ Stats/ Business/ Engineering)

Tools

SQL

Alteryx

Tableau

Python

R

Snowflake

Job description

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