Edtech.com's Summary

Oregon Health & Science University is hiring a BIAA Senior Applications Engineer to develop and optimize enterprise data warehouse solutions supporting population health, value-based care, financial analytics, and clinical operations. The role involves designing scalable data structures, building ETL pipelines, creating business intelligence assets, and ensuring data accuracy and security in a complex healthcare environment.

Highlights

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 and perform advanced SQL/T-SQL coding and optimization.
Develop Power BI data models, dashboards, and Epic SlicerDicer analytic structures.
Support secure data exchange with third-party partners and troubleshoot pipeline failures and data anomalies.
Participate in system upgrades, regression testing, and Agile/SDLC processes.
Required qualifications include a relevant bachelor's degree plus 8 years of IT experience or equivalent, with at least 2 years as an Application Engineer using SQL Server SSIS and advanced SQL development skills.
Certification requirements: Epic Caboodle Developer proficiency within 6 months and Microsoft Power BI or Fabric certification within 9 months of hire.
Preferred experience includes Epic Clarity development, healthcare claims data, and familiarity with Microsoft Fabric, Power BI, Azure Data Factory, Azure Databricks, and Azure Data Lake.
Position is remote within the United States with a full-time schedule, Monday through Friday.
Annual salary range from approximately $114,635 to $173,593, based on experience, education, and internal equity.

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 askhr@ohsu.edu

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

Network Infrastructure Analyst (Infrastructure Analyst)

Information Technologist I

Assistant Vice President of Research Technology

Information Technologist IV/S

Academic Advisement Systems Analyst