Senior Applications Engineer

Role Description

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.

• Design and build scalable data structures.
• Create and maintain ETL pipelines.
• Support analytics for clinical and operational leaders.
• 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.

Qualifications

• Education:
  • 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.

Requirements

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

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.