Talent.com

Data warehouse engineer Jobs in Toronto, ON

Create a job alert for this search

Data warehouse engineer • toronto on

Last updated: 2 days ago

Data Engineer

Spectrum Health CareToronto, Ontario, Canada
CA$95,000.00 yearly
Full-time

Design, deploy and maintain a centralized Azure ADLS Gen2/Databricks/Synapse (or Snowflake) data lake that serves as the single source of truth.Create batch & real‑time ETL/ELT flows (Azure Eve... Show more

Jr Data Engineer

CityliticsToronto, ON, CA
Full-time
Quick Apply

Citylitics delivers predictive intelligence on where, how, and why infrastructure investments will occur across North America.Infrastructure includes the foundational systems that shape our quality... Show more

Director, Data Engineer

Royal Bank of Canada>TORONTO, Canada
Full-time

In addition to leading core data capabilities, this role will act as a.This leader will define and execute the.This will give you the following.Partner with business, analytics, risk, and technolog... Show more

Data Engineer

Game HiveToronto, ON, Canada
[filters.currency_variable_a_yearly]

This job is currently not accepting applicants. Show more

Data Engineer

Odaia Intelligence Inc.Toronto, ON, CA
Full-time
Quick Apply

Data Engineer  ABOUT ODAIA ODAIA noun o·da·ia | 'oh-day-yeah An Ancient Greek word referring to "ōdē", the word for song, and the root of melody, harmony, and orchestra.We ... Show more

Data Engineer

Tiger Analytics Inc.Toronto, ON, CA
Remote
Full-time
Quick Apply

Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI.We are the trusted analytics partner for several F... Show more

Data Warehouse Software Developer II

Randstad CanadaToronto, Ontario, CA
Permanent +1
Quick Apply

We are seeking a detail-oriented Data Warehouse Software Developer II to support and enhance an enterprise-level Data Warehouse environment.In this role, you will be responsible for maintaining rob... Show more

Data Engineer

FinanceitToronto, ON, CA
CA$75,000.00 yearly
Full-time
Quick Apply

Financeit is a point-of-sale financing provider serving some of the largest home improvement and retail organizations in Canada.Our platform helps businesses close more sales by offering customers ... Show more

Data Engineer

Lorven technologiesToronto, ON, Canada
Full-time +3
Quick Apply

Position: Data Engineer </b></p> <p style="text-align:justify"><b>Location: Toronto (Onsite) possible F2F Interview</b></p> <p style="text-alig... Show more

Data & Analytics Engineer

ProphixEtobicoke, ON, CA
CA$100,000.00 yearly
Full-time
Quick Apply

See what you can do with Prophix.At Prophix, we’re building the platform that helps finance teams stop managing spreadsheets and start driving strategy.Prophix One™ brings planning, reporting, cons... Show more

Data Engineer

Motion RecruitmentToronto, ON, Canada
Full-time

Located in Toronto, ON (fully onsite), this opportunity is with a fast-growing data and technology-focused organization helping businesses better leverage their data.They are hiring a full-time Dat... Show more

Data Engineer

SuiteSpotToronto, ON, CA
Full-time
Quick Apply

Who We Are SuiteSpot is a PropTech company transforming how residential real estate is managed and operated at scale.Our award-winning Maintenance and Capital SaaS solutions serve the top 50 multif... Show more

Lead Data Engineer

eTeamToronto, ON
Full-time

Strong experience in Change Data Capture (CDC) using tools like Debezium and handling file-based ingestion (CSV).Hands-on experience with GCP technologies including Pub/Sub, Dataflow (Apache Beam),... Show more

ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation

Astra North Infoteck Inc.Toronto, ON, ca
Full-time

ETL Data Tester – ETL Testing, Data Warehouse, SQL, UNIX/Linux, Informatica.Perform end-to-end testing of ETL processes, data pipelines, and Data Warehouse solutions.Validate source-to-target data ... Show more

Data Engineer

J M Group IncToronto, ON, Canada
Full-time
Quick Apply

We're looking for a Data Engineer with strong Python and SQL Server expertise to build and maintain ETL pipelines and reporting solutions for a major Canadian bank in downtown Toronto.The idea... Show more

Data Engineer

ManulifeToronto, Ontario
Full-time

Join us at Manulife and be part of a team that strives for excellence, where your efforts will directly contribute to our success.Here, your work will have an important impact, and you’ll be empowe... Show more

People also ask
Data Engineer

Data Engineer

Spectrum Health CareToronto, Ontario, Canada
2 days ago
Salary
CA$95,000.00 yearly
Job type
  • Full-time
Job description

Job Description

  • Design, deploy and maintain a centralized Azure ADLS Gen2/Databricks/Synapse (or Snowflake) data lake that serves as the single source of truth
  • Create batch & real‑time ETL/ELT flows (Azure Event Hubs, Kafka, Spark Streaming) to ingest EHR data and operational telemetry
  • Write and run complex migration scripts using Informatica PowerCenter/IDMC or Azure Data Factory to move data from Epic, other EHRs and legacy OLTP stores into the lakehouse and Salesforce Health Cloud
  • Build automated validation, deduplication, masking, encryption and column‑level security to guarantee 100% integrity and PHI compliance
  • Build high‑throughput pipelines (SOQL, Bulk API 2.0, Informatica, MuleSoft, dbt, Python) that sync Health Cloud data with the central repository
  • Transform HL7, FHIR and EDI messages into clean canonical schemas for storage and analytics
  • Design Robust Data Models – Perform ER/3NF modeling for OLTP and dimensional (star/snowflake/medallion) modeling for OLAP analytics


Qualifications

  • Bachelor’s degree in Computer Science, Software Engineering, Data Analytics, or a related technical field
  • Experience: 3-7 years of hands-on data engineering experience, with a proven track record of executing complex data migration projects and building cloud data lake architectures.
  • Expertise in ER (Entity-Relationship) diagramming, relational database modeling (3NF for OLTP), and dimensional modeling (Star Schema, Snowflake, Medallion) for OLAP systems
  • Experience with enterprise ETL platforms such as Informatica (Informatica PowerCenter / IDMC), Azure Data Factory, SSIS, or Talend for legacy data extraction and transformation
  • Experience with cloud data architectures (Azure data services: Azure Data Factory, ADLS Gen2, Azure Synapse, Databricks) and familiarity with streaming/real-time pipelines (Event Hubs, Kafka, Spark Streaming)
  • Experience working with Salesforce data structures, SOQL, Salesforce Bulk API, and data loading tools (e.g.,Informatica Salesforce Data Loader, MuleSoft, Fivetran, dbt, or custom Python scripts)
  • Expert-level SQL skills (complex joins, CTEs, window functions, schema design, index tuning, and database optimization)
  • Strong Python skills for data manipulation, scripting, and pipeline execution using libraries like Pandas, PySpark, and SQLAlchemy
  • Compensation is based on experience (Annual salary range $95,000 - $105, 000)

#corp_IT



Additional Information

This position is a current vacancy

Spectrum Health Care is thrilled to be named one of Canada’s Best Managed Companies. This award recognizes top companies across Canada for overall performance, sustained growth, strategy, capabilities and innovation, culture and commitment, and leadership. Click here to learn more about this esteemed honour.

We thank all applicants, however, only those individuals selected for interviews will be contacted.

In accordance with the Accessibility for Ontarians with Disabilities Act 2005, upon request, support will be provided for accommodations throughout the recruitment process.

If you require accommodation because of disability through the recruitment process, please contact Human Resources at (corphr@spectrumhealthcare.com) for assistance.

Spectrum Health Care is committed to fostering, cultivating and building a culture of diversity, equity and inclusion within our organization. We strive to attract, engage and develop a workforce that reflects the diverse communities that we serve and we know a diverse workforce is key to the growth and success of our organization.