Data Modeler

Akaasa Technologies; Cambridge (MA); A distancia; USD 110.000 - 150.000; Jornada completa

Descripción de la vacante

Akaasa Technologies is seeking a Data Modeler to help build a unified data platform for Commercial Life Sciences. The role focuses on creating a common data model and reusable data products like Patient Journey and HCP 360, spanning patient, provider, product, and payer domains.

We require deep expertise in SQL, Databricks Delta Lake, and commercial life sciences data. The position is remote with EST-based candidates only and occasional travel once a month, offering collaboration with business

Formación

• 5+ years of SQL experience in enterprise data modeling.
• Hands-on with Databricks Delta Lake and medallion architecture.
• Deep knowledge of IQVIA, Symphony Health, Veeva CRM, HCP/HCO reference data, payer/formulary datasets.

Responsabilidades

• Design conceptual, logical, and physical data models across core domains.
• Define and maintain bronze, silver, and gold medallion layer standards on Databricks Delta Lake.
• Create source-to-target mappings and reusable data structures to support enterprise consumption.
• Collaborate with SMEs, architects, and data engineers on governance and privacy.

Conocimientos

SQL

Databricks & Delta Lake

Commercial Life Sciences Data

Descripción del empleo

Title: Data Modeler Commercial Life Sciences (6 Openings)

Location: Remote (Once a month Travel required) EST candidates only

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.