Clinical Data Engineer (Application Engineer)

Oregon Health & Science University is a public academic health center focused on health and science innovation. They are seeking a Clinical Data Engineer to build and maintain clinical data warehousing solutions and support data initiatives by developing robust data pipelines and implementing data quality controls.

Responsibilities:

• 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

Requirements:

• 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
• 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
• 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
• 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
• 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