Epic Dba Jobs (NOW HIRING)

Department Overview

The mission of the Information Technology Group (ITG) is to develop, implement and maintain technology-based services and solutions which enable OHSU to effectively manage information.

The Healthcare Technical Services (HCTS) group provides technical solutions for the Healthcare Application Management Division (HAMD) through system-to-system integration using HL7 and other interface protocols. The HCTS group also provides system technical support, application technical support, network integration, managing software installation and updates, and web application development.

Function/Duties of Position

Business Analysis

• Work with database administrators, ITG support staff, management and Healthcare Vendors to perform detailed workflow analysis to develop system-to-system interface specifications.
• Work with customers, vendors and ITG to identify hardware and software resources required to implement system-to-system interfaces.
• Meet with customers on a regular basis to review specifications and prioritize interfaces.
• Develop, coordinate and perform training for customers on new or modified systems.
• Train OHSU Hospital staff or designated trainers to use new or modified systems and to instruct on various application features.

• Working with hospital department directors, managers, line staff, ITG support staff, and Healthcare Vendors, perform detailed workflow analysis to develop detailed legacy data conversion specifications.

• Work with customers, vendors and ITG to identify hardware and software resources required for data conversion into the Epic database.

Systems Engineering and Analysis

• Author and maintain an interface design guide. Train interface developers in the use of the design guide to ensure standard of use, maintainability, accuracy, security, performance, and supportability of system-to-system interfaces. Perform code review to ensure all interfaces comply with design guide standards.

• Translate system-to-system interface specifications into a working interface data flow.

• Use Epic Bridges and the Rhapsody Interface Engine to complete data mapping requirements from one system to another. Code complex filtering logic using Rhapsody Interface Engine tool set.

• Requires detailed knowledge of HL7 Interface Protocol and knowledge of the Rhapsody Interface Engine.

• Write system-to-system interface validation plans and oversee the validation effort using departmental resources and dedicated interface analysts to do the actual testing.

• Use operating systems such as UNIX and Windows to monitor system activity.

• Understand database CACHE structures in the EPIC application.

• Design and develop file off-load and reporting routines using vendor supported software.

• Coordinate the TCP/IP communication configuration used for system-to- system interface communication protocol.

• Write and maintain system documentation as needed.

• Work seamlessly with Database Administrators and System Administrators for all supported systems.

Project Management

• Responsible for the design and implementation of the system-to-system interfaces between EPIC, state and federal/state systems, and OHSU Ancillary Information Systems by developing detailed project plans with dependencies and critical path tasks.

• Track and assign tasks to team members, vendors and customers with follow up to assure that tasks are completed on schedule.

• Identify project and task completion milestones and reports to management when they are not met or are at risk.

• Schedule and prepare relevant meeting materials to conduct progress meetings.

• Attend working meetings in an organized and professional manner.

• Provide project progress reports to management.

• Responsible for coordinating tasks and taking ownership of tickets associated with various aspects of these interface projects.

System/Application Support

• Diagnose system problems and develop plans to correct problems, which may include modifications to procedures, data entry instructions, database correction proposals, writing scripts to correct interface problems, and/or modify interface engine scripts to correct errors. Work with ITG, customer, and vendor to identify problems and solutions.  Coordinate with ITG, customer, and vendor to schedule and run application fix routines and upgrades.

• Coordinate resources and systems necessary to install application software in a production and test environment, write and execute data conversion plans, write and execute data and application software validation plans, write and execute system to system interface validation plans. 

• Write detailed system documentation. 

• Provide primary support for troubleshooting and resolving interface related system problems. 

• Monitor system interfaces such as ADT, order entry, results reporting and billing, and troubleshoot as needed.

• Provide technical knowledge of clinical applications to ITG and clinical department staff.  Train operations and help desk staff as needed.

• Share support and on call rotation with other Epic Interface team members to support the Epic electronic medical record, OHSU Health System and partners 24x7

• Trouble shooting & problem resolution: Analyze problems using Bridges and Rhapsody. Read and understand C++ and Javascript programming language.

Other duties as assigned.

Required Qualifications

• Bachelor's degree in computer science, a related field, or a clinical field and eight years' work-related experience in the information technology field or a combination of clinical or operational healthcare environments; OR 
• Associate's degree in computer science, a related field, or a clinical field and nine years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR 
• Ten years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR 
• Equivalent combination of education and experience where one year of experience will be substituted for an Associate's degree and two years of experience will be substituted for a Bachelor's degree.

Experience

• Two or more years of paid work experience as an Application Engineer.

• Experience with Epic data structures, and Epic Clarity Application.

• Intermediate to Expert level programming experience with JavaScript, SQL.

• Experience with Orion Rhapsody Interface Engine, or an equivalent interface engine.

• Experience with UNIX systems and Rhapsody server file organization in particular.

• Experience in terminal emulation software, file transfer, and data conversions.

• Experience with Cognos Framework Manager, Query Studio, and Report Studio. 

Knowledge, Skills, and Abilities

• Ability to develop interfaces using the HL7 standard.

• Working knowledge of one or more distributed healthcare computer applications. e.g. mainframes, HIS, LIS, RIS, pharmacy systems, registration, scheduling.

• Ability to proactively pursue problem resolution to satisfy customer needs independently.

• Ability to provide highly critical quality analysis and testing of new software applications or feature (including beta testing.)

• Ability to manage multiple complex tasks efficiently while successfully meeting assigned deadlines.

• Ability to work with users to accurately assess and diagnose system problems as defined by the user.

• Ability to work in a PC environment using the MS Office suite of applications.

• Working knowledge of hospital and/or clinic operations and the patient care process.

Preferred Qualifications

• Healthcare HL7 interface Trained/Certified.

• Successful candidates must have experience and working knowledge in healthcare system software, HL7 and TCP/IP, and technical application support for administrative and clinical systems. 2 years' experience in Healthcare Information Systems.

• Experience in the analysis and design of healthcare systems.

• Experience with databases such as Oracle, MS SQL, MS Access, Unify, etc.

• Experience in developing specifications for system-to-system interfaces.

• Experience in writing system validation plans.

• Understanding of the operations of patient registration, patient accounts and coverages.

• Working knowledge and understanding of project coordination and management.

• Working knowledge of Epic Bridges, EpicCare Ambulatory, Epic Scheduling, Epic Billing, Epic Registration.

• Working knowledge of interface processes and/or engine applications (HL7, OpenLink, Cloverleaf, eGate, etc.).

• Knowledge or experience with one or more computer languages. i.e. Visual Basic programming.
• Epic Bridges Certification.

Additional Details

Work Location: 100% remote.

Work Schedule: Monday-Friday, 8:00am-5:00pm. Rotate on call support for system to system interfaces.

Benefits 

• Healthcare for full-time employees covered 100% and 88% for dependents.
• $50K of term life insurance provided at no cost to the employee.
• Two separate above market pension plans to choose from.
• Vacation - up to 200 hours per year dependent on length of service.
• Sick Leave - up to 96 hours per year.
• 9 paid holidays per year.
• Substantial Tri-Met and C-Tran discounts.
• Employee Assistance Program.
• Childcare service discounts.
• Tuition reimbursement.
• Employee discounts to local and national businesses.

Why apply to OHSU?We are Oregon's only public academic health center. In addition to caring for patients, we lead groundbreaking research. We also train the next generation of health care professionals. As Portland's largest employer, we give you opportunities to learn and advance in a system of hospitals and clinics across Oregon and Southwest Washington. All are welcome. OHSU welcomes people of all ages, ethnicities, genders, national origins, religions and sexual orientations. We are striving to build an anti-racist, multicultural institution and encourage people with diverse backgrounds to apply. To request reasonable accommodation, contact askhr@ohsu.eduEmployment Type: OTHER