Architect - Data Modeller

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

• 8–13 yrs of experience
• dbt
• Data modelling
• Medical coding
• VBA
• Medication administration
• Structural design
• M.Sc or B.Tech or B.E. or B.Sc or BCA or M.Tech or MCA

Good to have

• SQL
• GCP