Data Engineer - SQL Spark Erwin
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
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 Clinical Data Hub (SDR V2) - Modernization of the Clinical data persistence and consumption layers. Near Real Time Ingestion via Optum Clinical Gateway FHIR bundles Persistence in Snowflake and Azure Cosmos Databases Data availability to downstreams via Snowflake views, curated streams and APIs - in the HCP Clinical Package model Data 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 testing Experience in Tools: like Spark, Beaver, TOAD, Erwin
Team: 8 to 10 member scrum team
Responsibilities:
Maintaining ECDH data MODEL DOCUMENTATION and changes Monitoring sync between CDP/UHC ECDHExperience with ErwinEnsure that Erwin data model can be shared easily via PDFCreate necessary subject areas within existing data model Ideal 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, 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. Oracle, DB2, SQLServer) Experience in Healthcare Data ERwin or E/R Studio, Oracle, DB2, SQLServer
Preferred Skills:
Bachelors Degree.
Experience in healthcare background.
Experience in healthcare information standard known as FHIR, HL7.Experience in Data Analysis, SQL, leveraging multiple in Data mapping and testing.
Experience in Tools: like Spark, Beaver, TOAD, Erwin
Interview Process:
Two rounds of interviews. Candidate will be expected to write code in the interview and discuss design/automation aspects in detail
Required Skills:
Experience in Data Analysis, SQL, leveraging multiple databasesExperience in Data mapping and testing