Job ID: TX-52990000008089 (99390619)
Orion Rhapsody Admin with HL7, Oracle to SQL Server conversion, Visio, EHR, PHINMS, ETL, SNOMED, LOINC, ICD-9/10 and EIR accessibility experience
Location: Austin TX (HHSC)
Duration: 12 months
5 HL7 processing
5 MS SQL Server
5 MS Office Suite and Visio
5 Electronic Lab Results/Electronic Health Record Integration Architecture
5 Orion Health Rhapsody Administration and Route Development
3 ETL experience
2 SNOMED, LOINC, ICD-9, ICD-10
1 or more Understands Electronic Information Resources (EIR) accessibility and security requirements and their technical specifications. Ensures the EIR accessibility and security is integrated into the project lifecycle at the appropriate points (planning, design, development, test, etc.) and ensures that resources are included to implement EIR accessibility within the project.
The Database Administrators will perform advanced public health informatics assessments of disease surveillance systems to improve public health monitoring. Initiates, plans, directs, and coordinates the implementation of a Department electronic integrated surveillance system for reporting of diseases, including diseases reported to the Infectious Disease Control Unit. Applies principles of structured project management and follows the current department project management methods to execute the NEDSS project. Coordinates the development of NEDSS with Infectious Disease Prevention Section programs. Provides regular briefings on progress as requested by management. Works under minimal supervision in Infectious Disease Control Unit, with extensive latitude for initiative and independent judgement.
• Assesses and evaluates epidemiologic disease surveillance systems for technological improvements and develops and implements plans for Web-based electronic reporting systems compatible with NEDSS. Develops and implements data validation processes.
• Perform Oracle to SQL data conversion
• Ensures that data are efficiently and correctly collected, compiled, and analyzed.
• Oversees quality control procedures for data management.
• Conducts data analysis from disease surveillance systems, interprets results, and documents findings.
• Perform deep HL7 analysis on ELRs from hospitals/critical access care facilities in Texas and use informatics concepts needed to translate user requirements into acceptable HL7 standards for public health information systems consumption.
• Collaborate with facilities and laboratories for Electronic Laboratory Reporting (ELR) flow.
• Participate in the daily data mapping for healthcare interoperability standard codes.
• Provide user support for NEDSS and workflows – including troubleshooting and issue management (logging, sequence / escalation, and resolution).
• Assist onboarding of hospitals/facilities for new HL7-ORU-ELR requirements.
• Assist with various infectious disease program to develop various data value sets as required by the CDC.
• Participate in the planning, development, training, implementation, evaluation, and maintenance of the public health Information system NEDSS.
• Serve as a coordinator between epidemiologists, Public Health Informatics team and IT professionals to facilitate the adoption of new systems and adherence to all federal, state, local, and company guidelines.
Knowledge, Skills and Abilities:
• Knowledge of the principles and methods of epidemiology, especially disease risk measures for monitoring public health.
• Knowledge of the epidemiology of infectious diseases
• Knowledge of surveillance methodologies for infectious diseases
• Ability to plan, assign, and supervise the work of others; and plan and direct a disease electronic surveillance project.
• Ability to lead and manage a team project, coordinate with internal and external customers, and communicate effectively.
• Epidemiologic and biostatistical skill in data analysis, interpretation, and communication of findings.
• Knowledge and skill in using statistical software packages such as SPSS, SAS, STATA.
• Technical knowledge of the construction, function, and creation of database systems for epidemiology surveillance purposes.
• Knowledge of enterprise-wide IT systems design, implementation techniques, and structured management techniques
• Skill in using Microsoft Excel, Access and Word Conduct a detailed analysis of the current Rhapsody and NEDSS architecture to document and diagram business requirements, system process and information flows, to improve performance and increase the overall stability of Rhapsody, PHINMS and the NEDSS Ecosystem
• Plan and lead collaboration with IT, CDC and Business SMEs to document the Ecosystem routes and message paths
• Uses problem-solving and analytical skills to identify opportunities to automate current manual correction of data
• Identify and analyze routes, lookup tables, and data transformation within Rhapsody
• Support the NEDSS SQL database
• Perform Oracle to SQL data conversion
• Gather and analyze complex data and requirements
• Produce high quality business process documents
• Analyze and document the current case reports sending through ELR to the NEDSS Ecosystem to improve performance
• Works with IT, business users and leadership to help them understand the application functionality, development approaches, possible enhancements and process improvements for the NEDSS Ecosystem
• Review completed documentation and diagrams with IT, business SMEs and leadership