Talent.com
Spectrum Health Care
Data EngineerSpectrum Health Care • Toronto, Ontario, Canada
Data Engineer

Data Engineer

Spectrum Health Care • Toronto, Ontario, Canada
1 day 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.

Create a job alert for this search

Data Engineer • Toronto, Ontario, Canada

Similar jobs

Data Engineer

searchlabsmarkham, on, Canada
Full-time

This Data Engineer role is a one-year contract, working on a hybrid in-office/remote model in the GTA.The compensation range is $60-$100/hr.Build and maintain ETL pipelines for enterprise data inte... Show more

 • Promoted

Data Engineer I

TDToronto, ON, CA
Full-time

Work Location:Toronto, Ontario, CanadaHours:37.Line of Business:Technology SolutionsPay Details:$69,700 - $98,400 CADTD is committed to providing fair and equitable compensation opportunities to al... Show more

 • Promoted

AWS Databrciks Engineer

AkkodisToronto
Full-time

Toronto, ON Hybrid (3 days Onsite- Tue, Wed, Thursday).Citizens or PR only considered for the TCS role, sorry, OWP won't work.Design, develop, and maintain scalable and robust data pipelines on Dat... Show more

 • Promoted

Data Engineer

LeadingtalentMarkham, Ontario, Canada
Full-time

At IBM, work is more than a job – it’s a calling: To build.To think along with clients and sell.Not just to do something better, but to attempt things you’ve never thought possible.Are you ready to... Show more

 • Promoted

Data Engineer

TekStaff IT SolutionsToronto, ON, CA
Full-time

TekStaff's Client has a current vacancy for "Data Engineer".Typical Day-to-Day Responsibilities: Responsible for leading technical aspects of project from inception through to deployment.Participat... Show more

 • Promoted

AI-Focused Data Engineer Role

Drive CapitalToronto
Full-time

Impact the future of AI marketing at Yolando as a Data Engineer.This hybrid role involves developing ETL pipelines and managing real-time data solutions in a growing startup environment in Toronto.... Show more

 • Promoted

Principal Data Engineer with Tangerine

Scotiabanktoronto, on, Canada
Full-time

Join Tangerine as a Principal Data Engineer, playing a crucial role in enhancing our data platforms for AI and ML applications.Collaborate in a remote-friendly work setting focused on client servic... Show more

 • Promoted

Data Engineer & Analytics

Kredivo GroupMarkham, York Region, CA
Full-time

As a Data Engineer and Analytic you will be tasked with empowering internal stakeholders to delve deep into the complexities of the data in our warehouse.You will work closely with Product, Enginee... Show more

 • Promoted

Staff Data Engineer

Katalyze AI, Inc.Toronto, ON, CA
Full-time

Katalyze AI is a fast-growing AI-driven biotech platform company on a mission to make life-saving drugs accessible and affordable for everyone.Our AI Agents help pharmaceutical and biotech companie... Show more

 • Promoted

Data Engineer

Veeva Systems Inc.toronto, on, Canada
Full-time

We are looking for a talented and experienced data engineer to join our team.The ideal candidate will have a strong understanding of data engineering principles and practices, as well as experience... Show more

 • Promoted

Data Engineer

DS Technologies IncToronto, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.About US: We are a company that provides innovative, transformative IT services and solutions.We are passionate about helping our clien... Show more

 • Promoted

Data Engineer

VySystemsToronto
Full-time

At least 3 years of relevant professional experience.Background in one or more of the following: Database administration, Data Engineering, ETL loading and ingestion, data classification and normal... Show more

 • Promoted

Data Engineer - Snowflake

Tiger AnalyticsToronto, ON, CA
Full-time

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

 • Promoted

Data Engineer

Quantum Management Services Ltd.Toronto, ON, CA
Temporary

Quantum Management Services Ltd.North York, ON (Hybrid – on-site Monday‑Thursday).We are looking for a Data Engineer to support large‑scale retail and e‑commerce data initiatives, working with comp... Show more

 • Promoted

Data Engineer

LuxoftToronto, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Luxoft.You will work as a Data Engineer in Trading Technology, Public Market Investments team, partn... Show more

 • Promoted

Lead Data Engineer

RBCtoronto, on, Canada
Full-time

Are you a hands-on data platform engineer who thrives on building cloud-native, high-scale data platforms and enabling teams on top of them? Come join us!.Are you a hands-on data platform engineer ... Show more

 • Promoted

Data Engineer

Canadian Tire CorporationToronto, ON, CA
Full-time

Advanced Analytics team at Canadian Tire Corporation, your primary focus will be on ensuring the stability, reliability, and performance of ML models in production environments.Working closely with... Show more

 • Promoted

Data Engineer

Compunnel Inc.Markham, York Region, CA
Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Compunnel Inc.University degree in Computer Engineering or Computer Science.Solid grasp/experience w... Show more

 • Promoted

Advanced Data Engineer for Large Datasets and ETL Pipelines

LumenaltaToronto, ON, CA
Full-time

Transform data into insights as an Advanced Data Engineer specializing in complex ETL pipelines.Embrace this remote opportunity to use your Python or Java and SQL skills effectively.This role invit... Show more

 • Promoted

Data Engineer

University of TorontoGreater Toronto Area, ON, CA
Full-time +1

Press Tab to Move to Skip to Content Link.Select how often (in days) to receive an alert:.Ofc of Vice Pres, Research & Innovation.The Vice-President, Research & Innovation (VPRI) portfolio supports... Show more