Lead Data Engineer

The Opportunity: 

 

Under Sunwing Vacations, we are looking for a Lead, Data Engineer to join us in making vacation dreams come true. As the Lead, Data Engineer you will be responsible for leading the team, design, configuration, development, and delivery of the Business Intelligence solutions. You will expand and optimize our data models and data pipeline, as well as optimize data flow and collection for cross functional teams. The position reports to the Sr. Director EA, BI & DBA, and will be located in Toronto, ON. 

 

What You’llDo: 

​​ ​

• Build and manage the team, assist with hiring and coaching 
• ​Conduct performance reviews 
• ​Mentor the team members with best practice process, methodologies, and solution practices 
• ​Build relationships with the lines of the business to serve effectively ​ 
• ​​Plan projects as strategic roadmap, priority management, task identification and estimations 
• ​​​Execute the project for successful delivery (on time with quality) 
• Identify and escalate issues and risks from project and solution perspective​ 
• Ensure the team follows Sunwing SDLC process and methodologies​ 
• ​Design scalable and extensible data pipelines and data warehouse designs 
• ​Create and maintain optimal data pipeline structures supporting the architecture 
• ​Assemble large, complex data sets that meet functional / non-functional business requirements 
• ​Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, etc. 
• ​Build the solution required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure Data technologies 
• ​Design and implement data governance and data quality measures in the BI platforms 
• ​Support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects​ 
• ​​Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics 
• ​Work with stakeholders including the Management, Product, Data and Design teams to assist with data-related technical issues and support their data needs 
• ​Work with external vendors and partners to design, develop and test BI solutions 
• ​Understanding of business and technical requirements, provision of subject matter expertise and implementation of data engineering techniques 
• ​Putting into practice good organizational and time management skills, with the ability to prioritize and complete multiple complex projects under tight deadlines 
• ​Review other developers design and code 
• ​Ensure regular review of data systems to ensure optimal efficiency​ 
• Ensure data governance and quality is maintained and optimal 
• Keep our data separated and secure across LOB boundaries through RBAC 
• Work with data and analytics experts to strive for greater functionality in our data systems 
• Conducting of data discovery activities, performing root cause analysis, and making recommendations for the remediation of data quality issues

•  

What You’ll Need: 

 

• ​Proven ability to lead, mentor, and motivate small teams to medium size teams 
• ​​Strong project planning skills, organizational skills, and execution capabilities 
• ​Excellent written and oral communication skills 
• ​Self-directed and independent working skills  
• ​Strong multi-tasking capabilities to support the data needs of multiple teams, systems, and products 
• ​A data wrangler who enjoys optimizing data systems and building them from scratch  
• ​Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases 
• ​Build processes supporting data transformation, data structures, metadata, dependency, and workload management 
• ​Working knowledge of message queuing, stream processing, and highly scalable Cloud data stores. 
• ​We are looking for a candidate with 4+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. They should also have experience using the following software/tools: 
• ​Experience with Cloud Data technologies (SSIS, ADF, Datalake, Azure Synapse, PBI) etc. 
• ​Exposure to relational SQL and NoSQL databases 
• ​Knowledge with Azure Analysis Services 
• ​Knowledge with stream-processing systems 
• ​Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc. would be an asset 
• ​Knowledge of Tour Ops and Airline systems data is an asset 
• ​Experience working in Agile streams for complete SDLC life cycle process and methodologies through Azure DevOps or Jira etc.​ 

  What We Offer: 

 

• Hybrid Work Opportunities 

• Great travel perks! 

• Goodlife Corporate Discount 

• Comprehensive benefits package 

• RRSP Matching Program 

• Growth opportunities 

• Free Parking 

• Open concept, collaborative workspace 

• Fresh Café with delicious snacks and meals at a subsidized price! 

• Opportunity to give back through our social responsibility initiatives 

• See for yourself! @sunwinglife

 

Diversity, equity, and inclusion - Diversity makes us EPIC; we strive to foster a culture where employees feel uniquely themselves and part of a team. Violence and harassment prevention and response - We partnered with White Ribbon to help us create a survivor-centric, trauma informed policy and educational programs used by all our divisions. Total wellbeing - Our approach is for holistic opportunities to help employees Be EPIC and Be Well. Learning and development - Our offerings are focused on the development of competencies, personal leadership, and leadership in groups and teams.