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