Nasscomm
Data Analytics/Data Modelling Contractor (Only W2)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Data Analytics/Data Modelling Contractor (W2) for 6 months, offering a pay rate of "XX". Key skills include Data Vault 2.0, Snowflake modeling, and US pharma commercial data experience. Proficiency in Tableau and dbt is preferred.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 17, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#Snowflake #Microsoft Power BI #"ETL (Extract #Transform #Load)" #BI (Business Intelligence) #Tableau #Data Vault #Strategy #Collibra #CRM (Customer Relationship Management) #Vault #dbt (data build tool)
Role description
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.
1. 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.
1. 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.
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.
1. 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.
1. 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.
