Data Engineer - Python, SQL at Astra-North Infoteck Inc. ~ Conquering Today’s Challenges, Achieving Tomorrow’s Vision!

• Job Location Toronto, Ontario, Canada
• Seniority Mid-Senior Level
• Type Full-time

Share on:

Description

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 strong Python and SQL expertise to build reliable, scalable data pipelines that transform semi‑structured data from ES URLs/APIs into clean, analytics‑ready datasets.

You will work primarily in a local environment (Python, DBeaver, SQLite/Postgres/Dremio), establish database connections, flatten and normalize JSON/Elasticsearch topics, and prepare datasets for downstream Power BI reporting.

This role requires deep hands‑on engineering ability, strong data modeling skills, and clear communication with business stakeholders.

Key Responsibilities 1.

Data Ingestion & Transformation Extract semi‑structured data from ES URLs, API endpoints, and Elasticsearch topics (JSON-based).

Flatten, normalize, and structure nested JSON into relational tables suitable for analytics.

Build reproducible ETL/ELT workflows using Python (pandas, NumPy, SQLAlchemy, requests).

Implement transformation logic, incremental loads, and schema alignment for downstream use.