Senior ETL Developer (Python)

Tri-global Solutions Group; Toronto; Hybrid; CAD 114,000 - 162,000; Full time

Job summary

Tri-global Solutions Group Inc. is seeking a Senior Software Developer/ETL to design, build, and maintain scalable data pipelines and integration components to support enterprise AI and analytics initiatives.

Hybrid work model with three days on-site at Toronto office and two days remote. The role requires strong Python and SQL skills, experience with ETL/ELT, cloud data platforms, and Azure, plus collaboration with data architects, ML engineers, and stakeholders to deliver production-grade data

Qualifications

• Experience building scalable, production data pipelines for AI/ML workloads.
• Advanced Python, SQL, ETL/ELT and cloud data platform skills.
• Strong Azure data/AI knowledge including ML pipelines and monitoring.

Responsibilities

• Design, develop, test, and maintain ETL/ELT pipelines and data integration solutions.
• Build reusable data pipelines and integration components for AI and analytics use cases.
• Ingest, transform, and prepare data for analytics, AI, and ML workloads.

Skills

Python

SQL

ETL/ELT

Data integration

Azure

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

SQL Server

Python ecosystem

Job description

SENIOR SOFTWARE DEVELOPER/ETL (Azure & Python; Enterprise AI & Data Centre of Excellence)

Requisition #: R26-3629 (RQ00241)

Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON - *See Work Model)

Engagement Type: Contract

Number of Resources required: 1

Term: 2026-11-23 to 2027-05-23 (130 days) with possible extension

Rate (CAD): Up to $100.00 per hour / Commensurate with related experience and market competitiveness

Hours per day: 7.25

Security Screening: Standard (Criminal Record Check)

Tri-global Solutions Group Inc. is seeking one (1) Senior Software Developer/ETL to join our talented Service Delivery team within Metrolinx.

WORK MODEL: The successful contractor will be working hybrid with 3 days in office at 277 Front Street West, Toronto, Ontario and 2 days remote/work from home per week.

Tri-global Solutions Group Inc.

Website: https://tri-global.com

PROJECT OVERVIEW

The Senior Software Developer-ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives.

The role will help improve access to trusted data across enterprise systems, operationalize data architecture and integration patterns, and reduce the time and effort required to onboard data for new AI and analytics use cases.

DESCRIPTION OF SERVICES

• Design, develop, test, and maintain ETL/ELT pipelines and data integration solutions across enterprise data sources.
• Build reusable data pipelines, services, and integration components that can support multiple AI and analytics use cases.
• Ingest, transform, and prepare structured and unstructured data for analytics, AI, and machine learning workloads.
• Implement data architecture, modelling, and integration patterns established by enterprise architecture.
• Integrate data across cloud platforms, databases, applications, APIs, and enterprise systems.
• Design solutions that support scalability, reliability, performance, monitoring, and maintainability.
• Implement data quality and validation controls to improve the reliability of data provided to downstream consumers.
• Work with Data Architects, AI/ML Engineers, Data Scientists, product teams, and business stakeholders to translate data requirements into production-ready solutions.
• Optimize existing pipelines and integration processes to reduce duplication and accelerate onboarding of new data sources.
• Support deployment, troubleshooting, documentation, and ongoing improvement of enterprise data solutions.

QUALIFICATIONS & EXPERIENCE

• Degree in Computer Science, Information Systems, Engineering, Data/Analytics, or a related discipline, or equivalent experience.
• Significant experience in data engineering, ETL/ELT development, software development, or enterprise data integration.
• Demonstrated experience designing and developing scalable data pipelines and integration solutions.
• Strong programming and SQL skills, with experience working with modern data engineering frameworks and cloud-based data platforms.
• Experience integrating data through databases, APIs, file-based sources, and enterprise applications.
• Knowledge of data modelling, data quality, metadata, lineage, security, and data governance concepts.
• Experience supporting data platforms used for AI, machine learning, advanced analytics, and business intelligence.
• Strong analytical, troubleshooting, communication, and collaboration skills.

MANDATORY REQUIREMENTS (Candidates must meet all requirements below)

• Significant hands-on experience designing and developing scalable, production-grade data pipelines for AI/ML and Generative AI workloads, including data ingestion, transformation, feature engineering, training and inference datasets, RAG/grounding data, and AI/ML pipeline integration.
• Advanced hands-on expertise in Python, SQL, ETL/ELT, APIs, data integration and transformation, and cloud-based data platforms, applying strong software engineering practices to build reliable, scalable, maintainable, and production-ready data solutions.
• Strong working knowledge of the Azure data and AI ecosystem, Azure Machine Learning, and Microsoft Foundry/Azure AI Foundry, with an understanding of ML pipelines, feature engineering, model training/testing, inference, monitoring, and the data requirements needed to support reliable enterprise AI/ML solutions.

NOT FOR YOU?

Check out our other opportunities at https://tri-global.com or follow us on LinkedIn. We thank all candidates in advance. Only candidates selected for an interview will be contacted.

WHY WORK WITH TRI-GLOBAL?

• Empower positive change by enabling our clients to revolutionize innovation and technology, elevating them to a higher level of excellence and efficiency.
• Join an exceptional and committed team that redefines the landscape, forging a distinctive path towards success.
• Engage in stimulating and captivating projects that push boundaries and keep you constantly motivated.