RQ00241 – Software Developer – ETL – Senior

S M Software Solutions Inc

Toronto

Hybrid

CAD 110,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Metrolinx seeks a Senior Software Developer – ETL to design, build, and maintain scalable data pipelines and reusable data services for enterprise AI, analytics, and data initiatives. The role emphasizes data quality, scalability, and reliability across AI/ML workloads.

You will work with Data Architects, AI/ML Engineers, Data Scientists, and product teams to translate requirements into production-ready solutions, ensuring efficient onboarding of new data sources and integration across cloud

Qualifications

  • Significant hands-on experience designing scalable, production-grade data pipelines for AI/ML workloads.
  • Strong Python, SQL, ETL/ELT, APIs, data integration, and cloud-based data platforms.

Responsibilities

  • Design, develop, test, and maintain ETL/ELT pipelines and data integration solutions across enterprise data sources.
  • Build reusable data pipelines and integration components for multiple AI and analytics use cases.
  • Ingest, transform, and prepare structured and unstructured data for analytics, AI, and ML 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 ensure scalability, reliability, performance, monitoring, and maintainability.
  • Implement data quality and validation controls to improve data reliability for downstream consumers.
  • Collaborate with Data Architects, AI/ML Engineers, Data Scientists, product teams, and stakeholders to translate data requirements into production-ready solutions.

Skills

Python
SQL
ETL/ELT
APIs
Data integration
Cloud platforms
Azure ML
ML pipelines

Education

Bachelor's degree in CS/Engineering or related field

Job description

Client: Metrolinx – RQ00241

We are seeking a Senior Software Developer – ETL with significant hands‑on experience in designing, developing, and maintaining scalable, production‑grade data pipelines and integration solutions. The ideal candidate will have strong expertise in Python, SQL, ETL/ELT, APIs, data integration, data transformation, and cloud‑based data platforms, along with a strong understanding of the Azure data and AI ecosystem, Azure Machine Learning, and Microsoft Foundry/Azure AI Foundry. The successful candidate will build reusable data services and pipelines to support enterprise AI, Machine Learning, Generative AI, analytics, and data initiatives while ensuring data quality, scalability, reliability, and performance.

Role Snapshot
  • Job Title: RQ00241 – Software Developer – ETL – Senior
  • Client: Metrolinx
  • Work Location: 277 Front Street West, Toronto, Ontario, Canada
  • Work Arrangement: Hybrid – 3 Days per Week Onsite
  • Estimated Start Date: November 23, 2026
  • Estimated End Date: May 23, 2027
  • Business Days: 130.00
  • Hours: 7.25 hours per day
Must Have
  • 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.
Description

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.

Key Responsibilities
  • 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.
Additional Information
  • Work Arrangement: Hybrid – 3 days a week onsite.
  • Public Sector Experience: Preferred but not required.
WhatsApp Group

For daily job updates, you can also join our WhatsApp group using the link below:

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Developer - ETL
Software Developer - ETL

Altis • Toronto

Hybrid
CAD 96,000 - 152,000
Senior ETL Developer (Python)
Senior ETL Developer (Python)

Tri-global Solutions Group Inc. • Toronto

Hybrid
CAD 114,000 - 162,000
RQ00245 – Machine Learning Engineer – Senior
RQ00245 – Machine Learning Engineer – Senior

S M Software Solutions Inc • Toronto

Hybrid
CAD 110,000 - 160,000
RQ09315 - Software Developer - ETL - Senior
RQ09315 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
RQ09197 - Software Developer - ETL - Senior
RQ09197 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 100,000
Senior GenAI Developer (Azure)
Senior GenAI Developer (Azure)

Tri-global Solutions Group Inc. • Toronto

Hybrid
CAD 91,000 - 129,000
Senior Data Scientist (Azure ML)
Senior Data Scientist (Azure ML)

Tri-global Solutions Group Inc. • Toronto

Hybrid
CAD 91,000 - 129,000
Senior Data Engineer
Senior Data Engineer

Cpus Engineering Staffing Solutions Inc. • Pickering

Hybrid
CAD 90,000 - 120,000
Data Analytics Lead
Data Analytics Lead

Altis • Markham

Hybrid
CAD 100,000 - 150,000
Hybrid work
Career growth
Impactful projects
+1
RQ07956 - Sr Software Developer - ETL
RQ07956 - Sr Software Developer - ETL

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000