Senior Data Modeler

Overview

Remote
$DOE
Accepts corp to corp applications
Contract - W2
Contract - Contract

Skills

SQL
ETL
Data modeling
FHIR
HIPAA

Job Details

HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Senior Data Modeler in Remote. Below is the detailed job description.

Role - Senior Data Modeler
Location - Remote (EST preferred)
Hire - Contract
Must have :
Solid Data Modeling exp
Databricks
Exp in Healthcare (Preferred)
Job Description:

This role will focus on designing, optimizing, and implementing data models as the organization transitions its enterprise data to the Databricks Lakehouse platform. The ideal candidate will have strong data modeling expertise, healthcare domain knowledge, and experience in modern cloud-based data platforms.

Key Responsibilities

  • Collaborate with business analysts, data architects, and engineering teams to translate business requirements into logical and physical data models.
  • Design scalable, flexible, and performance-optimized data models to support analytics, reporting, and machine learning workloads on Databricks.
  • Map and migrate legacy data structures (from EHR, EMR, billing, and operational systems) to the Databricks Lakehouse environment.
  • Ensure compliance with HIPAA and other healthcare data privacy regulations in data model design. (Good to have)
  • Define and maintain data dictionaries, entity-relationship diagrams, and metadata documentation.
  • Work with ETL/ELT developers to ensure models are implemented effectively and aligned with data ingestion and transformation pipelines.
  • Partner with data governance teams to enforce data quality, standardization, and stewardship best practices.
  • Optimize models for structured, semi-structured, and unstructured healthcare data (e.g., HL7, FHIR, claims data, imaging metadata).

Qualifications

  • Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
  • 8+ years of experience in data modeling, with at least 4 years in cloud or lakehouse environments (preferably Databricks, Snowflake, or Azure Synapse).
  • Good to have the experience with healthcare data structures (EHR/EMR, HL7, FHIR, claims data, patient records).
  • Proficiency in SQL, data modeling tools (e.g., Erwin, ER/Studio), and dimensional modeling (Kimball, Data Vault, 3NF etc).
  • Hands-on experience in Databricks (Delta Lake, Unity Catalog, Spark SQL).
  • Understanding of ETL/ELT processes, data warehousing, and BI/reporting needs in healthcare.
  • Strong communication skills with the ability to work cross-functionally in a clinical environment.
  • Knowledge of healthcare data compliance (HIPAA, HITRUST) and security best practices would be an added advantage.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.