Edtech.com's Summary

Oregon Health & Science University is hiring a BIAA Senior Applications Engineer to develop and support enterprise data warehouse solutions for population health, value-based care, and financial analytics within the OHSU Health System. The role involves designing scalable data structures, building ETL pipelines, creating BI assets, and collaborating with clinical and operational teams to deliver reliable healthcare data insights.

Highlights

Design, develop, and optimize ETL pipelines using Epic Caboodle, Microsoft Fabric, Azure Databricks, Data Lake Storage, and Data Factory.
Develop user-facing Power BI models, dashboards, and maintain Epic SlicerDicer analytic structures.
Support secure data ingestion and troubleshoot ETL failures across hybrid environments.
Participate in system upgrades, testing, and Agile/SDLC processes with documentation responsibilities.
Requires proficiency in advanced SQL/T-SQL coding and relational database management.
Must have 2+ years as an Application Engineer with experience in SQL Server SSIS and dimensional modeling.
Bachelor’s degree plus 8 years IT or related healthcare experience, or equivalent education and experience combinations.
Epic Caboodle Developer certification and Microsoft Power BI or Fabric certification required within specified timeframes.
Experience with healthcare claims data and knowledge of star-schema and SCD methodologies preferred.
Position offers full healthcare coverage, pension plans, vacation, sick leave, and additional employee benefits.

BIAA Senior Applications Engineer (Application Engineer, Sr.) Full Description

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 [email protected]

Original Job Description

Department Overview:

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.

Let me find your next job.

Thanks - you're signed up.

BIAA Senior Applications Engineer (Application Engineer, Sr.)

Edtech.com's Summary

BIAA Senior Applications Engineer (Application Engineer, Sr.) Full Description

TECHNOLOGY SUPPORT SUPERVISOR

Application Programmer (Data Content Specialist)

Lead Administrative Desktop Support

IT Manager – Research Computing - Goizueta Business School

Enterprise Applications Engineer