Talent.com
This job offer is not available in your country.
Sr Data Modeler

Sr Data Modeler

SpectraMedixGurugram, Haryana, India
4 days ago
Job description

Sr. Data Modeler (US Healthcare IT)

Experience : 6 – 10 Years

Location : Gurgaon

We are seeking a skilled Data Modeler with 6 - 9 years of experience to join our dynamic team. The ideal candidate will have deep expertise in conceptual, logical, and physical data modelling, particularly in healthcare environments. You will design and maintain scalable data models that support business intelligence, data warehousing, and analytics needs.

You must have hands-on experience with Erwin Data Modeler, SCD (Slowly Changing Dimensions), fact and dimension tables, and designing star and snowflake schemas. Familiarity with Databricks, Azure Cloud, and Azure Data Factory is a strong plus.

Roles & Responsibilities

  • Develop and maintain conceptual, logical, and physical data models for healthcare data platforms
  • Design robust data models using Erwin to support data warehouse, data lake, and analytics
  • Create and manage fact and dimension tables, and implement SCD Types 1, 2, and 3
  • Build scalable star and snowflake schemas to optimize data for reporting and analysis
  • Collaborate with data engineering and business teams to translate requirements into effective data structures
  • Ensure data models meet compliance, governance, and performance standards
  • Document model designs, metadata, and data dictionaries for stakeholders
  • Support data integration and migration initiatives with strong data mapping and lineage understanding

Required Experience

  • Bachelor’s degree in Computer Science, Engineering, or a related field
  • 6 - 10 years of hands-on experience in data modelling
  • Strong expertise in Erwin Data Modeler
  • Solid knowledge of SCD types, fact / dimension tables, and data warehousing concepts
  • Proficiency in designing and optimizing star and snowflake schemas
  • Excellent SQL skills and understanding of relational database systems
  • Experience working with large datasets in a US healthcare along with FHIR
  • Good to Have

  • Experience with Databricks, Azure Cloud, and Azure Data Factory
  • Exposure to data governance frameworks and metadata management
  • Knowledge of data lakehouse architectures
  • Create a job alert for this search

    Data Modeler • Gurugram, Haryana, India