Data Modeler

Senior Data Modeler

Remote

Role Summary

We are seeking a Senior Data Modeler to design and implement scalable, high-quality enterprise data models supporting analytics, reporting, and AI/ML use cases on Azure Databricks platforms.

This role will be responsible for developing logical and physical data models, canonical schemas, and semantic layers, enabling consistent, governed, and reusable data assets across domains.

A strong data model is foundational for integrating complex datasets (claims, provider, member) and enabling advanced analytics and AI-driven decisioning

Key Responsibilities

Design and develop logical, physical, and dimensional data models (OLTP / OLAP)
Build canonical data models and semantic layers for enterprise data products
Define entity relationships, schemas, and data standards across domains
Create and maintain ER diagrams (ERD) and data dictionaries
Support Medallion architecture (Bronze / Silver / Gold layers)
Drive source-to-target mapping (STM) and data transformation design
Ensure data quality, consistency, and standardization across datasets
Collaborate with Data Engineering teams for Data Lakehouse implementation (Databricks)
Enable data lineage, metadata management, and governance frameworks
Translate business requirements into scalable and reusable data models

Well-defined data models enable cross-domain integration, consistent semantics, and scalable analytics outcomes

Required Skills

Strong expertise in:

Data Modeling (Conceptual, Logical, Physical, Dimensional)
Star/Snowflake schema design and normalization techniques
Hands-on experience with:

Azure Databricks (mandatory)
SQL, Databricks SQL / PySpark (data understanding)
Azure Data Services (ADLS, ADF, Synapse)

Experience in:

Data Warehousing / Lakehouse architectures
Data lineage, metadata, and catalog tools (Purview / Unity Catalog)
Strong understanding of:

Data governance, data quality, and modeling best practices