SQL (5+ years) – Expert ability with enterprise, dimensional, and canonical data modeling techniques. Databricks & Delta Lake (3+ years) – Hands-on experience designing schemas for Medallion Architecture (Bronze, Silver, Gold). Commercial Life Sciences Data (3+ years) – Deep knowledge of IQVIA, Symphony Health, Veeva CRM, HCP/HCO reference data, Specialty Pharmacy/Patient Hub feeds, and Payer/Formulary datasets. ADDITIONAL DESIRED SKILLS Experience designing scalable data models for Patient Journey Analytics and HCP 360 use cases. Familiarity with data granularity, refresh cycles, coverage limitations, and provider linkage methodologies. Background in data governance, data lineage, and HIPAA/patient privacy requirements. CANDIDATE PROFILE The ideal candidate is a technical yet business-savvy Data Modeler with deep domain expertise in Commercial Life Sciences. They thrive in cross-functional environments, comfortably communicating technical schema designs to business SMEs while supplying clear specifications to data engineers. Job Responsibilities Design robust conceptual, logical, and physical data models across core domains including Patient, HCP, HCO, Product, and Payer. Establish schema and modeling standards for Bronze, Silver, and Gold layers using Databricks Delta Lake and Medallion Architecture. Create source-to-target mappings, define business rules, and design reusable data structures to support enterprise consumption. Collaborate with engineering, architecture, and business teams on identity resolution, data governance, and patient privacy frameworks.