Senior Data Modeler – Life Sciences (Data Vault 2.0)

About the Role We are seeking an experienced Senior Data Modeler with deep expertise in Data Vault 2.0, Snowflake, and Life Sciences Commercial Data to support a large-scale enterprise data modernization initiative. The ideal candidate will play a critical role in designing scalable enterprise data models, translating complex business requirements into technical specifications, and enabling analytics solutions across commercial, payer, patient, and field force domains. This role requires strong experience with Data Vault architecture, dimensional modeling, Snowflake optimization, and pharmaceutical data sources including IQVIA, Veeva CRM, Claims, EMR, Specialty Pharmacy, and Payer/Formulary datasets. Key Responsibilities Data Vault Architecture & Modeling • Design and implement Data Vault 2.0 integration-layer models. • Develop Hubs, Links, and Satellites for enterprise commercial data domains. • Establish hash key strategies, historization methodologies, and record-source tracking. • Design scalable and auditable enterprise data models. Business Vault & Analytics Enablement • Develop Business Vault components including: • Derived Satellites • Business Rule Satellites • Computed Metrics • PIT (Point-In-Time) Tables • Bridge Tables • Design Information Marts and consumption-layer models optimized for analytics and reporting. Business Requirements & Data Translation • Collaborate with stakeholders across: • Commercial Operations • Field Force Effectiveness • Market Access • Brand Analytics • Medical Affairs • Payer Analytics • Translate KPI definitions and business requirements into technical specifications. • Create source-to-target mappings, transformation logic, and data dictionaries. Data Platform & Governance • Optimize models for Snowflake performance and scalability. • Support data governance and metadata management initiatives. • Collaborate with engineering teams to ensure high-quality data delivery. Required Qualifications • 6+ years of experience in Data Modeling, Data Warehousing, or Analytics Engineering. • Strong expertise in Data Vault 2.0 methodology. • Hands-on experience designing: • Hubs • Links • Satellites • PIT Tables • Bridge Tables • Business Vault Components • Advanced Snowflake data modeling experience. • Strong dimensional modeling and data warehousing expertise. • Experience translating business requirements into technical data models. • Excellent stakeholder communication and documentation skills. Preferred Qualifications • Experience in Life Sciences or Pharmaceutical commercial analytics. • Familiarity with: • IQVIA Data • Veeva CRM • Specialty Pharmacy Data • Claims Data • EMR Data • Payer/Formulary Data • Experience with dbt for data transformation and model deployment. • Experience using Collibra for metadata management and governance. • Knowledge of Tableau and Power BI reporting environments. Technical Skills Data Modeling • Data Vault 2.0 • Hubs • Links • Satellites • PIT Tables • Bridge Tables • Business Vault • Dimensional Modeling Data Platforms • Snowflake • dbt • SQL • Data Warehousing Life Sciences • IQVIA • Veeva CRM • Specialty Pharmacy • Claims Data • EMR Data • Payer Analytics • Commercial Analytics Analytics & Reporting • Tableau • Power BI Governance • Collibra • Data Dictionaries • Source-to-Target Mapping What We're Looking For • Strong analytical and problem-solving abilities. • Ability to bridge business and technical teams. • Expertise in enterprise data architecture and modeling best practices. • Excellent documentation and communication skills. • Experience working in highly regulated Life Sciences environments.