Clinical Data Engineer (Application Engineer)

Department Overview

The mission of the Information Technology Group (ITG) is to provide and support technology and information services that enable OHSU to be a national leader in health and science innovation.

The work of the Business Intelligence & Advanced Analytics Division (BIAA) is to deliver meaningful analytic solutions by bringing together data, systems, and people to enhance the work and lives of OHSU members and the communities we serve. The Clinical data engineer role is part of the clinical data team, part of a larger clinical business intelligence unit (CLBI) comprising analysts, engineers, administrators, and architects. This position is responsible for creating new clinical data warehousing solutions, data transformations, and data integration assets, as well as supporting changes, enhancements, and maintenance of existing assets in support of OHSU clinical data initiatives.

Function/Duties of Position

The Clinical data engineer role is part of the clinical data team, part of a larger clinical business intelligence unit (CLBI) comprising analysts, engineers, administrators, and architects.  This position is responsible for creating new clinical data warehousing solutions, data transformations, and data integration assets, as well as supporting changes, enhancements, and maintenance of existing assets in support of OHSU clinical data initiatives. Primary duties will include, but are not limited to:

• ETL analysis, design, and development
• Source-to-target mapping
• Peer review
• Data validation and solution testing
• DevOps and Code version control
• Metadata documentation
• Production implementation and support

You will work closely with cross-functional teams, including healthcare professionals, data architects, and IT specialists, to develop robust data pipelines, implement data quality controls, and generate insights to support clinical decision-making. The ideal candidate has a strong background in both data engineering and analytics, with a deep understanding of healthcare systems and clinical data standards.

This position will be developing primarily in the Epic Caboodle Console and Microsoft SQL Server tools. However, duties may extend to IBM DataStage, Azure Data Factory, and various business intelligence tools. Azure DevOps will be used for version control, code management, and code deployment. All development will observe the OHSU BIAA data governance policies and SDLC.

The Clinical Analytics and Reporting team values a collaborative environment, where open and honest communication lends to creative solutions to complex business problems.  The ideal candidate will seek out opportunities to lead and lift others by offering consulting and providing technical expertise to assist clinical BI end users and fellow team members.

Required Qualifications

Education:

Bachelor’s degree in computer science, a related field, or a clinical field and six years of 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 seven years of work-related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

Eight 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:

• Minimum of two (2) years of experience as an Application Engineer or Developer (or equivalent classification) developing data warehouse objects and data integration ETL solutions
• Minimum of three (3) years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization.
• Minimum of five (5) years with Microsoft SQL Server T-SQL
• Minimum of two (2) years of experience in a data warehouse environment utilizing Epic Healthcare Data, Epic Clarity Database, Epic Caboodle Data Warehouse, and Epic ETL Processes.

Job Related Knowledge, Skills and Abilities:

• Knowledge of data warehousing architecture and dimensional modeling concepts.
• Ability to read, write, and maintain SQL code at an advanced skill level.
• Proven communication, analytical, and problem-solving skills.
• Ability to manage multiple projects on an ongoing basis with excellent attention to detail.
• Ability to accurately document system technical artifacts at a level of detail sufficient for ongoing production support.

Registrations, Certifications and/or Licenses:

• Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.
• Microsoft certification as an Azure Data Engineer Associate within 6 months of hire.

All are welcome

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.

‍