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