Data Modeler (Commercial Life Sciences)

About the role

We are seeking an experienced Data Modeler to help design and implement a Databricks unified data platform. In this role, you will lead the creation of common data models and scalable data products, such as Patient Journey and HCP 360, powering advanced analytics across our commercial life sciences ecosystem. Location: Cambridge, Massachusetts. Job type: Contract. Education: Bachelors.

Responsibilities

• Design robust conceptual, logical, and physical data models across core domains including Patient, HCP, HCO, Product, and Payer.
• Establish schema and modeling standards for Bronze, Silver, and Gold layers using Databricks Delta Lake and Medallion Architecture.
• Create source-to-target mappings, define business rules, and design reusable data structures to support enterprise consumption.
• Collaborate with engineering, architecture, and business teams on identity resolution, data governance, and patient privacy frameworks.

Qualifications

• Proven experience in conceptual, logical, and physical data modeling using advanced SQL techniques.
• Hands-on experience designing enterprise data models within Databricks and Delta Lake environments (Medallion Architecture).
• Deep technical familiarity with commercial life sciences datasets, such as IQVIA, Symphony Health, Veeva CRM, or Specialty Pharmacy/Claims feeds.
• Ability to work onsite 2-3 days per week at our Cambridge, MA or Exton, PA offices.

Skills

• scalable data models
• data governance
• data platform
• Delta Lake
• data lineage
• data structures
• Databricks
• physical data models
• reference data
• SQL
• Veeva CRM
• communicating
• Architecture
• Life Sciences
• business-savvy
• business requirements
• business strategy
• Journey Analytics
• data model
• data modeling techniques
• data quality
• data products
• governance
• HIPAA
• patient privacy
• use cases

Benefits

• medical
• prescription
• dental
• vision
• AD&D
• life insurance offerings
• short-term disability
• 401K plan

Pay

$65 - $75 per hour

Schedule

8am to 5pm (onsite 2-3 days per week at Cambridge, MA or Exton, PA offices)