Description

 
 
Key Responsibilities

• Design conceptual, logical, and physical data models across patient, HCP, HCO, product, payer, and commercial activity domains.
• Define modeling standards across Bronze, Silver, and Gold medallion layers.
• Establish harmonized entities in the Silver layer and consumption-ready data products in the Gold layer.
• Translate business requirements into entity relationships, data grain, shared dimensions, business definitions, and historical tracking.
• Develop source-to-target mappings and reusable data structures supporting multiple data products.
• Collaborate with business SMEs, architects, and engineers on identity resolution, data quality, lineage, governance, and patient privacy initiatives.

 
Required Qualifications

• Strong SQL skills and experience with enterprise, dimensional, and canonical data modeling.
• Experience with Databricks, Delta Lake, and Medallion Architecture.
• Strong working knowledge of commercial life sciences data sources, including:
• Prescription and claims data (IQVIA, Symphony Health)
• CRM platforms (Veeva)
• HCP/HCO reference data
• Specialty pharmacy and patient hub data feeds
• Payer and formulary datasets
• Understanding of data structures, granularity, refresh cycles, coverage limitations, and patient/provider linkage methodologies.
• Experience translating commercial use cases such as Patient Journey Analytics and HCP 360 into scalable data models

Key Skills

Education

Bachelor's degree