Clinical Data Engineer – Application Engineer

Oregon Health & Science University Foundation

. Build new clinical data warehousing solutions, data transformations, and data integration assets .

Posted 9/23/2026full-timeRemote • United StatesSeniorLead💰 $107,359 - $162,570 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and developing ETL pipelines, data warehousing solutions, and data integration assets, with a strong focus on data quality and validation methodologies. Proficient in SQL Server, SSIS, and data modeling, with the ability to manage projects and communicate effectively across teams.

Highest-signal resume keywords

ETL Pipeline DevelopmentSQL Server T-SQL CodingData Warehousing ArchitectureData Validation MethodologiesEpic Caboodle Developer Certification

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL DevelopmentSQL ServerSSIST-SQLData ModelingPythonPySparkData IntegrationPerformance TuningSystem Optimization

Soft Skills

Analytical SkillsProblem-Solving SkillsCommunication SkillsAttention to DetailProject Management

Tools & Technologies

Epic Caboodle ConsoleAzure DevOpsJira Service DeskMicrosoft FabricOneLake

Certifications & Qualifications

Epic Clarity Data Model CertificationEpic Caboodle Developer CertificationMicrosoft DP-700 Fabric Data Engineer Certification

Industry Keywords

Clinical Data WarehousingData GovernanceHIPAA CompliancePHI ComplianceMedallion Architecture

Tech Stack

Tools & technologies

AzureETLMS SQL ServerPySparkPythonSDLCSQLSSIS

About the role

Key responsibilities & impact

Build new clinical data warehousing solutions, data transformations, and data integration assets
Support changes, enhancements, and maintenance of existing clinical data assets
Design and develop ETL pipelines extracting, transforming, and loading clinical data from varied sources
Implement data quality controls validating, monitoring, and maintaining clinical data accuracy, completeness, and consistency
Design, develop, test, and implement custom clinical data models for the OHSU Caboodle Data Warehouse
Partner with BI architects, developers, analysts, practice managers, data scientists, quality analysts, and other customers
Build and publish data models, ETL processes, Lakehouses, Warehouses, Notebooks, and metadata using Epic Caboodle Console and third-party ETL tools
Develop secure data feeds using SSIS or similar tools
Document warehouse content in the Caboodle Console and Analytics Marketplace, including definitions and lineage to Epic Clarity
Troubleshoot ETL failures, data anomalies, and warehouse issues; resolve or escalate issues and communicate status
Recommend improvements to ETL processes, tool sets, data models, and monitoring techniques
Deploy warehouse content through approved Azure DevOps systems and follow SDLC practices
Manage assigned projects, timelines, risks, milestones, and status reporting
Respond to and track Jira Service Desk issues, gathering customer information and triaging to resolution

Requirements

What you’ll need

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 and seven years of work-related experience; OR eight years of work-related experience; OR equivalent combination of education and experience
Minimum of two years of experience as an Application Engineer or Developer developing data warehouse objects and data integration ETL solutions
Minimum of three years SQL Server experience, including SSIS and T-SQL coding, performance tuning, and system optimization
Minimum of five years with Microsoft SQL Server T-SQL
Minimum of two 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
Preferred: experience with Epic Clarity and Caboodle data models, small project planning and management, HIPAA and PHI compliance, and Microsoft DP-700 certification

Benefits

Comp & perks

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