Data Modeler

Senior Data Modeler – Databricks / Commercial Life Sciences

Maryland / Washington DC area – Hybrid

Contract

Competitive hourly rate

We are supporting a major consulting organisation on a large-scale Databricks unified data platform programme within the life sciences sector.

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 including Patient Journey, HCP 360 and commercial analytics datasets .

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.

• 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

• 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.

Location

Maryland / Washington DC metro area. Candidates should be comfortable with a hybrid working model and occasional onsite collaboration.

If you have strong Databricks data modelling experience combined with hands-on knowledge of commercial pharmaceutical datasets, please get in touch for further details.

#DataModeler #Databricks #LifeSciences #Pharma #DataArchitecture #HCP360 #PatientJourney #Veeva #IQVIA #DataEngineering #ContractJobs