Data Modeler - Solution Architect

Data Modeler

12 15 Years

Remote Preferred candidate location will be North Carolina.

Required skill Data Model and Healthcare/Clinical data is a Must

Mandatory Skill healthcare/clinical data data models

Job Description
JD for Data Modeler

A data modeler who understands healthcare/clinical data data models and can ensure the new DWH being set up is created based on an extensible industry standard.

• Understand the concepts of modern data warehouse Data lake ELT and ETL.
• Should have hands on experience on Azure Cloud
• Health care background with knowledge of various standards like HIPPA and HITRUST
• Should be a good listener experience handling teams across various time zones.
• Strong data analytical skills Data Architecture (Modeling). Experience with one or more standard ETL tools like SSIS Azure Data Factory.
• Strong database development experience with SQL Server.
• Understand the concept of master Data Management (Master Patient Index) Data Masking
• Strong Documentation and presentation skills.
• Experience with data modeling tools will be a plus.
• Experience with Scripting languages like Python Scala etc. will be added advantage. Analyze all data warehouse architecture goals and provide support to all related initiatives.
• Experience in client communication & onsiteoffshore coordination
• Familiar with datasets that any CRO has to work with (like EDC Labs Clinical Trials)
• Experience with Data standards: OMOP SDTM CDASH
• Familiarity with designing data models for use in RWE/HEOR/Clinical space will be an added advantage.

Responsibilities:

1. Work closely with the business analysts or subject matter experts to understand data requirements and build logical and physical data models.
2. Experience in dimensional modeling and normalized data model designing. Experience in generating and maintaining data dictionary source to target data model mapping and DDL scripts.
3. Strong experience in Healthcare domain
4. Experience in any data modeling tool such as ErWin /IBM Infosphere Data Architect and model maintenance.
5. Perform impact analysis on existing data model and inform the stakeholders Present the data model to reviewers to seek approval.
6. Planning and supporting implementation of designed data structures by coordinating with DBA team and application development teams.
7. To work on capacity planning activities with DBA teams during physical data model development.
8. Experience in any RDBMS Microsoft SQL Server
9. Experience in using any healthcare industry data model (e.g. IBM UDMH) will be an added advantage.