Data Engineer - SQL Spark Erwin
Data Engineer - SQL Spark Erwin ErwinMN, TX or Remote 8 to 5 pm Project:
- 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 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 Q2
Top 3 needs:
- Experience in Data Analysis, SQL, leveraging multiple databases
- Experience 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 ECDH
- Experience with Erwin
- Ensure that Erwin data model can be shared easily via PDF
- Create necessary subject areas within existing data model
Ideal candidate background:
- 5 or more years of data modeling experience Enterprise Information Architect experience
- Experience in Data Architecture and Database design
- Experience in building complex, large scale logical data models with ERwin or E/R Studio
- Experience 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 experience
- Experience in Data Architecture and Database design
- Experience in building complex, large scale logical data models with ERwin or E/R Studio
- Experience 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 databases.
- Experience 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 databases
- Experience in Data mapping and testing