Intermediate Data Analyst
WestJetCanada6 days ago
Full-timeInformation Technology
Track This Job
Add this job to your tracking list to:
- Monitor application status and updates
- Change status (Applied, Interview, Offer, etc.)
- Add personal notes and comments
- Set reminders for follow-ups
- Track your entire application journey
Save This Job
Add this job to your saved collection to:
- Access easily from your saved jobs dashboard
- Review job details later without searching again
- Compare with other saved opportunities
- Keep a collection of interesting positions
- Receive notifications about saved jobs before they expire
AI-Powered Job Summary
Get a concise overview of key job requirements, responsibilities, and qualifications in seconds.
Pro Tip: Use this feature to quickly decide if a job matches your skills before reading the full description.
Employment Type: Full-time Regular
City: Calgary, AB (YYC)
Posting Open Date: 10/23/2025
Posting Close Date: 11/06/2025 (Please note the posting will close at 11:59pm MST)
Why WestJet:
Every WestJet journey has the potential to enrich lives; a career with us is no exception.
WestJet arrived on the Canadian airline scene in 1996 and changed the industry for the better. We made air travel more affordable for Canadians and now we're going global.
Join us, this is where your career story takes off.
Overview of role:
WestJet is seeking an Intermediate Data Analyst team member for the progressive, essential, and fun Data Delivery – Data Products & Delivery team.
If you have a strong passion for analytics, demonstrate high accountability, and set high standards with development that follow best-practice you will fit right in! As an Intermediate Data Analyst, you will be responsible for designing and developing code, verifies, tests, documents, amends, and refactors moderately complex programs/scripts and integration services. You will work with a team that directly builds and delivers data products to meet business objectives and outcomes.
Key deliverables include:
WestJet provides all WestJetters with a competitive total rewards package. On top of that, we offer:
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. Following integration with Sunwing in 2025, more than 14,000 WestJetters support nearly 200 aircraft and connect guests to more than 100 destinations across North America, Central America, the Caribbean, Europe and Asia.
As a major Canadian employer that includes WestJet Airlines, Sunwing Vacations Group and WestJet Cargo, the WestJet Group is Canada’s leading low-cost 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. As safety and security is a shared responsibility, it is expected that you will use safe work practices to ensure your 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 safety sensitive are required to pass a Pre-Employment Alcohol and Drug Test as per WestJet's Alcohol and Drug Policy.
Our Commitment to Diversity and Inclusion
We embrace what makes us each unique, and what makes us uniquely WestJet. WestJet is committed to inclusiveness, equity, and accessibility and if you require accommodation during the selection process, please let our Talent Acquisition team know at [email protected]. We encourage all qualified candidates to apply.
At WestJet, we welcome unique skills, experiences, and backgrounds - if you’re passionate and excited about this role, we encourage you to apply even if you do not meet every single qualification in the posting. We are committed to inclusivity, equity, and accessibility in the selection process. If you require an accommodation during the recruiting process, please let our Talent Acquisition team know.
We thank all applicants for their interest in WestJet; however, only those candidates who are selected will be contacted.
For more information about everything WestJet, please visit WestJet.com
City: Calgary, AB (YYC)
Posting Open Date: 10/23/2025
Posting Close Date: 11/06/2025 (Please note the posting will close at 11:59pm MST)
Why WestJet:
Every WestJet journey has the potential to enrich lives; a career with us is no exception.
WestJet arrived on the Canadian airline scene in 1996 and changed the industry for the better. We made air travel more affordable for Canadians and now we're going global.
Join us, this is where your career story takes off.
Overview of role:
WestJet is seeking an Intermediate Data Analyst team member for the progressive, essential, and fun Data Delivery – Data Products & Delivery team.
If you have a strong passion for analytics, demonstrate high accountability, and set high standards with development that follow best-practice you will fit right in! As an Intermediate Data Analyst, you will be responsible for designing and developing code, verifies, tests, documents, amends, and refactors moderately complex programs/scripts and integration services. You will work with a team that directly builds and delivers data products to meet business objectives and outcomes.
Key deliverables include:
- Build data products and solutions in alignment with the Digital and Data Delivery strategy.
- Write Python or SQL code for most projects, including automated tests.
- Work with product teams to define and capture data modeling requirements
- Provide input and subject-matter expertise on future data products
- Produce detailed designs and document work using required standards, methods, and tools, including prototyping tools where appropriate.
- Translate logical designs into physical designs.
- Find ways to improve code/scripts and system robustness, resilience, and stability.
- Advise on the right way to apply data development standards and methods, ensuring compliance, and maintain technical responsibility for all the stages and iterations of a data development project.
- Lead review of own work and that of colleagues’.
- Mentor junior team members to promote a communal learning and knowledge sharing culture; provide technical leadership.
- Ensure that assigned daily support activities are dealt with in a successful and timely manner.
- Responsible for the code/scripts that extract, transform, and clean data landing into our Data Warehouse.
- Work with operational partners to ensure the supportability of new features/products and to provide timely technical support and fixes to production issues.
- For assigned customer requests: Communicate with requestors effectively, frequently and responsively to their concerns, issues, feedback, and questions. Advise on the best solution to meet the requestor’s objectives.
- Bachelor's degree in Computer Science, Engineering, Statistics, Mathematics or related field
- 3+ years of experience working in very large data warehouse environments
- 3+ years of demonstrated data developer experience in SQL development and report creation
- 3+ years of Data Warehouse and Business Intelligence experience in a project environment
- Experience and proficiency with Data dimensional modeling, data analysis and data mining
- Self-driven and self-learner
- Expert in writing and tuning SQL scripts
- Experience with ETL and data warehouse automation tools
- Experience developing in Power BI; Tableau is a bonus
- Experience with Azure and/or AWS analytic cloud solutions
- Experience delivering custom solutions using the Scrum delivery methodology
- Strong data related analytical, critical thinking, and problem-solving skills
- Strong ability to understand analytic specifications, and translating these specifications into visualizations and/or underlying code
- Strong ability to develop meaningful, repeatable, and consistent quality checks throughout the development process
- Ability to independently design, and implement data visualization solutions using data visualization best practices
- Excellent oral and written communication skills including the ability to communicate effectively with both technical and non- technical stakeholders
- A work ethic based on a strong desire to exceed expectations
- Proven ability to meet tight deadlines, multi-task, and prioritize workload
- Experience conducting large scale data analysis to support business decision making
- Experience in designing and delivering cross functional custom reporting solutions
- Experience with WhereScape and Snowflake
- Experience with JIRA or Azure DevOps
- Expertise with Microsoft BI toolset, including creating and editing: Dim tables, Fact tables, Stored procedures (SSIS), and Scheduled jobs
- Working knowledge of statistics
WestJet provides all WestJetters with a competitive total rewards package. On top of that, we offer:
- 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. Following integration with Sunwing in 2025, more than 14,000 WestJetters support nearly 200 aircraft and connect guests to more than 100 destinations across North America, Central America, the Caribbean, Europe and Asia.
As a major Canadian employer that includes WestJet Airlines, Sunwing Vacations Group and WestJet Cargo, the WestJet Group is Canada’s leading low-cost 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. As safety and security is a shared responsibility, it is expected that you will use safe work practices to ensure your 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 safety sensitive are required to pass a Pre-Employment Alcohol and Drug Test as per WestJet's Alcohol and Drug Policy.
Our Commitment to Diversity and Inclusion
We embrace what makes us each unique, and what makes us uniquely WestJet. WestJet is committed to inclusiveness, equity, and accessibility and if you require accommodation during the selection process, please let our Talent Acquisition team know at [email protected]. We encourage all qualified candidates to apply.
At WestJet, we welcome unique skills, experiences, and backgrounds - if you’re passionate and excited about this role, we encourage you to apply even if you do not meet every single qualification in the posting. We are committed to inclusivity, equity, and accessibility in the selection process. If you require an accommodation during the recruiting process, please let our Talent Acquisition team know.
We thank all applicants for their interest in WestJet; however, only those candidates who are selected will be contacted.
For more information about everything WestJet, please visit WestJet.com
Key Skills
Ranked by relevanceReady to apply?
Join WestJet and take your career to the next level!
Application takes less than 5 minutes