RQ00454 - DataOps/Cloud Data Engineer - Senior

Source Code; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A provincial health agency is looking for a Senior DataOps/Cloud Data Engineer to develop and operationalize analytics-ready data products in a hybrid work environment. This role involves collaborating with analysts and data scientists while implementing secure data practices. Candidates should have over 5 years of experience in SQL, Database design, and Python, as well as knowledge in PowerBI. This position offers a 1-year contract starting January 2026 in Toronto, Ontario.

Qualifications

• 5+ years of experience in using SQL, Database design, and Python.
• 5+ years of experience with working knowledge of PowerBI.

Responsibilities

• Collaborate with analysts and data scientists to develop fit-for-purpose data products.
• Write and manage code for data masking and patient identification algorithms.
• Design and build analytics-ready data tables for specific use cases.

Skills

SQL

Database design

Python

PowerBI

Tools

SAS

Informatica ETL

Microsoft Azure

Job description

RQ00454 - DataOps/Cloud Data Engineer - Senior

Hybrid up to 2 days in office-525 University Avenue

1-year contract - Starting January 2026

1 Openings -1 Submission

Ontario Health - Strategy, Planning, Privacy & Analytics

Ontario Health requires a Sr. Data Engineer to develop and operationalize analytics-ready data products that support priority projects and system planning needs. The resource will collaborate with analysts, methodologists, and data scientists to design, build, and optimize datasetsensuring data masking, cohort logic, and patient identification approaches are implemented securely and accurately. The Data Engineer will work across diverse domain assets and data structures, adapt pipelines for performance and scalability, and partner with Data Architecture, ETL and IT Operations to move solutions from sandbox to production.

The resource will be critical to support the delivery of the successful design and implementation of the CCSO data collection, analysis and reporting activities within the Ontario Health analytic infrastructure; being transitioned from UHN and ultimately being retired within UHN.

Responsibilities

• Collaborate with analysts and data scientists to develop fit-for-purpose data products.
• Write and manage code for data masking, cohort creation, and patient identification algorithms.
• Design and build analytics-ready data tables for specific use cases.
• Optimize large datasets for performance processing and querying.
• Work with diverse domain data assets and formats.
• Partner with Data Architecture, ETL, and IT Operations to support sandboxes and operationalize data assets.
• Apply modern data engineering practices for consistency, scalability, and reliability.
• Communicate technical approaches and insights to stakeholders at all skill levels.
• Make sound decisions when navigating complex or ambiguous data engineering issues.

Deliverables Include, but are not limited to

• Reusable data transformation and data provisioning scripts
• Analytics-ready data and information assets
• Cohort creation and patient matching algorithms
• Optimized SQL views and performance-tuned data structures
• Technical documentation: data dictionaries, lineage diagrams, architecture notes, data information sheets, data and Information assets catalogue
• Environment setup, optimization and support
• Reports and presentations for technical and non-technical stakeholders

Must Haves

• 5+ years of experience in using SQL, Database design and Python.
• 5+ years of experience, with working knowledge of PowerBI

Nice to Have

• Public Sector Experience

Desired skills

• Familiarity with SAS and Informatica ETL tool
• Ontario Healthcare data privacy standards and policies
• Familiarity with Microsoft Azure product line
• Familiarity with Federal and provincial health care data