Senior Data Engineer - Revenue Analytics

WestJet; Calgary; On-site; CAD 140,000 - 200,000; Full time

Benefits offered by this job

Travel privileges for you and your 가족

Job summary

WestJet is seeking a Senior Data Engineer to join the Revenue Analytics team in Calgary, focusing on architecting data solutions, building scalable pipelines, and ensuring data quality for executive and front-line audiences.

You will partner with stakeholders to translate business needs into technical solutions, guide data modernization, and mentor team members while delivering reliable analytics across the organization.

Qualifications

• 8+ years of experience in large-scale data warehouse environments, including project-based data development.
• 5+ years of hands-on SQL experience with advanced SQL, window functions, and performance tuning.
• Strong proficiency in Snowflake, SQL, Python, and scripting for scalable data solutions.

Responsibilities

• Lead data architecture, modeling, and integration solutions that support current and future business needs.
• Lead data projects from planning through delivery with stakeholders to manage priorities and timelines.
• Design and develop scalable, cloud-based data solutions and pipelines following established standards.
• Develop and maintain data quality, validation, reconciliation, and monitoring processes to ensure data accuracy.

Skills

SQL development

Snowflake

Python

Data modeling

Data integration

ETL/ELT

Cloud computing

Communication

Education

Bachelor's or higher in CS/Engineering

Tools

Azure

Tableau

Power BI

Job description

This position requires in-person collaboration up to five days a week. This arrangement is subject to change based on business requirements.

Why WestJet

Since our story took off in 1996, WestJet has strived to enrich the lives of everyone in our world; a career with us is no exception. We’re proud to be one of Canada’s most admired and respected corporate cultures and continuously aim for the highest standards of service and success.

Join us, this is where your career story takes off.

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, The Senior Data Engineer will provide technical ownership and advisory leadership for data capabilities, ensuring solutions are scalable, reliable, and aligned with future business needs. The role will partner closely with stakeholders to understand business requirements, translate them into effective technical solutions, and provide guidance on architecture, data quality, modernization, and technical trade-offs.

You will help build a grassroots analytics function and 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 Revenue Management & Pricing 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

• Lead data architecture, modeling, and integration solutions that support current and future business needs
• Lead data projects from planning through delivery, working closely with stakeholders to manage priorities, dependencies, and timelines
• Design and develop scalable, reliable cloud-based data solutions and pipelines using established data engineering standards and practices
• Develop and maintain data quality, validation, reconciliation, and monitoring processes to ensure data accuracy and reliability
• Optimize data solutions and pipelines for performance, scalability, and cost efficiencyTroubleshoot complex data issues, identify root causes, and implement sustainable solutions
• Provide ongoing operational support for critical data solutions, ensuring timely resolution of issues and minimal disruption to business operations
• Apply data governance, security, and access standards to ensure data is managed appropriately and responsibly
• Develop and maintain comprehensive technical documentation for data solutions, pipelines, architecture, processes, and operational procedures
• Lead workshops, presentations, and training to share technical expertise and strengthen data engineering capabilities across the team
• Provide technical guidance and mentorship to team members, promoting consistent engineering practices and knowledge sharing
• Communicate complex technical concepts clearly and translate business needs into practical data solutions
• Build strong relationships with stakeholders and effectively communicate technical considerations, risks, and trade-offs
• Ensure data solutions are secure, reliable, maintainable, and aligned with enterprise standards

Experience And Qualifications

• Degree in Computer Science, Engineering, Information Systems, Information Security, or a related field, with 8+ years of relevant experience preferred, or an equivalent combination of education, training, and experience
• 6+ years of experience working in large-scale data warehouse environments, including project-based data development
• 5+ years of hands‑on experience in SQL development, including advanced SQL, window functions, query optimization, and performance tuning
• Strong proficiency in Snowflake, SQL, Python, and scripting, with experience developing scalable data solutions and pipelines
• Strong experience with data warehouse architecture, dimensional modeling, data analysis, and data integration
• Experience with ETL/ELT frameworks, data warehouse automation, and batch and real-time data processing
• Experience working with cloud-based data platforms and services, such as Snowflake, Azure, or similar technologies
• Experience with data ingestion, custom file formats, ingestion monitoring, and data quality controls
• Strong understanding of database management systems, OLAP, data architecture, and DevSecOps practices
• Experience developing meaningful, repeatable, and consistent data quality and validation checks
• Strong analytical, critical‑thinking, and problem‑solving skills, with the ability to troubleshoot complex data issues and identify root causes
• Excellent communication and presentation skills, with the ability to translate complex technical concepts into clear business language and work effectively with technical and non-technical stakeholders
• Highly motivated, organized, and autonomous, with the ability to collaborate cross‑functionally and lead projects and deliverables
• Strong project and time‑management skills, with demonstrated ability to manage priorities, dependencies, and timelines
• Experience providing technical guidance, mentoring, and knowledge sharing to team members

Nice To Have

• Experience in Revenue Management, airline, travel, pricing, forecasting, or commercial analytics
• Experience with Sabre, ATPCO, or other airline industry systems/data
• Experience with Alteryx, Tableau, Power BI, VBA, R, SAS, Oracle

The Benefits Of Being a WestJetter

• A fun and friendly culture with colleagues who work together to win
• Travel privileges for you and your family, effective from your start date
• Savings and Benefit programs that are flexible to meet your specific needs

About WestJet Group Of Companies

WestJet took to the skies in 1996 with just over 200 employees and three aircraft operating service to five destinations. Since then, WestJet has pioneered low-cost travel in Canada, cutting airfares in half, and increasing the flying population in Canada by more than 50 per cent. Since the Sunwing Airlines integration in 2025, more than 15,000 WestJetters support nearly 200 aircraft and connect guests to our global network of more than 100 destinations across North America, Central America, the Caribbean, Europe and Asia. The WestJet Group is a major Canadian employer and includes WestJet Airlines, WestJet Encore and Sunwing Vacations Group. We’re Canada’s leading value airline and largest vacation provider, with a united purpose of providing affordable and accessible air and vacation travel to Canadians.

Our safety promise

At WestJet, the safety and security of our people and our guests is a core value and at the heart of what we do. Safety and security are shared responsibilities all team members are expected to use safe work practices to ensure their well-being and the safety of others. WestJet recognizes that the use of Alcohol and Drugs can adversely impact a safe work environment and the well-being of others including guests, suppliers and the public, as well as place WestJet's operations at risk. All roles that are identified as Safey‑Sensitive are required to pass a Pre‑Employment Alcohol and Drug Test as per WestJet's Alcohol and Drug Policy.

Our commitment to diversity, equity and inclusion

We embrace what makes each of us unique, and what makes us uniquely WestJet. We welcome diverse skills, experiences and backgrounds so if you're passionate about this role, we encourage you to apply – even if you don't meet every qualification listed. WestJet is committed to inclusiveness, equity and accessibility throughout the selection process. If you require accommodation at any stage, please contact our Talent Acquisition team at [e-mail].

We value the time and effort you put into your application. Our recruitment process is highly competitive and while every applicant will receive communication regarding their application status, only those selected to move forward will be contacted with next steps. If this role isn’t the right fit, we encourage you to explore future opportunities with us.

About

For more information about everything WestJet, please westjet.com/aboutus.

If you wish to withdraw your application or request that your personal information be deleted, please contact us at [e-mail].