Senior Data Developer

Employment Type: Full-time Regular

City: Calgary, AB (YYC)

Posting Open Date: 11/21/2024

Posting Close Date: 12/05/2024 (Please note the posting will close at 11:59pm MST)

Please note: This position may be open to remote work in Canada, but preference will be given to candidates in Calgary and Toronto. If located in Calgary and Toronto, this position is eligible for Hybrid work (up to 3 days a week)

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 story takes off.

Overview of role:

WestJet Group is seeking a Senior Data Developer team member for the progressive, essential, and fun Data Engineering team.

Everything every team member delivers has a high impact to the organization and to the team itself. So, the Senior Data Developer must exhibit: A high standard of excellence in self-driving results, and enjoy self-learning, challenge, and mentorship. The ability to demonstrate high self-motivation, adaptability, and workability in an agile environment. A strong passion for data, demonstrate high accountability, and set high standards with a focus on meeting requestors and our standards/requirements. You will work with a team that directly builds and delivers solutions to business objectives and outcomes, using cloud-based services, producing action-oriented insights.

Key deliverables include:

• Plan and lead development in alignment with the Data Delivery strategy
• 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
• Provide 'programming tools and techniques' technical and end-user advice - for existing and new tools - to stakeholders and set the team-based standards
• Proactively mentor team members to promote a communal learning and knowledge sharing culture; provide technical leadership, coach, and mentor the team
• Produce detailed designs and document work using required standards, methods, and tools, including prototyping tools where appropriate
• Find ways to improve code/scripts and system robustness, resilience, and stability
• Translate logical designs into physical designs
• Leads review of own work and that of colleagues'
• Ensure that assigned daily support activities are dealt with in a successful and timely manner
• Design, implement and test cloud computing solutions using Snowflake
• Create, monitor, and optimize ETL/ELT processes and migrate on-premises solutions to Snowflake
• Validate that the Data Engineering meets requirements and Service-Level expectations
• Leads workshops, presentations, and training that provide skill and knowledge development for the team
• Work with operational partners to ensure the supportability of new features/products and to provide timely technical support and fixes to production applications
• Regularly makes decisions under minimal guidance that have a significant impact on the organization's financial and business operations
• 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

Experience and qualifications:

• Bachelor's degree in Computer Science, Engineering, Statistics, Mathematics, or related field
• 5+ years of experience working in very large data warehouse environments
• 3+ years of demonstrated data developer experience in SQL development
• 3+ years of Data Warehouse experience in a project environment
• Nice to have Azure Data Engineering or Snowflake certification
• Experience and proficiency with Data dimensional modeling, data analysis and data mining
• Expert in writing SQL Scripts using window functions and Query optimization
• Experience with Custom File Formats, setting up Ingestion Monitoring
• Experience with ETL, ELT and data warehouse automation tools
• Experience with cloud-based computing services and data warehouses like Snowflake, Azure, or similar
• Experience delivering custom solutions using the Scrum delivery methodology
• Strong data related analytical, critical thinking, and problem-solving skills
• Strong ability to develop meaningful, repeatable, and consistent quality checks throughout the development process
• 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 data solutions
• Experience with WhereScape and Snowflake
• Experience with languages such as Python, Bash, PowerShell
• Experience with JIRA or Azure DevOps

The benefits of being a WestJetter:

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

Think we are a fit? Apply now!

About WestJet Group of Companies

Together with WestJet's regional airline, WestJet Encore, we offer scheduled service to more than 100 destinations in North America, Central America, the Caribbean and Europe and to more than 175 destinations in over 20 countries through our airline partnerships.

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. We encourage all qualified candidates to apply. 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.

#LI-TO1