Lead ETL Data Engineer - Toronto - Astra North Infoteck Inc.

    Astra North Infoteck Inc.
    Astra North Infoteck Inc. Toronto

    2 days ago

    Description
    Experience Required: 6–8 years (minimum requirements include 8–10 years overall data experience as described)
    Skills: Python, Apache Spark, Database Technologies (SQL & NoSQL)
    We are seeking a highly experienced Data Engineering Lead with deep expertise in ETL development, large‑scale SQL data marts, advanced analytics, troubleshooting, and cloud‑based data integration. The ideal candidate will have a strong technical background, excellent communication skills, and the ability to manage complex workloads in fast‑paced environments.

     Key Responsibilities:

    1. ETL Development & Cloud Data Integration Design and develop end‑to‑end ETL processes using Azure Data Factory, Synapse Pipelines, or Databricks.

    Establish and maintain cloud connectivity across systems including ADLS, ADF, Synapse, and Databricks.

    Ensure efficient extraction, transformation, loading, and orchestration of large datasets.

    2. Advanced Programming & Scripting

    Develop and optimize complex T‑SQL queries, stored procedures, and functions.

    Write automation and transformation scripts using Python within Azure-based ETL frameworks.

    3. Data Mart & Database Management

    Bring a minimum of 10 years' experience working with large SQL data marts, including at least 3 years in a Tech Lead role.

    Troubleshoot, optimize, and support large-scale SQL databases, including performance tuning, indexing, and storage planning.

    Perform ETL of large data volumes from multiple systems with strong attention to accuracy and performance.

    Identify, report, and manage database security, including access controls and compliance.

    4. Data Analysis & Problem Solving

    Navigate and analyze massive volumes of data to design effective extraction, load, and reporting solutions.

    Demonstrate a strong analytical mindset, excellent attention to detail, and the ability to solve complex technical issues.

    Work under tight deadlines while balancing multiple priorities.

    5. Data Governance & Operational Support Support database testing, troubleshooting, and validation activities.

    Design backup, archiving, and retention strategies; maintain recovery readiness and capacity planning.

    Ensure compliance with enterprise data governance and security standards.

    6. Stakeholder Communication & Collaboration Communicate effectively with stakeholders across all levels—from junior analysts to senior leadership.

    Lead discussions related to data solutions, technical decisions, and delivery timelines.

    Work independently as well as collaboratively within cross‑functional teams.

    Demonstrate proactive behavior, strong organization, and a willingness to learn new tools and technologies.

    Nice‑to‑Have / Additional Assets:

    Experience in financial institution data mart environments.

    Hands-on experience with .NET applications.

    Experience designing dashboards in Tableau.

    Prior work with large-scale datasets in a regulated environment.

    Essential Skills:

    Strong experience in database management across both relational and NoSQL platforms.

    Familiarity with Hadoop, Spark, Kafka, or other distributed data technologies.

    Deep understanding of ETL processes, data flows, and pipeline orchestration.

    Knowledge of data modeling principles and best practices.


  • Work in company

    Senior Data Engineer Consultant

    Only for registered members

    +Réjoignez KEYRUS et fañonner l'avenir de la data avec nous · +Comprendre les besoins techniques des clients afin de concevoir des solutions data performantes et évolutives · Concevoir, développer et optimiser des pipelines de données et architectures lakehouse (Databricks, Fabri ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    We are hiring a Data Engineer to help us make data driven decisions. · Owner of the core data pipelines in mapping · Evolving data model and schema based on business needs · ...

    Toronto, ON

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    We are seeking a skilled Data Engineer to build maintain and optimize data pipelines and data platforms. · ...

    Toronto, ON

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    The Data Engineer builds and maintains the data pipelines, transformations, and integrations that power AI-ready analytics on Microsoft Fabric and the Azure data ecosystem . This is a hands-on, delivery-focused role responsible for implementing data architectures, optimizing perf ...

    Toronto, ON $80,000 - $125,000 (CAD) per year

    1 week ago

  • Work in company

    Data Engineer

    Only for registered members

    + Job summary · As a Data Engineer in our Advanced Analytics team, your primary focus will be on ensuring the stability, reliability and performance of ML models in production environments. · + Design develop and manage ETL data pipelines that facilitate the detailed extraction t ...

    Toronto, ON

    3 weeks ago

  • Work in company

    Data Engineer

    Only for registered members

    We're looking for a motivated Data Engineer to help build and scale our cloud-native data pipelines using Snowflake and dbt. · Design, develop, and maintain ELT pipelines using dbt and Snowflake. · Build and support data ingestion processes from internal and external sources usin ...

    Toronto, ON

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    We are seeking an experienced Data Engineer to support the Internal Audit Technology function within FIAT (Finance Internal Audit Technology). · The successful candidate will design, code, analyze and modify programming systems for large-scale systems. · The role requires 6-8 yea ...

    Toronto, ON $80,000 - $125,000 (CAD) per year

    2 weeks ago

  • Work in company

    Data Engineer, Forecasting Core Data Engineering

    Only for registered members

    Amazon is looking for a Data Engineer to join the team. · Create scalable data solutions using AWS and/or Amazon internal tools. · Create and maintain business logic for data transformation and ingestion pipelines. · ...

    Toronto, ON

    3 weeks ago

  • Work in company

    Data Engineer

    Only for registered members

    We are currently seeking a Data Engineer to join our growing data and analytics team. · ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    Design, develop, and maintain scalable data pipelines using Azure services. · ...

    Toronto, Ontario

    2 weeks ago

  • Work in company

    Data Engineer

    Only for registered members

    Data Engineer responsible for designing and developing scalable data pipelines using Databricks (PySpark, Delta Lake, SQL) and building ETL/ELT workflows for structured and unstructured data. · Design, develop and maintain scalable data pipelines using Databricks. · Build ETL/ELT ...

    Toronto, Ontario

    1 month ago

  • Work in company Remote job

    Data Engineer

    Only for registered members

    This is a hands-on engineering role focused on building production-grade pipelines, schemas, and supporting services. · ...

    Toronto, Ontario

    3 weeks ago

  • Work in company

    Data Engineer

    Only for registered members

    · Who We Are · Konrad is a next generation digital consultancy. We are dedicated to solving complex business problems for our global clients with creative and forward-thinking solutions. Our employees enjoy a culture built on innovation and a commitment to creating best-in-class ...

    Toronto $90,000 - $125,000 (USD) per year

    1 week ago

  • Work in company

    Data Engineer

    Only for registered members

    Role Descriptions: · We're looking for a Data Engineer with strong Python and SQL skills to build reliable data pipelines that convert semi-structured data from ES URLs into clean analytics-ready datasets. You'll work locally (Python, DBeaver, SQLite, Postgres, Dremio), establish ...

    Toronto, Ontario $80,000 - $125,000 (CAD) per year

    1 day ago

  • Work in company

    Data Engineer

    Only for registered members

    · The GCP Data Engineer (Google Cloud Platform) will play a key role at Stacktics, where we design, create, deploy, maintain and grow industry-leading Cloud Infrastructure, Big Data Analytics and Cloud For Marketing products, solutions and services. · Stacktics will rely on the ...

    Toronto, Canada $45,000 - $90,000 (CAD) per year

    2 days ago

  • Work in company

    Data Engineer

    Only for registered members

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors, seeking competent individuals to fulfill the role of Data Engineer to join their dynamic team for their client, one of the major banks. ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    Data Engineer - Asset Management at Leading Investment Bank in Toronto, · Design build and optimize cutting-edge Azure data solutions · Deliver secure reliable datasets with strong governance automation and documentation · ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    Data engineer with strong Python and SQL skills building reliable data transformations and feature pipelines on AWS. · Strong Python (PySpark and/or pandas) and SQL · Data engineering and ML engineering on AWS · ...

    Toronto, Ontario

    3 weeks ago

  • Work in company

    Data Engineer

    Only for registered members

    We are seeking a highly skilled and experienced Staff Data Engineer to join our Data Platform Team. · Design, build, and maintain scalable batch and real-time data pipelines to meet evolving business needs · Lead and mentor a team of data engineers, fostering technical excellence ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    We have a job opening for a Python Data Engineer role in Toronto. · Develop and deliver Python programs to meet project requirements with strong proficiency in Python programming. · ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Data Engineer

    Only for registered members

    Data engineer position for banking industry in Toronto. · ...

    Toronto, Ontario

    2 weeks ago

Jobs
>
Toronto