RQ00486 - Specialized IT Consultant - Senior

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:  

• 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 Points
  
• Minimum 5 years' experience working with ETL processes and remediation. 20 Points
  
• Excellent communication skills, written and verbal (articulate, detail oriented and factual) and interpersonal (clarifying, active listening), manage conflict or stressful situations 20 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 Points
  
• Proven track record working with a broad range of stakeholder including health care professionals and clinicians 10 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 
  
• Support the reporting for EHR audits 
  
• 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 
  
• Support CDC and DataStage upgrade
  
• Support of Cloverleaf monitoring for hospital ADT submissions   
  
• Establish process and procedure for capture, review and mediate application or interface errors
  

Must Haves: 

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