Lead Data Engineer

4 weeks ago


Toronto, Canada Next Pathway Full time

Lead Data Engineer (ETL/EDW/Cloud) for Next Pathway - The Automated Cloud Migration Company


Listed as one of Canada’s hottest start-ups by the Globe and Mail, Next Pathway is a technology services company providing clients a pathway from existing to emerging technologies. Our automation technology helps our customers accelerate the migration of complex applications and workloads to the cloud.


Next Pathway is full of bright and diverse thinkers. With deep exposure to AI, Machine Learning and Robotic Process Automation, our team members have opportunities to be trailblazers in the technology space. We encourage self-starters, transparency and team connectivity. We know diverse teams make strong teams. We welcome people of diverse backgrounds, experiences, and perspectives.


Our work environment is based on 3 core principles:


  1. Emphasize quality first, each and every time.
  2. Put people in roles where they will succeed and feel challenged.
  3. Build a team of well qualified individuals that can share ideas and learn from each other.

Next Pathway rewards people for hard work, loyalty, innovation, and mutual support. We aim to match people’s strengths, skills and talents to our requirements. Identifying this ideal match between attitude, skill and need, leads to success.


As Lead Data Engineer (ETL/EDW/Cloud), your core responsibility will be as a ‘hands-on’ lead for the project teams as they actively work to validate and remediate code required for delivery. Team members requiring guidance on how best to handle specific cases they encounter will look to this role for help, a role that is client facing and will also ensure that automation capabilities are maximized in each assigned project.


Primary Responsibilities:

  • Act as the Technical Lead on client migration engagements
  • Oversee a team of developers, both employee and contractor, assigning tasks and ensuring timely and high-quality delivery
  • Remove blockers for team members primarily by helping them overcome challenging coding situations but also ensuring they have environment, data, permissions, etc. required for them to succeed.
  • Continuously assess technical risks on each migration engagement; and present reasonable solutions to overcome issues/challenges.
  • Work with Solution Engineer throughout engagements to identify automation and process opportunities on and for assistance in solving ‘edge-cases.’
  • Provide timely status and deliverables to Project and QA Leads on assigned migration engagements and communicate issues and risks openly.
  • Contribute innovative improvements to automation and process that will improve velocity and quality of delivery for current and future projects.
  • Follow agile methodologies.
  • Work with Atlassian Tools


Additional Responsibilities:

  • Provide performance feedback on delivery staff, whether exceeding, meeting, or below expectations.
  • Contribute to interviewing and recruiting of new team members.
  • Create a professional, open and positive work environment, that team members are happy to be part of. Practice continuous learning across teams, expanding staff skills and encouraging sharing across team and document any new steps within the process during the project.
  • Build and contribute to the common knowledge bases to get new team members onboard speedily and counterbalance different skill levels within the team.
  • Ensure timely response and remediation to raised defects.


Key Skill Requirements:

  • PhD or master’s degree in computer science / software engineering
  • 10+ years technical experience in ETL and Data Warehouses, including one or more of Informatica, DataStage or SSIS ETL tool and one of Oracle, Teradata, Netezza, DB2, or SQL Server.
  • Technical experience with DataBricks, Azure Synapse/Fabric, or Snowflake.
  • Experience conducting Unit and Functional Tests of ETL/ETL Pipelines
  • Experience optimizing performance of ETLs/ELTs
  • Cloud knowledge (i.e., AWS, GCP, Azure)
  • Good understanding of Continuous Improvement (CI) and Continuous Deployment (CD) processes.


Additional Skill Requirements

  • Prior experience in a Project Delivery/services organization of large engagements with enterprise clients
  • Team Player with Excellent Interpersonal and Communication Skills (Written and Verbal)
  • Ability to Collaborate and Communicate Effectively with all Stakeholders (i.e. Developers, Testers, Business Analysts, Executives, Customers)
  • Experience Working with Multi-Vendor, Multi-Culture Development Teams in Dynamic and Complex Environments.
  • Experience Working Within an Agile Environment
  • Strong Work Ethic with a Positive Attitude
  • Strong Analytical and Problem-Solving Skills
  • Excellent Time Management Skills

  • Lead Data Engineer

    2 days ago


    Toronto, Canada Insight Global Full time

    Must-haves - 10-12 years experience working within data engineering roles - 5-7 years experience with AWS cloud services including: EMR, MWAA, LakeFormation, Glue, DMS, QuickSight, and AWS Athena - 8+ years experience with big data technologies including: Apache Spark, Apache Hudi, Hive, Airflow, Trino, and Databricks - CICD - Terraform for sure ,...

  • Lead Data Engineer

    4 days ago


    Toronto, Canada Insight Global Full time

    Must-haves - 10-12 years experience working within data engineering roles - 5-7 years experience with AWS cloud services including: EMR, MWAA, LakeFormation, Glue, DMS, QuickSight, and AWS Athena - 8+ years experience with big data technologies including: Apache Spark, Apache Hudi, Hive, Airflow, Trino, and Databricks - CICD - Terraform for sure ,...

  • Lead Data Engineer

    4 days ago


    Toronto, Canada Insight Global Full time

    Must-haves - 10-12 years experience working within data engineering roles - 5-7 years experience with AWS cloud services including: EMR, MWAA, LakeFormation, Glue, DMS, QuickSight, and AWS Athena - 8+ years experience with big data technologies including: Apache Spark, Apache Hudi, Hive, Airflow, Trino, and Databricks - CICD - Terraform for sure ,...

  • Lead Data Engineer

    2 days ago


    Toronto, Canada Insight Global Full time

    Must-haves - 10-12 years experience working within data engineering roles - 5-7 years experience with AWS cloud services including: EMR, MWAA, LakeFormation, Glue, DMS, QuickSight, and AWS Athena - 8+ years experience with big data technologies including: Apache Spark, Apache Hudi, Hive, Airflow, Trino, and Databricks - CICD - Terraform for sure ,...


  • Toronto, Canada hireVouch Full time

    Our client is a Toronto-based GCP consulting company that is focused on helping a variety of businesses through cloud-based solutions. They are growing their team and are looking for a passionate Data Engineering Manager/Lead to continue to guide them to success. In this role, you will be responsible for leading a team of data engineers in designing,...


  • Toronto, Canada hireVouch Full time

    Our client is a Toronto-based GCP consulting company that is focused on helping a variety of businesses through cloud-based solutions. They are growing their team and are looking for a passionate Data Engineering Manager/Lead to continue to guide them to success. In this role, you will be responsible for leading a team of data engineers in designing,...


  • Toronto, Canada hireVouch Full time

    Our client is a Toronto-based GCP consulting company that is focused on helping a variety of businesses through cloud-based solutions. They are growing their team and are looking for a passionate Data Engineering Manager/Lead to continue to guide them to success. In this role, you will be responsible for leading a team of data engineers in designing,...


  • Toronto, Canada hireVouch Full time

    Our client is a Toronto-based GCP consulting company that is focused on helping a variety of businesses through cloud-based solutions. They are growing their team and are looking for a passionate Data Engineering Manager/Lead to continue to guide them to success.In this role, you will be responsible for leading a team of data engineers in designing,...


  • Toronto, Canada McMillan Shakespeare Limited Full time

    The McMillan Shakespeare Group (MMS) is a trusted provider of salary packaging, novated leasing, disability plan management and support co-ordination, asset management and related financial products and services. From our origins in 1988 when we created Australia’s salary packaging industry to today, MMS has a proud history of innovation and exceptional...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . T

  • Sr/Lead Data Engineer

    3 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers!Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team. This role is heavily hands on and requires strong experience with...

  • Sr/Lead Data Engineer

    3 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Sr/Lead Data Engineer

    3 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers!Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team. This role is heavily hands on and requires strong experience with...

  • Sr/Lead Data Engineer

    3 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good dayData Engineers !Insight Global is looking for 6 Sr or LeadData Engineersto join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within theData Distribution TeamorAsset Management Team . This role is heavily hands on and requires strong experience with...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong experience...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers!Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team. This role is heavily hands on and requires strong experience with...

  • Sr/Lead Data Engineer

    4 weeks ago


    Toronto, Canada Asset Management Industry Full time

    Good day Data Engineers!Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team. This role is heavily hands on and requires strong experience with...

  • Lead Data Engineer

    2 weeks ago


    Toronto, Canada Crypto Recruiters Full time

    We are actively searching for a Lead Data Engineer to join our team on a permanent basis. This role does require onsite work as you will be leading a team that is building a data product that will give insights to investors in the crypto and Web3 industry. In this role, you will be responsible for designing and building cutting-edge data analysis systems,...