Specialized IT Consultant Senior

Must Haves:

• 5years experienceStrong understanding of Master Data Management processes and principles
• 5years experiencewith IBMInfoSphereMaster Data Management Identity Hub Standard Edition (formerly Initiate) version 11
• 5years experiencewith HL7 messaging Cloverleaf integration suite and IBMInfoSphereDataStage
• 5years experiencewith SQL programming in relational databases

Background Information:

The registries are key elements of providing access to the Electronic Health Record (EHR).The Provincial Client Registry (PCR) is responsible for the unique identification of individuals who receive care in 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.

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 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 leverages information from the Ministry of Health (MOH) Corporate Provider Database (CPDB) and regulatory colleges in allows for the accurate identification of provider persons that practice in multiple locations and maintain multiple credentials (licenses certifications etc.).

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

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

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:

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

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

o Update CMTA HIPAAT to a current version

o Updates to CMTA ONE ID integration

o Support deployments in all necessary environments

o Support the reporting for EHR audits

o 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

o Completion of the CMTA Upgrade will allow for additional domains to be added (including acCDR)

o Completion of the common interface to provide a consistent interface between MDM and FHIR interfaces

Support Provincial Provider Registry (PPR) deliverables

o Add data validation rules to the common interface

o 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)

o Documentation of the developed solutions including developers guide build book deployment guide and support procedures

Support Provincial Client Registry (PCR) deliverables

o Monitoring of the Register Persons Database (RPBD) and Corporate Provider Database (CPDB) data contributions

o Support CDC and DataStage upgrade

o Support of Cloverleaf monitoring for hospital ADT submissions

Establish process and procedure for capture review and mediate application or interface errors