Architect - Data Modeller
MumbaiFull-time8–13 yrsPosted over a month ago
Leadership data science role at Quantiphi in Mumbai. Needs 8–13 years and an M.Sc, B.Tech or B.E..
About the role
The Data Modeler is responsible for the structural design of the platform's canonical and derived data assets. You will own the Common Data Model (CDM) at the schema level — the dimension, fact, bridge, and reference tables that hold normalized clinical, claims, and demographic data — and the source-to-target mappings (STTMs) that define how source-system data lands in CDM and how CDM data is reshaped into FHIR resources.
What you'll do
- Own the schema-level design of the Common Data Model — DIM (patient, person, encounter, provider, organization), FACT (observation, diagnosis, procedure
- Design columns, types, NULL semantics, hash key composition, SCD2 patterns, and partitioning strategies in coordination with the architect
- Develop and maintain Source-to-Target Mappings (STTMs) for every source-system feed — EPIC HL7v2 ADT/ORU/ORM, Cerner HL7v2, ambulatory EHR feeds, state HIE CCDA
- STTMs specify field-by-field source-path → CDM-column mapping with explicit transformation, NULL handling, and validation rules
- Develop and maintain STTMs for FHIR serialization — for each in-scope US Core 6.1 resource (Patient, Encounter, Condition, Observation, Procedure, Practitioner
What you need
- dbt
- Data modelling
- Medical coding
- VBA
- Medication administration
- Structural design
Good to have
- SQL
- GCP