Azure Data Factory, Azure Data Lake, Qlik Compose, Clinical Data Modeling, Veeva EDC, Veeva CTMS, MediRave data sets for Analytical needs
Required Skills:
- 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