Data Engineer - SQL Spark ErwinErwinMN, TX or Remote 8 to 5 pmProject:Single Data Repository was established in 2017 is a key asset for Clinical Data persistence for several HEDIS and other UHC initiatives processing several domains of Clinical data.Enterprise Clinical Data Hub (SDR V2) - Modernization of the Clinical data persistence and consumption layers.Near Real Time Ingestion via Optum Clinical Gateway FHIR bundlesPersistence in Snowflake and Azure Cosmos DatabasesData availability to downstreams via Snowflake views, curated streams and APIs - in the HCP Clinical Package modelData model infrastructure, design established in Q1; Admit Discharge and Transfer Data available in ECDH Near Real time in Q2Top 3 needs:Experience in Data Analysis, SQL, leveraging multiple databasesExperience in Data mapping and testingExperience in Tools: like Spark, Beaver, TOAD, ErwinTeam:8 to 10 member scrum teamResponsibilities:Maintaining ECDH data MODEL DOCUMENTATION and changesMonitoring sync between CDP/UHC ECDHExperience with ErwinEnsure that Erwin data model can be shared easily via PDFCreate necessary subject areas within existing data modelIdeal candidate background:5 or more years of data modeling experience Enterprise Information Architect experienceExperience in Data Architecture and Database designExperience in building complex, large scale logical data models with ERwin or E/R StudioExperience with database technologies (e.g. Oracle, DB2, SQLServer)Experience in Healthcare Data ERwin or E/R Studio, Oracle, DB2, SQLServerRequirements:3 or more years of data modeling experience Enterprise Information Architect experienceExperience in Data Architecture and Database designExperience in building complex, large scale logical data models with ERwin or E/R StudioExperience with database technologies (e.g. Oracle, DB2, SQLServer)Experience in Healthcare Data ERwin or E/R Studio, Oracle, DB2, SQLServerPreferred Skills:Bachelors Degree.Experience in healthcare background.Experience in healthcare information standard known as FHIR, HL7.Experience in Data Analysis, SQL, leveraging multiple databases.Experience in Data mapping and testing.Experience in Tools: like Spark, Beaver, TOAD, ErwinInterview Process:Two rounds of interviews.
Candidate will be expected to write code in the interview and discuss design/automation aspects in detailRequired Skills:Experience in Data Analysis, SQL, leveraging multiple databasesExperience in Data mapping and testing