Title: Data Analytics/Data Modelling Contractor
Duration: 6 Months contract
Location: Remote
Life Sciences Data Modeler with experience in Data Vault 2.0 — Business Requirements & Enablement
1. Design and implement Data Vault 2.0 integration-layer models for US commercial entities: Hubs (HCP, HCO, Product, Territory, Payer, Patient), Links (call-to-HCP, script-to-product, account-to-payer, patient-to-therapy), and Satellites with record-source tracking and load-date historization.
2. Design Business Vault constructs encoding US-specific KPI logic (derived satellites, computed metrics, business-rule satellites), PIT and Bridge tables for consumption-layer performance, and Information Marts (star schemas, wide tables) optimized for Snowflake and Tableau / Power BI consumption.
3. Translate US commercial KPI definitions and business rules — elicited from Field Force, Market Access, Brand, Medical, and Payer Analytics stakeholders — into precise, implementable model specifications including source-to-target mappings, hash key strategy, transformation logic, and build-ready data dictionaries.
Key skills required: Data Vault 2.0 (Hubs/Links/Satellites/PIT/Bridge/Business Vault), Snowflake advanced modeling, US pharma commercial data (IQVIA, Veeva CRM, Specialty Pharmacy, Claims/EMR, Payer/Formulary), dimensional modeling, dbt (preferred), Collibra.
Never miss an opportunity! Create an alert based on the job you applied for.
