Data Modeller

Job Title: Clinical Data ModellerLocation: Dallas, TX or any location in USA in EST time zone (Remote Working Available) Skills:Azure Data Factory, Azure Data Lake, Qlik Compose, Clinical Data Modeling, Veeva EDC, Veeva CTMS , MediRave data sets for Analytical needs

• Understand and analyze incoming source system data layouts
• Understand Medidata Rave and Veeva Vault EDC data model (Important entities and relationships)
• Perform data profiling as required to understand the granularity of the data
• Build canonical data model leveraging dimensional modeling techniques and build logical data model
• Experience in analyzing and translating business needs into long term solution data models
• Design and convert logical data model into physical data model
• Implement data strategies and develop physical data models
• Review modifications of existing systems for cross-compatibility
• Perform data analysis to define common valid values for data elements in the model
• Develop best practices for data coding to ensure consistency within the system
• 10+ Years of building dimensional data model
• 3+ years of building healthcare data model
• 5+ years of experience in healthcare clinical data topics such as patient demographics, encounters, lab, clinical notes etc.
• 10+ years of data analysis
• 10+ years of SQL experience