About this role
Senior Applications Engineer to support enterprise data warehouse solutions for OHSU Health System. Will design, develop, and maintain ETL pipelines and data models across Epic Caboodle, Fabric, and Azure-based platforms while ensuring data accuracy, security, and scalable analytics.
Key Responsibilities
- Design, develop, and optimize ETL pipelines; Build star-schema data structures; Perform advanced SQL/T-SQL coding; Support data ingestion with SFTP/PGP; Develop Power BI models and dashboards
Technical Overview
Role focuses on building ETL pipelines using Epic Caboodle Console, SSIS, and Azure data services; groundwork in star-schema modeling, SCDs, and BI assets using Power BI. Works in a hybrid cloud/on-prem environment with data ingestion from third-party partners.
Ideal Candidate
The ideal candidate is a senior data engineer with 3+ years of experience in data warehousing and ETL, with hands-on expertise in Epic Caboodle and cloud-based Azure data platforms. Must be adept at designing star-schema models, SCDs, and building scalable ETL pipelines while collaborating with clinical and operational stakeholders.
Must-Have Skills
SQL Server SSISAdvanced SQL/T-SQL developmentETL developmentDimensional modelingMetadata managementTechnical documentationRelational databases
Nice-to-Have Skills
Epic Caboodle and/or Epic Clarity development experienceHealthcare data experience including claimsMicrosoft Fabric certificationPower BI certificationAzure Data FactoryAzure DatabricksEpic Caboodle Developer CertificationEpic Clarity Data Model and SlicerDicer Model Build badge
Tools & Platforms
Epic CaboodleCaboodle ConsoleMicrosoft FabricAzure DatabricksAzure Data Lake StorageAzure Data FactoryPower BIEpic SlicerDicerSlicerDicerSFTPPGPSQL ServerSSIS
Required Skills
SQL Server SSIST-SQLETLDimensional ModelingData WarehousingStar SchemaSCDEpic CaboodleCaboodle ConsoleAzure DatabricksAzure Data FactoryAzure Data Lake StoragePower BIMicrosoft FabricSFTPPGP
Hard Skills
Epic CaboodleEpic Caboodle ConsoleSQL Server SSISSQLT-SQLAzure DatabricksAzure Data Lake StorageAzure Data FactoryMicrosoft FabricPower BICaboodleSlicerDicerETLData WarehousingDimensional modelingStar schemaSCD (Slowly Changing Dimensions)SFTPPGPMetadata managementData profiling
Soft Skills
Analytical problem-solvingStrong communicationAbility to manage multiple projectsSDLC/AgileDocumentationCollaboration
Certifications
Required
Epic Caboodle Developer certificationMicrosoft Power BI certificationMicrosoft Fabric certification
Preferred
Epic Caboodle Developer CertificationEpic Clarity Data Model badgeSlicerDicer Model Build badge
Keywords for Your Resume
Senior Application EngineerEpic CaboodleEpic Caboodle ConsoleSQL Server SSISSSIST-SQLAzure Data FactoryAzure DatabricksAzure Data Lake StoragePower BIMicrosoft FabricCaboodleEpic SlicerDicerSlicerDicerETLData WarehousingDimensional modelingStar schemaSCDSFTPPGPMetadata managementData profilingSDLCAgileCaboodle Console
Deal Breakers
Must be authorized to work in the United States
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile