Oregon Health & Science University is dedicated to providing technology-based services and solutions to manage information effectively. They are seeking a Senior Epic Caboodle & Healthy Planet Developer to ensure data integrity, develop ETL processes, and maintain the Epic application, contributing to the organization’s mission in population health management.
Responsibilities:
- 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
- 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
- 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
- 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
- Perform other duties as assigned by supervisor
Requirements:
- 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
- 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
- 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)
- 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