Department Overview
OHSU’s Business Intelligence & Advanced Analytics (BIAA) team is seeking a Senior Application Engineer to support population health, value-based care, financial analytics, and data-driven clinical operations across the OHSU Health System. This remote role plays a critical part in developing, optimizing, and supporting our enterprise data warehouse solutions—including Epic Caboodle, Microsoft Fabric, Power BI, and modern Azure-based ETL platforms.
You’ll design and build scalable data structures, create and maintain ETL pipelines, support analytics for clinical and operational leaders, and ensure the accuracy, reliability, and security of healthcare encounters, financial, and claims data. This is a highly technical, hands-on engineering role suited for candidates who thrive in complex healthcare data environments.
Function/Duties of Position
Data Engineering and ETL Development (Caboodle, Fabric, Azure)
- Design, develop, and optimize ETL pipelines using Epic Caboodle Console, SQL Server SSIS, Microsoft Fabric, Azure Databricks, Azure Data Lake Storage, and Azure Data Factory.
- Build and maintain star-schema data structures including facts, dimensions, SCDs, aggregates, and bridge tables.
- Perform advanced SQL / T-SQL coding, optimization, data profiling, validation, and source-to‑target mapping.
- Support secure ingestion and exchange of data with third-party partners, including SFTP/PGP workflows.
- Troubleshoot ETL failures, data anomalies, and performance issues across hybrid on-prem and cloud pipelines.
Business Intelligence and Analytics Engineering
- Develop user-facing BI assets, including Power BI data models, dashboards, and semantic layers.
- Build and maintain Epic SlicerDicer models and analytic structures within Caboodle.
- Collaborate with population health leaders, analysts, and clinicians to develop meaningful, actionable metrics.
Operational Support and Engineering Quality
- Participate in system upgrades, regression testing, cutover planning, and SDLC/Agile processes.
- Document technical design, data models, and pipeline logic for long-term operational support.
- Provide technical guidance and consultation to BI developers, analysts, and end users.
Required Qualifications
Education
One of the following:
- Bachelor’s in computer science, business, or related field + 8 years of IT experience or a combination of clinical or operational environments.
- Associate’s degree + 9 years of IT experience or a combination of clinical or operational environments.
- 10 years IT, clinical, or operational healthcare experience.
- 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
- 2+ years as an Application Engineer/Developer using SQL Server SSIS.
- 2+ years of advanced SQL or T‑SQL development and performance tuning.
- Experience with ETL development, dimensional modeling, metadata management, and technical documentation.
- 3+ years of experience working in relational databases.
Skills and Competencies
- Strong SQL coding and troubleshooting.
- Deep understanding of data warehousing, star-schema modeling, and SCD methodology.
- Ability to manage multiple projects, document systems thoroughly, and follow SDLC or Agile practices.
- Analytical problem‑solving and strong communication skills.
Certifications
- Epic Caboodle Developer proficiency or certification within 6 months of hire.
- Microsoft Power BI or Fabric certification within 9 months of hire.
Preferred Qualifications
- Epic Caboodle and/or Epic Clarity development experience.
- Healthcare data experience, including claims.
- Experience with Microsoft Fabric, Power BI, Azure Data Factory, Azure Databricks, and Azure Data Lake.
- Experience building BI models, dashboards, and semantic layers.
- Epic Caboodle Developer Certification; Epic Clarity Data Model and SlicerDicer Model Build badge.
Additional Details
Work Location and Schedule
- Remote (within the United States)
- Monday–Friday, 8:00am - 5:00pm PT (core hours 9:00am - 3:00pm PT)
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.eduOriginally posted on