Data Management Consultant 0486-2217

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 18 hours ago

Vacancies: 1 Vacancy

Job Summary

HM Note: This hybrid contract role is three (3) days in office. Candidate resumes must include first and last name email and telephone contact information. This role starts March 2 2026

Description

Background Information:

The registries are key elements of providing access to the Electronic Health Record (EHR). and nbsp;The Provincial Client Registry (PCR) is responsible for the unique identification of individuals who receive care in Ontario. and nbsp;It combines information from the Ministry of Health (MOH) Registered Persons Data Base (RPDB) and contributing sources reflecting over 150 hospitals and health regions across Ontario. and nbsp; and nbsp;
The PCR leverages the IBM InfoSphere Master Data Management (formerly Initiate software) technology to provide a consistent approach for client identity management at Ontario Health to deliver high quality information for stakeholders and the EHR. and nbsp;It also provides a consistent set of real-life identifiers that can be used to link health information records across sources within the EHR.
The Provincial Provider Registry (PPR) provides a similar function for the care providers and organizations. and nbsp;It leverages information from the Ministry of Health (MOH) Corporate Provider Database (CPDB) and regulatory colleges in Ontario. and nbsp;It allows for the accurate identification of provider persons that practice in multiple locations and maintain multiple credentials (licenses certifications etc.).

and nbsp;Must haves:

Strong understanding of Master Data Management processes and principles
Experience with IBM InfoSphere Master Data Management Identity Hub Standard Edition (formerly Initiate) version 11
Excellent knowledge of IBM WebSphere Application Server (WAS)
Practical experience with HL7 messaging Cloverleaf integration suite and IBM InfoSphere DataStage
Experience with SQL programming in relational databases
Knowledge of ETL processes
and nbsp;A strong knowledge of health care systems
Strong understanding of Software Development Life Cycle (SDLC) Quality Assurance requirements and software
Development control and release procedures
Experience with distributed messaging and streaming data solutions (e.g. Kafka)
Experience with container-based development (e.g. Docker Kubernetes OpenShift)
Extensive experience in troubleshooting and remediation

Responsibilities:

Support the documentation of ETL processes and documentation
Update the custom HL7v2 PubSub Service to alert subscribers to changes in the Service Catalogue
PPR performance improvements to response time and capacity
Documentation of the developed solutions including developers guide build book deployment guide and support procedures
Develop a health check to validate PPR services that can be automated and run by Ontario Health Technical Operations Centre
Establish process and procedure for capture review and mediate application or interface errors
Develop Publish/Subscribe capabilities to notify consuming systems of data changes in PPR leveraging Apache Kafka
Consultant will require access to PHI to support registries database
Provide application support as required

and nbsp;Desired Skills:

Working with others to share expertise and achieve outcomes that benefit the organization demonstrating strong communication skills to others on the team through active listening summarizing and facilitating. Articulates approach in succinct manner.
Ensures the timely delivery of support effectively adapting to tight deadlines and sudden changes in priorities to accomplish objectives. Plans for possibilities and contingencies identifying opportunities and problems to ensure that best results are achieved. Recognizes and makes best use of the diverse skills abilities experiences of team members to achieve best outcomes.
Demonstrating the unique skills required of the job; staying current with changing job skills to positively impact operational efficiency and the effectiveness of services provided. Insight of the Provincial Registries is an asset.

Required Experience / Evaluation Criteria: and nbsp; and nbsp;

Minimum 5 years experience with IBM InfoSphere Master Data Management. Standard edition experience preferred. 20 Points
Minimum 5 years experience integrating system and supporting web services. 20 and nbsp;Points
Minimum 5 years experience working with ETL processes and remediation. 20 and nbsp;Points
Excellent communication skills written and verbal (articulate detail oriented and factual) and interpersonal (clarifying active listening) manage conflict or stressful situations 20 and nbsp;Points
Experience working collaboratively with business partners and stakeholders to understand and analyze current state provide recommended approach and develop factual and concise deliverables 10 and nbsp;Points
Proven track record working with a broad range of stakeholder including health care professionals and clinicians 10 and nbsp;Points

Total Evaluation Criteria: 100 Points

Deliverables

The resource will support the continuous improvement including automation of maintenance tasks such as database archiving or partitioning of large tables to manage performance and response times including but not limited to:
Support Consent Management Technology Asset (CMTA) upgrade project
Update CMTA HIPAAT to a current version
Updates to CMTA ONE ID integration
Support deployments in all necessary environments and nbsp;
Support the reporting for EHR audits and nbsp;
Completion of the CMTA upgrade will allow for additional domains to be added (including acCDR) and to allow for Consent Overrides via the PCOI application. This will also support the Consent Harmonization work including: Override Duration Removal of Wet Signature Consent Granularity Consistency
Completion of the CMTA Upgrade will allow for additional domains to be added (including acCDR)
Completion of the common interface to provide a consistent interface between MDM and FHIR interfaces
Support Provincial Provider Registry (PPR) deliverables
Add data validation rules to the common interface
Update error handling to enhance messages and establish common error responses (e.g. change error code for a member not found response from http 500 error to an Ontario Health agreed upon alternative)
Documentation of the developed solutions including developers guide build book deployment guide and support procedures
Support Provincial Client Registry (PCR) deliverables
Monitoring of the Register Persons Database (RPBD) and Corporate Provider Database (CPDB) data contributions and nbsp;
Support CDC and DataStage upgrade
Support of Cloverleaf monitoring for hospital ADT submissions and nbsp; and nbsp; and nbsp;
Establish process and procedure for capture review and mediate application or interface errors and nbsp; and nbsp;

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.

and nbsp;Must Haves: and nbsp; and nbsp;

5 and nbsp;years experience and nbsp;Strong understanding of Master Data Management processes and principles and nbsp;
5 and nbsp;years experience and nbsp;with IBM and nbsp;InfoSphere and nbsp;Master Data Management Identity Hub Standard Edition (formerly Initiate) version 11 and nbsp;
and nbsp;5 and nbsp;years experience and nbsp;with HL7 messaging Cloverleaf integration suite and IBM and nbsp;InfoSphere and nbsp;DataStage and nbsp;
and nbsp;5 and nbsp;years experience and nbsp;with SQL programming in relational databases and nbsp;

HM Note: This hybrid contract role is three (3) days in office. Candidate resumes must include first and last name email and telephone contact information. This role starts March 2 2026DescriptionBackground Information:The registries are key elements of providing access to the Electronic Health Reco...