Data Modeler

• Position Title: Sr. Data Modeler
• Location: Maryland / Washington DC Metro Area
• Job Nature: Contract role with the possibility of extension and follows a hybrid work arrangement

Job Summary:

We are looking for an experienced Data Modeler with strong commercial pharmaceutical / life sciences data knowledge to help develop a common enterprise data model and reusable data products.

Key Responsibilities:

• Design conceptual, logical and physical data models across Patient, HCP, HCO, Product, Payer and Commercial Activity domains.
• Define modelling standards across Bronze, Silver and Gold Databricks medallion layers.
• Establish harmonised entities within the Silver layer and consumption-ready data products within Gold.
• Translate business requirements into entity relationships, data grain, shared dimensions, business definitions and historical tracking approaches.
• Develop source-to-target mappings and reusable data structures supporting multiple commercial data products.
• Partner with business SMEs, architects and engineers across identity resolution, data quality, lineage, governance and patient privacy.
• Support scalable commercial analytics use cases including Patient Journey and HCP 360.

Required Experience:

• Strong SQL and hands-on experience with enterprise, dimensional and canonical data modelling.
• Strong experience with Databricks, Delta Lake and medallion architecture.
• Commercial life sciences / pharmaceutical data experience is essential.
• Understanding of source structures, granularity, coverage limitations, refresh cycles and patient / provider linkage.
• Experience translating commercial pharma use cases into scalable data models.
• Previous experience supporting Patient Journey, Patient 360, HCP 360 or similar commercial data products would be highly desirable.

Strong working knowledge of datasets including:

• Prescription and claims data such as IQVIA and Symphony Health
• CRM platforms such as Veeva
• HCP / HCO reference and master data
• Specialty pharmacy and patient hub feeds
• Payer and formulary data