Data Modeler - Life Sciences (Patient Journey & HCP 360)

Akaasa Technologies; United States; On-site; USD 110,000 - 170,000; Full time

Job summary

Akaasa Technologies is seeking a Data Modeler to support a Databricks unified data platform for Commercial Life Sciences. You'll design data models across patient, HCP, HCO, product, payer, and commercial activity domains and translate business requirements into scalable schemas.

You will establish Bronze, Silver, and Gold medallion layers, create source-to-target mappings, and collaborate with business SMEs, architects, and data engineers to ensure data governance and patient privacy compliance.

Qualifications

• 5+ years of SQL with enterprise, dimensional data modeling experience.
• 3+ years in Databricks/Delta Lake schema design.
• Deep knowledge of IQVIA, Symphony Health, Veeva CRM, HCP/HCO data.

Responsibilities

• Design conceptual, logical, and physical data models across patient, HCP, HCO, product, payer, and commercial activity domains.
• Define and maintain modeling standards across Bronze, Silver, and Gold medallion layers on Databricks Delta Lake.
• Establish harmonized entities in the Silver layer and consumption-ready data products in the Gold layer.
• Translate complex business requirements into entity relationships, data grain, shared dimensions, business definitions, and historical tracking strategies.
• Develop detailed source-to-target mappings and build reusable data structures that support multiple downstream data products.
• Collaborate with business SMEs, architects, and data engineers on identity resolution, data quality, lineage, governance, and patient privacy compliance.

Skills

SQL

Databricks & Delta Lake

Commercial Life Sciences Data

Job description

Akaasa Technologies is seeking a Data Modeler to support a Databricks unified data platform for Commercial Life Sciences. You'll design data models across patient, HCP, HCO, product, payer, and commercial activity domains and translate business requirements into scalable schemas.

You will establish Bronze, Silver, and Gold medallion layers, create source-to-target mappings, and collaborate with business SMEs, architects, and data engineers to ensure data governance and patient privacy compliance.