Senior Data Engineer - Revenue Analytics
About The Position
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.
Requirements
- 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 Haves
- 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
Responsibilities
- 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 efficiency
- Troubleshoot 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
Benefits
- Competitive total rewards package
- Travel privileges for you and your family, effective from your start date
- Savings and Benefit programs that are flexible to meet your specific needs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
