Quick Overview
Job 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.
Similar jobs
- AD
Registered Nurse (RN) - Hospice Administrator
NewAdvisaCare
Troy, Michigan🇺🇸On-siteYesterdayComplianceRegulatory ComplianceHealthcare - MC
Pharmacy Sales Consultant - Queens, NYC
NewMCKESSON
Albany, New York🇺🇸$132.9k - $221.5k/yrHybrid15 minutes agoPharmacyHealthcare - MC
Pharmacy Sales Consultant - Queens, NYC
NewMCKESSON
Jamaica, New York🇺🇸$132.9k - $221.5k/yrHybrid15 minutes agoPharmacyHealthcare - MC
Pharmacy Sales Consultant - Queens, NYC
NewMCKESSON
New York🇺🇸$132.9k - $221.5k/yrHybrid15 minutes agoPharmacyHealthcare - AH
QUALITY SPECIALIST- Behavioral Health
NewAspire Health Partners
Orlando, Florida🇺🇸€16/hrOn-site17 minutes agoMicrosoft OfficeHealthcare - PH
Veteran Caregiver Part Time
NewPhoenix Home Care and Hospice
Fayette, Missouri🇺🇸On-siteYesterdayPhoenixSchedulingHealthcare