Lead Data Engineer (ETL/EDW/Cloud)

Full Time
  • Full Time
  • Toronto

Next Pathway



Lead Data Engineer (ETL/EDW/Cloud) for Next PathwayThe 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

To apply, please visit the following URL: