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