Data Modeler

Akaasa Technologies; Alaska; On-site; USD 120,000 - 180,000; Full time

Job summary

Akaasa Technologies seeks a Data Modeler to join a Databricks-driven data platform initiative. Build a common data model and reusable data products such as Patient Journey and HCP 360, bridging business strategy with technical execution across commercial life sciences data domains.

Design across Patient, HCP, HCO, Product, Payer domains, define standards for Bronze, Silver, Gold, and collaborate on data governance, lineage, and patient privacy compliance.

Qualifications

• SQL proficiency across enterprise, dimensional, and canonical modeling.
• Hands-on Databricks & Delta Lake schema design for Medallion Architecture.
• Deep knowledge of IQVIA, Symphony Health, Veeva CRM, HCP/HCO data, payer/formulary datasets.

Responsibilities

• Design conceptual, logical, and physical data models for core domains.
• Establish Bronze/Silver/Gold standards on Delta Lake in Medallion Architecture.
• Create source-to-target mappings and reusable data structures for multiple products.
• Collaborate on identity resolution, governance, and patient privacy compliance.

Skills

SQL (5+ years)

Databricks & Delta Lake

Commercial Life Sciences Data

Job description

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.