SQL Developer

Description:

Client has taken the initiative to upgrade its Credentialing and Provider Enrollment Systems to a new system (Credential Stream). Enterprise Data and Information Intelligence (EDII) team currently receives data from both systems and feeds many downstream systems - Active Directory, Find-A-Doc, etc. Epic will become one of the downstream systems and provider info will be sent to Epic via SailPoint system (managed by IAM team).

With respect to Epic project, there are two bodies of work needed:

1. Create a new pipeline and bring in Credential Stream data to the Provider Data Model as a new data source. This will require learning the new system, data mapping from source to target, data profiling, creating new ETL pipelines, validation/testing of the new pipeline and retesting the data feed to SailPoint.

2. Account for all data elements needed for the operations of IAM existing data feed.

The consultant will assist Client with the implementation of the new data feed from the Credentialing Stream to Provider Data Model and upgrading of existing feeds to work with Credential Stream data.

Required Skills:

• Must be an outcome-oriented team player accustomed to working with tight/strict deadlines.
• Proficient in SQL (MSSQL), data analysis, validation, and profiling skills.
• Deep understanding of data engineering, relational databases, non-relational databases, and data modeling.
• Experience performing unit, functional and integration testing.
• Strong communication, organizational and documentation skills.
• Big Query/GCP/Cloud computing experience and healthcare background preferred.
• Min 2 years of experience required.