Data Engineer- Python, SQL, ELT, Power BI - Toronto - Astra North Infoteck Inc.

    Astra North Infoteck Inc.
    Astra North Infoteck Inc. Toronto

    1 day ago

    Description

    Experience Required: 8–10 Years



    Role Overview

    We are looking for a Data Engineer with strong Python and SQL expertise to build reliable data pipelines that transform semi-structured data from Elasticsearch (ES) URLs into clean, analytics-ready datasets.

    You will work in a local environment using Python, DBeaver, SQLite/Postgres/Dremio, establish database connections, flatten JSON/Elasticsearch topics into structured tables, and enable downstream reporting in Power BI for business users.


    Key Responsibilities

    1. Data Ingestion & Transformation

    • Fetch semi-structured data from ES URLs/APIs (e.g., JSON, Elasticsearch topics)

    • Flatten, normalize, and model data into structured analytics tables

    • Build reproducible ETL/ELT workflows using:

      • Python (pandas, requests, SQLAlchemy)

      • SQL-based transformations

    • Automate data extraction and transformation processes


    2. Database Engineering

    • Create and maintain schemas in:

      • SQLite

      • PostgreSQL

      • Dremio

    • Configure and manage local DB connections via DBeaver

    • Optimize queries, indexing strategies, and performance tuning

    • Implement:

      • Data partitioning

      • Incremental data loads

      • Performance optimization strategies


    3. Data Quality & Governance

    • Establish validation rules, deduplication processes, and anomaly detection

    • Maintain:

      • Dataset versioning

      • Data lineage documentation

      • Metadata and data contracts

    • Ensure secure handling of:

      • Credentials

      • API tokens

      • Endpoints

    • Use Git for version control

    • Maintain code reviews, unit testing, and CI checks

    • Develop technical documentation and runbooks

    • Support ad-hoc business data requests


    Required Skills & Experience

    Technical Skills

    • Python for Data Engineering

      • pandas

      • NumPy

      • requests

      • SQLAlchemy

      • JSON handling & API integration

    • SQL (Advanced Proficiency)

      • SQLite

      • PostgreSQL

      • Querying via Dremio

    • Data Modeling

      • Dimensional and normalized models

      • Handling nested/semi-structured data

    • Tools

      • DBeaver (Database connections)

      • Power BI (Data preparation for reporting)

    • Pipelines

      • ETL/ELT design

      • Performance optimization

      • Error handling and logging


    Core Competencies

    • Strong collaboration and communication skills

    • Ability to translate business requirements into technical solutions

    • Stakeholder engagement from requirements gathering to delivery


    Primary Skills

    • Python

    • PostgreSQL

    • Microsoft Power BI


  • Work in company

    AWS Data Engineer with Databricks-1

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 24th, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    1 week ago

  • Work in company

    AWS Data Engineer with Databricks-4

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 27th, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    5 days ago

  • Work in company

    AWS Data Engineer with Databricks-2

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 25th, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    1 week ago

  • Work in company

    AWS Data Engineer with Databricks-5

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 28th, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    4 days ago

  • Work in company

    AWS Data Engineer with Databricks

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 21st, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    1 week ago

  • Work in company

    AWS Data Engineer with Databricks-3

    Only for registered members

    Toronto, Ontario M5V 3L9 Posted February 26th, 2026 · Looking for more job opportunities? Click here · Job Type: Contract · Job Category: IT · Job Description · Job Title: AWS Data Engineer with Databricks · Location: Toronto, ON (Hybrid/Onsite) · Experience: 6–10 Years · Employm ...

    Toronto, ON

    6 days ago

  • Work in company

    BI Developer – Power BI

    Only for registered members

    We are seeking a Senior Business Intelligence Developer with strong expertise in Power BI, SQL, and Microsoft Fabric to design and deliver enterprise-grade analytics solutions. · This role requires excellent communication skills, adaptability, intellectual curiosity, and a strong ...

    Toronto, ON

    1 week 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

    5 days ago

  • Work in company

    business intelligence specialist – power bi developer

    Only for registered members

    The proponent will review existing data and reporting models and redesign analytical and operational reporting products to be scalable and flexible in support of current and future ministry needs. The work will initially focus on the Early Child Development (ECD) program; however ...

    Toronto, ON

    1 month ago

  • Work in company Remote job

    Snowflake Architect — Contract

    Only for registered members

    Looking for an experienced Snowflake Architect to design and implement scalable data solutions and lead multiple data tracks within an enterprise environment. · ...

    Toronto, Ontario

    1 month ago

  • Work in company

    Manager, Data

    Only for registered members

    We are seeking a Data Manager to lead and modernize Ensemble's operational data, internal applications, and platform ecosystem. · ...

    Toronto, ON

    3 weeks ago

  • Work in company

    Data Engineer Lead

    Only for registered members

    Inclusion without Exception: · Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we ope ...

    Toronto, ON $130,000 - $190,000 (CAD) per year

    6 days ago

  • Work in company

    MS SQL Developer

    Only for registered members

    Inclusion without Exception: · Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we ope ...

    Toronto, ON

    11 hours ago

  • Work in company

    Director, Data

    Only for registered members

    We are seeking a Director of Data & Platform Operations to lead and modernize Ensemble's operational data internal applications platform ecosystem. · Leadership & Strategy Develop direct Ensemble's data and platform operations strategy reliability automation AI-driven process imp ...

    Toronto, ON

    1 month ago

  • Work in company

    Data Engineer

    Astra North Infoteck Inc.

    Job Description: Data Engineer (Python | SQL | Semi‑Structured Data | ES APIs) · Experience Required: 6–8 years · Skills: Python, SQL, Data Modeling, ETL/ELT, DBeaver, SQLite/Postgres/Dremio, API Integration · Role Summary · We are seeking a highly skilled Data Engineer with stro ...

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

    1 day ago

  • Work in company

    Platform Engineer

    Only for registered members

    The Platform Engineer will play a critical role in maintaining, stabilizing and improving Ensemble's internal systems, cloud infrastructure and operational workflows. · ...

    Toronto, ON

    1 month ago

  • We seek a Data Engineering Intern on our Enterprise Data Platform (EDP) team to support infrastructure powering data-driven decision-making at QuadReal. · Help build and operate next generation cloud data platform in Microsoft Fabric. · Build and manage data pipelines using tools ...

    Toronto, ON InternshipSHIP

    1 month ago

  • Work in company

    data architect/modeller- senior

    Only for registered members

    Desarrolla e implementa la arquitectura de datos para el desarrollo de aplicaciones en un entorno complejo y distribuido, incluyendo la determinación del flujo y distribución de datos, la ubicación de bases de datos y métodos de acceso a datos. · ...

    Toronto, ON

    1 week ago

  • Work in company Remote job

    Senior Manager, Newcomer Language Services (2026-102-CP)

    Only for registered members

    The Senior Manager Newcomer Language Services will play a crucial role in supporting the successful integration of newcomers to Canada by enhancing and implementing high-quality language program · Master's degree in Education Adult Education Linguistics. · TESOL Certificate. · 5 ...

    Toronto, ON

    1 month ago

  • Work in company

    Technical Director

    Only for registered members

    · ...

    Toronto, ON $140,000 - $230,000 (CAD) per year

    1 week ago

Jobs
>
Toronto