Data Modeler

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

Job Description

Title: Data Modeler Commercial Life Sciences

POSITION OVERVIEW

We are seeking a Data Modeler to join our team in supporting a Databricks unified data platform initiative. The primary focus is building a common data model and developing reusable, high-impact data products such as Patient Journey and HCP 360. This role bridges business strategy and technical execution across critical commercial life sciences data domains.

DAY-TO-DAY 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 closely with business SMEs, architects, and data engineers on identity resolution, data quality, lineage, governance, and patient privacy compliance.

REQUIRED SKILLS

• SQL (5+ years) Expert ability with enterprise, dimensional, and canonical data modeling techniques.
• Databricks & Delta Lake (3+ years) Hands‑on experience designing schemas for Medallion Architecture (Bronze, Silver, Gold).
• Commercial Life Sciences Data (3+ years) Deep knowledge of IQVIA, Symphony Health, Veeva CRM, HCP/HCO reference data, Specialty Pharmacy/Patient Hub feeds, and Payer/Formulary datasets.

ADDITIONAL DESIRED SKILLS

• Experience designing scalable data models for Patient Journey Analytics and HCP 360 use cases.
• Familiarity with data granularity, refresh cycles, coverage limitations, and provider linkage methodologies.
• Background in data governance, data lineage, and HIPAA/patient privacy requirements.

CANDIDATE PROFILE

The ideal candidate is a technical yet business‑savvy Data Modeler with deep domain expertise in Commercial Life Sciences. They thrive in cross‑functional environments, comfortably communicating technical schema designs to business SMEs while supplying clear specifications to data engineers.

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