ZipRecruiter

Log In

1

Extract Transfer Load Data Jobs in Toronto, ON (NOW HIRING)

Td

IT Data Specialist

Toronto, ON · On-site

CA$96K - CA$136K/yr

Design and implement complex ETL frameworks to provide a solution that meets business requirements ... Deliver Business or Enterprise Data deliverables for the various related platforms/servers ...

Td

Data Engineer II

Toronto, ON · On-site

CA$81K - CA$115K/yr

Develop and maintain complex ETL jobs and frameworks using the Bank's standard tools * Provide support to the development and testing teams to resolve data issues, including escalation support on ...

Hire DigITalent

Data Engineering Lead

Toronto, ON

Lead the design, operation, and optimization of scalable ETL/ELT pipelines and orchestration workflows. Define and maintain data architecture, modeling standards, governance, and data lineage ...

Scotiabank

Programmer Analyst Advisory

Toronto, ON · On-site

Leads the ETL development functions for all projects/clients * Design, develop, and maintain scalable ETL solutions using Talend Data Integration as well as other ETL technologies to support ...

Scotiabank

Data Engineer

Toronto, ON · On-site

Develop and enhance ETL/ELT workflows using Airflow and ETL tools such as Talend, Spring Batch, or NiFi. * Work with structured and semistructured data (CSV, JSON, XML, Parquet, ORC, Iceberg) and ...

Capco

Senior DataStage Developer

Toronto, ON · On-site +1

Drive enterprise-scale data transformation by delivering high-performance ETL solutions for a major financial services platform migration. The Role We are seeking an experienced Senior IBM InfoSphere ...

Royal Bank of Canada

System Engineer

Toronto, ON

... Data ETL, Data Warehousing (DW), Defects Management, Defect Triage, DevOps, ETL Processing, GitHub, GitHub Actions, GitHub Copilot, Linux, Machine Learning (ML), Microsoft Copilot, Python ...

Scotiabank

Associate Data Engineer

Toronto, ON · On-site

Troubleshoot and resolve production incidents, ETL failures, and data issues by working closely with development and support teams to restore service quickly and prevent recurrence. * Manage ...

IKO Industries, Inc

Data Engineer Co-Op

Mississauga, ON · On-site

A foundational knowledge of SQL and ETL tools (e.g., Azure Data Factory, Databricks, SSIS, Talend, etc.). * Experience in data transformation, integration (cloud-based solutions), and the Microsoft ...

previous page

Showing results 41-60

All JobsExtract Transfer Load Data JobsExtract Transfer Load Data Jobs in Toronto, ON

Extract Transfer Load Data information

What is the difference between Extract Transfer Load Data vs Data Analyst?

AspectExtract Transfer Load DataData Analyst
Primary RoleExtracts, transforms, and loads data for systems or databasesAnalyzes data to generate insights and reports
Skills & CertificationsSQL, ETL tools, data management certificationsSQL, data visualization, statistical analysis
Work EnvironmentData warehouses, ETL pipelines, IT departmentsBusiness intelligence, analytics teams, offices
Industry UsageData integration, database managementBusiness analysis, decision-making

While both roles involve working with data, Extract Transfer Load Data focuses on data extraction, transformation, and loading processes, often in IT or database environments. Data Analysts interpret data to provide insights and support business decisions. Understanding these differences helps clarify career paths and job expectations in data-related fields.

What are popular job titles related to Extract Transfer Load Data jobs in Toronto, ON?

For Extract Transfer Load Data jobs in Toronto, ON, the most frequently searched job titles are:

What job categories do people searching Extract Transfer Load Data jobs in Toronto, ON look for?

The top searched job categories for Extract Transfer Load Data jobs in Toronto, ON are:

Extract Transfer Load Data jobs near you
Infographic showing various Extract Transfer Load Data job openings in Toronto, ON as of June 2026, with employment types broken down into 13% Full Time, 67% Part Time, 3% Temporary, and 17% Contract. Highlights an 92% Physical, 4% Hybrid, and 4% Remote job distribution.

RQ00734 - Business Intelligence Specialist - Senior

Source Code

Toronto, ON • Hybrid

Contractor

Posted 19 days ago

Job description

RQ00734 - Business Intelligence Specialist - Senior

7+ month contract (164 business days) - possible extension

Hybrid (onsite as needed) - 525 University Avenue

Must Haves:

  • Experience developing ETL and ELT processes using Python and AWS Glue.
  • Experience developing SQL for Amazon Redshift and relational databases.
  • Experience integrating data from REST APIs, databases, cloud platforms, and enterprise applications.
  • Experience with AWS analytics services including Redshift, Glue, S3, Athena, and CloudWatch.
  • Experience integrating healthcare data using FHIR, HL7 v2, Smile CDR, AWS HealthLake, and healthcare APIs.
  • Experience implementing secure data access using IAM, OAuth2/OIDC, and role-based security.
  • Strong SQL, data modelling, analytics, and performance optimization experience.
  • Experience evaluating AI accuracy, hallucination reduction, grounding, and response quality.
  • Experience with Pexip and Zoom APIs and data structures
  • Experience with NetIQ IAM APIs and data structures
  • Public Sector experience

Description:

The Agency is expanding the Provincial Health Services Directory (PHSD) to incorporate artificial intelligence capabilities that improve provider discovery, referral quality, and healthcare navigation across provincial digital health applications. The solution will utilize PHSD provider, practitioner, organization, healthcare service, specialty, location, and service metadata together with clinical referral context to provide intelligent recommendations while maintaining traceability to authoritative source data. AI agents will consume PHSD FHIR APIs, Smile CDR, AWS HealthLake, the Agency Master Data Management, and other provincial digital health assets to provide grounded responses rather than generative opinions. The project includes development of reusable AI services, MCP servers, semantic search capabilities, vector-based retrieval, prompt orchestration, evaluation frameworks, and secure integration with SMART on FHIR applications and provincial healthcare systems. The implementation will emphasize explainability, auditability, privacy, security, and clinical confidence while supporting future AI-enabled healthcare workflows across the Agency.

Responsibilities:

  • Design, develop, and maintain enterprise Power BI dashboards supporting operational, executive, clinical, and business reporting.
  • Develop AI-assisted dashboards utilizing Power BI Copilot, natural language queries, AI visualizations, forecasting, anomaly detection, and intelligent insights where appropriate.
  • Design and implement enterprise data warehouse solutions using Amazon Redshift.
  • Develop dimensional star schemas, fact tables, dimension tables, and semantic models supporting enterprise reporting.
  • Develop AWS Glue ETL pipelines using Python to ingest, transform, validate, and load data into Amazon Redshift.
  • Develop automated data ingestion processes from NetIQ IAM, Pexip, Zoom, Smile CDR, AWS HealthLake, Provider Registry, Master Data Management, PHSD operational databases, application logs, and other provincial digital health assets.
  • Develop data quality validation, cleansing, reconciliation, and governance processes supporting analytics accuracy.
  • Optimize Redshift performance, partitioning, indexing strategies, query execution, and warehouse scalability.
  • Develop operational KPIs, healthcare utilization metrics, provider activity reports, referral analytics, platform adoption reporting, and executive dashboards.
  • Collaborate with business stakeholders to gather reporting requirements and develop meaningful analytics solutions.
  • Develop deployment pipelines, documentation, operational procedures, and knowledge transfer materials.
  • Support production implementation, troubleshooting, report optimization, and ongoing analytics enhancements.

Desired Skills:

  • Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  • Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  • ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  • Advanced SQL development, query optimization, and performance tuning.
  • Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  • Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  • AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  • AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  • Python Glue shell experience
  • Experience with Pexip and Zoom APIs, extracting data for analytics
  • Data quality management, governance, reconciliation, validation, and operational reporting.
  • Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

Required Skills:

  • Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  • Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  • ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  • Advanced SQL development, query optimization, and performance tuning.
  • Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  • Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  • AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  • AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  • Data quality management, governance, reconciliation, validation, and operational reporting.
  • Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

  • $89.31/hr - $107.17/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $71.45/hr - $85.74/hr T4