Dataops Cloud Data Engineer 0454-2817

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Background Information

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. and nbsp;

Must haves:

5 years of experience in using SQL Database design and Python.

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 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.

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

Required skills:

Good documenting skills for technical approaches
Communicating effectively with stakeholders of varying technical expertise and
Applying modern data engineering practices to ensure consistency reliability and timely delivery of high-quality data assets.

Evaluation Criteria: and nbsp; and nbsp;

5 years of experience in using SQL Database design and Python. : 35 and nbsp;Points
Experience working with relational databases including writing SQL queries.: 35 and nbsp;Points
Communication and stakeholder engagement skills.: 20 and nbsp;Points
Experience applying modern data engineering practices.: 10 and nbsp;Points
Total evaluation criteria: 100 Points

Deliverables

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

Additional Terms

Term: and nbsp;The term of this Engagement Assignment is 252 Business Days with an option to extend for up to an additional 125 days at Ontario Healths discretion. and nbsp;

The resource will comply with Ontario Health policies and procedures.

Ontario Health systems cannot be accessed from outside the province of Ontario and Ontario Health assets including laptops and related equipment cannot be removed from the province of Ontario without prior written approval from Ontario Health.

Knowledge Transfer Details:

The resource will ensure full knowledge transfer is provided to the Ontario Health team before end of engagement. Some of this might occur at the end of the engagement but will also be shared as information is obtained/consolidated. Key deliverables will be shared with team.

The resource must provide all related documentation as part of knowledge transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director.

The resource will work collaboratively with the Ontario Health team throughout the assignment and ensure key deliverables milestones and documentation are shared.

A walkthrough of any demos development etc. will be required before the end of the engagement.

Background InformationSr. 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 coho...