Data Modeler

Job Title: Senior Data Modeler

Location:

Job Summary:

Senior Data Modeler

Key Responsibilities:

• Develop

  conceptual, logical, and physical data models

  to support enterprise data initiatives.
• Design and optimize

  dimensional models

  for OLAP systems; understand

  OLTP vs OLAP

  and their associated schemas (Star, Snowflake).
• Implement

  SCD Type 2

  logic for maintaining historical data.
• Create

  surrogate keys

  , and handle

  many-to-many relationships

  efficiently in data models.
• Translate functional and technical requirements into data models in coordination with architects and platform teams.
• Create

  source-to-target mappings (STTM)

  and

  technical design documents

  for development teams.
• Collaborate with

  Data Stewards

  ,

  Business Analysts

  ,

  Data Engineers

  ,

  Scrum Masters

  , and

  Governance Teams

  .
• Validate and test data models, ensuring high

  data quality

  , consistency, and compliance.
• Provide support for

  metadata management

  ,

  MDM

  , and

  data governance initiatives

  .
• Work with

  CI/CD pipelines

  for model deployment and

  Cloud platforms

  (preferred: Azure/AWS/GCP).

Must-Have Skills:

• 5+ years of data modeling experience across conceptual, logical, and physical layers.
• Strong command over

  dimensional modeling

  ,

  normalization/denormalization

  ,

  SCD2

  , and

  data warehousing

  .
• Proficiency in

  data modeling tools

  (e.g., Erwin, ER/Studio, SAP PowerDesigner).
• Strong hands-on experience in

  SQL

  and understanding of

  data profiling/validation

  .
• Experience with

  metadata and master data management (MDM)

  .
• Experience in

  surrogate key

  creation, handling

  factless fact tables

  , and designing

  dimension and fact tables

  .
• Excellent communication and stakeholder engagement skills.

Nice-to-Have Skills:

• Experience with

  cloud platforms

  (Azure/AWS/GCP) in context of data modeling.
• Exposure to

  Python

  for validation scripts or data pipeline development.
• Familiarity with

  data cataloging

  tools and CI/CD for model deployment.
• Experience working in

  agile/scrum environments

  .

Stakeholders You Will Work With:

• Data Stewards/Business Analysts

  – For business definitions and data dictionary alignment.

• Program Managers/Scrum Masters

  – For delivery timelines and scope alignment.

• Data Engineers

  – For model implementation and validation.

• Governance/Platform Team

  – For approvals and deployment management.

• Business SMEs

  – To refine requirements and ensure functional clarity.

Red Flags (to avoid in candidate profile):

• Only discussing data ingestion/pipelines without focus on modeling principles.
• Lack of exposure to conceptual/logical/physical modeling as core responsibilities.
• Emphasis only on data analysis or governance without clear modeling experience.