[Remote] Data Analytics/Data Modelling Contractor (Only W2)
Note: The job is a remote job and is open to candidates in USA. Nasscomm is seeking a Data Analytics/Data Modelling Contractor to design and implement advanced data models for US commercial entities. The role involves creating integration-layer models and business vault constructs, translating KPI definitions into model specifications, and optimizing data structures for performance.
Responsibilities
- 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
- 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
- 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
Skills
- 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
- 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
- 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
- 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
- Collibra
- Dbt
Company Overview