Data Engineer - Build Pipelines & Analytics-Ready Datasets

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

A leading tech firm in Toronto seeks a highly skilled Data Engineer to build reliable, scalable data pipelines transforming semi-structured data into analytics-ready datasets. Candidates should have strong expertise in Python and SQL, along with 6-8 years of experience. The successful applicant will also design and maintain database schemas, establish data quality and governance, and prepare datasets for Power BI dashboards in a collaborative environment.

Qualifications

• 6–8 years of experience as a Data Engineer or similar role.
• Deep hands‑on engineering ability in Python and SQL.
• Strong data modeling skills with clear communication.

Responsibilities

• Build reliable, scalable data pipelines from semi‑structured data.
• Design and maintain database schemas in SQLite, Postgres, and Dremio.
• Establish dataset versioning, lineage tracking, and data contract/documentation.
• Prepare clean datasets for Power BI dashboards and reporting.

Skills

Python

SQL

Data Modeling

ETL/ELT

DBeaver

SQLite/Postgres/Dremio

API Integration

Job description

A leading tech firm in Toronto seeks a highly skilled Data Engineer to build reliable, scalable data pipelines transforming semi-structured data into analytics-ready datasets. Candidates should have strong expertise in Python and SQL, along with 6-8 years of experience. The successful applicant will also design and maintain database schemas, establish data quality and governance, and prepare datasets for Power BI dashboards in a collaborative environment.