Job Description

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.

Function/Duties of Position

The Clinical Data Engineer sits on the clinical data team within the broader Clinical Business Intelligence unit, alongside analysts, engineers, administrators, and architects. This position builds new clinical data warehousing solutions, data transformations, and data integration assets, and supports the changes, enhancements, and maintenance of existing assets in support of OHSU clinical data initiatives.

You will work closely with cross-functional teams — clinical and operational stakeholders, data architects, and IT specialists — to develop robust data pipelines, implement data quality controls, and deliver trustworthy data that supports clinical decision-making. Development happens primarily in the Epic Caboodle Console, Microsoft SQL Server tools, and Microsoft Fabric Data Engineering tools, with Azure DevOps for version control, code management, and deployment. Duties may extend to other cloud data engineering tools, such as Apache Airflow, as needed.

Key responsibilities include:

• Design and develop ETL pipelines that extract, transform, and load clinical data from a variety of sources into structures suitable for analysis.
• Implement data quality controls that validate, monitor, and maintain the accuracy, completeness, and consistency of clinical data across the pipeline lifecycle.
• Contribute to the growth of the OHSU Caboodle Data Warehouse by designing, developing, testing, and implementing custom clinical data models.
• Partner with BI architects, developers, analysts, and customers (practice managers, data scientists, quality analysts) to build and publish data models, ETL processes, Lakehouses, Warehouses, Notebooks, and metadata using the Epic Caboodle Console and third-party ETL tools.
• Develop data feeds using SSIS or similar tools, ensuring appropriate security review and transport consistent with information privacy and security requirements, business associate agreements, and data use agreements.
• Document warehouse content in the Caboodle Console and the Analytics Marketplace so users can determine what data exists, how it is defined, and how it traces back to Epic Clarity.
• Troubleshoot ETL failures, data anomalies, and warehouse issues surfaced by automated monitoring, other developers, and end users; resolve or escalate through established processes and communicate status to affected groups.
• Recommend improvements to ETL processes, tool sets, data models, and monitoring techniques that increase reliability and efficiency.
• Deploy warehouse content using approved Azure DevOps systems and processes, and follow approved SDLC practices throughout.
• Manage assigned projects by building timelines, identifying risks and milestones, and reporting status.
• Respond to and track issues in Jira Service Desk, gathering information from customers and triaging to resolution.

Required Qualifications

• 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 medallion architecture data warehouse environment.
• One year of experience with Microsoft Fabric using OneLake and Data Engineering tools.
• One year of experience with Python or PySpark.

Skills and Abilities

• Knowledge of data warehousing architecture and dimensional modeling concepts.
• Knowledge of data validation and testing methodologies for ETL processes.
• Familiarity with data governance and cataloging practices.
• Proven communication, analytical, and problem-solving skills.
• Ability to manage competing priorities and communicate progress 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.

Certifications

• Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.
• Microsoft DP-700 Fabric Data Engineer certification within 9 months of hire.

Preferred Qualifications

• Experience with the Epic Clarity and Caboodle data models.
• Experience planning and managing small projects.
• Experience with HIPAA and PHI compliance.
• Microsoft DP-700 Fabric Data Engineer Certification.

Additional Details

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.edu