Nasscomm · 1 month ago
Data Analytics/Data Modelling Contractor (Only W2)
United States
Contract
Remote
Senior LevelNasscomm 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.
ConsultingProfessional ServicesEducationTechnical SupportTraining
No H1B
Hiring Manager
Arya Bennett
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
Qualification
Required
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
Preferred
dbt
Company
Nasscomm
Nasscomm expertise in consulting services along with deployment of technical solutions.
Founded in 2008
1001-5000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase