Epic Caboodle & Healthy Planet Developer (Application Engineer, Sr.) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Oregon Health & Science University · 1 day ago

Epic Caboodle & Healthy Planet Developer (Application Engineer, Sr.)

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.

EducationHealth CareUniversities
check
H1B Sponsor Likelynote

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

Qualification

Epic CertificationETL ProcessesT-SQLANSI SQLData Warehouse DevelopmentTechnical DocumentationProblem ResolutionCustomer ServiceQuality AnalysisTeam CollaborationSelf-Motivation

Required

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

Preferred

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

Company

Oregon Health & Science University

company-logo
OHSU is a health and research university provides patient care, research, education of the next generation of health care.

H1B Sponsorship

Oregon Health & Science University has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (136)
2024 (132)
2023 (121)
2022 (132)
2021 (109)
2020 (103)

Funding

Current Stage
Late Stage
Total Funding
$36.6M
Key Investors
U.S. Small Business AdministrationNational Institute of Allergy and Infectious DiseasesHyundai Hope On Wheels
2024-09-25Grant
2022-11-21Grant· $4.7M
2022-09-27Grant· $0.3M

Leadership Team

leader-logo
Tarek Salaway
Chief Executive Officer, OHSU Health
linkedin
leader-logo
Lawrence Furnstahl
Executive Vice President & Chief Financial Officer
linkedin
Company data provided by crunchbase