Data Engineer - SQL Spark ErwinLocation: MN, TX or RemoteType: C2C/W2Client: Apex/UHGJob Description:Required Skills:Experience in Data Analysis, SQL, leveraging multiple databasesExperience in Data mapping and testingExperience in Tools: like Spark, Beaver, TOAD, ErwinBasic QualificationsAdditional Skills: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 modelWhat does the ideal candidate background look like (ex: healthcare specific background specific industry experience etc.)?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)Requirements: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.