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

System Build and Maintenance

• Ensure data integrity and validity of the Epic application.
• Define system standards to be followed by other analysts such as database record numbering and naming conventions, technical documentation and specifications, technical build migration to production system.
• Analyze Epic functionality to simplify processes, improve the flow of data, and make use of enhancements.
• Design and build customized functionality based on workflow recommendations.
• Perform Epic Ambulatory and Healthy Planet build and maintenance as assigned per the OHSU Population Health Distribution Matrix.
• Develop test plans/documentation, conduct testing and validation as appropriate.
• Perform assessment and testing; write documentation in preparation for system upgrades.
• Follow the approved Epic Change Management policy.

Caboodle Datawarehouse, ETL and Systems Development

• Contribute to the support and growth of the OHSU Data Warehouse on Epic Caboodle and Epic Clarity by designing, developing and implementing population health focused ETL processes, data structures, and SQL code.
• Work with BI architects, developers, analysts and users to design, create and publish ETL processes and ETL metadata using SSIS and Epic system’s proprietary Caboodle Data Warehouse ETL approach as required.
• Engage with External Partners to exchange information. Verify data exchange agreement is valid (signed) and active. Data exchange with partners will include:
  
  • Initial discussions to determine scope and business needs, gathering data requirements.
  • Coding to produce (or consume) partner data
  • Validation of data (including conforming to OHSU security standards).
  • Secure Transport build to push/pull data to/from the partner and test of file exchanges with the partner.
  • Deploy and scheduling the process in a production environment and on-going support of any issues.
• Provide complete and consistent documentation of data warehouse content and ensure that users can determine what data is available in the warehouse, how this data is defined, how key metrics are defined, and analysis is performed.
• Use the knowledge gained by working as a part of the ETL team and through prior experience to analyze population health data to meet reporting requirements. Deliver additional ETL tools and/or data warehouse systems/products to improve the use of business data in the decision-making process.
• Facilitate customer requests for new or changed solutions. Develop options with recommendations, create functional specifications including performance requirements, create and execute test plans to confirm delivered functionality.
• Ensure that all components of a project plan are completed including design, build, testing, validation, training and communication.

Problem Resolution

• Respond to customer problems and issues, either by Support Desk referrals or direct customer contact.
• Communicate problem progress, resolution, and document in Jira as appropriate.
• Analyze problems to determine if it is necessary to resolve, if needed, escalate it to Epic TS.
• Manage assigned Jira tickets to ensure resolution or closure of tickets in a timely manner.
• Communicate with Epic TS on the prioritization of issues to meet OHSU needs.

Epic Certification and Professional Development

• Achieve and maintain EpicCare Ambulatory or Healthy Planet, and Caboodle Data Warehouse Developer Certification. Obtain Epic Badges in relevant areas, such as Epic Certified HEDIS.
• Complete New Version training on the required schedule.
• Attend related classes to manage assigned projects.

Other

• Perform other duties as assigned by supervisor.

Education

• 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 or equivalent.

• Minimum of two years of experience with T-SQL or ANSI SQL coding and tuning.

Knowledge, Skills, and Abilities

• Ability to work in a highly autonomous role by demonstrating self-motivation and creativity in design approach.
• Ability to function effectively in a very dynamic team environment.
• Ability to proactively pursue problem resolution to satisfy customer needs.
• Ability to proactively discover/test/analyze new EpicCare and Caboodle application enhancements/features 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.
• Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function).

Certifications

• Certification in an Epic Clinical Application and Caboodle Data Warehouse within 9 months of hire.

• Two Years experience with authoring ETL for Epic Caboodle Data Warehouse.

• 3+ years experience in Healthcare Information Systems analysis, development and implementation, specifically EpicCare and/or Epic Healthy Planet.

• Experience creating technical documentation of ETL and data models.

• Working knowledge of hospital operations and the patient care process.
• Epic Healthy Planet Certification.
• Caboodle Developer Certification.
• Clarity Data Model proficiency or certification.

This is a Monday through Friday, 8:00am - 5:00pm shift.
Work Location is 100% remote in the United States.

Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or aaeo@ohsu.edu.