Data Engineer

Data Engineer

Remote Job |   2022-11-22 10:05:57

Apply Now

Share Job 

Job Code : Apex146

Hi All, 

Role: Data Engineer - SQL Spark Erwin

Location: MN, TX or Remote

Type: C2C/W2

Client: Apex/UHG

Job Description: 

Required Skills: 

1. Experience in Data Analysis , SQL, leveraging multiple data bases 

2. Experience in Data mapping and testing 

3. Experience in Tools: like Spark, Beaver, TOAD, Erwin

Basic Qualifications

Additional Skills

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 data bases

• 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

• What 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 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