enior Data Modeler -Enterprise Data Model/Snowflake/Source-to-Target (S2T) mappings/SQL- India

Mastek; Chennai District; On-site; INR 2,000,000 - 2,800,000; Full time

Job summary

Mastek is seeking an experienced Senior Data Modeler to lead enterprise data modeling across North Star models, semantic layers, and data pipelines. You will craft conceptual, logical, and physical models (Star/Snowflake) and translate business requirements into standardized target structures.

The role emphasizes collaboration with data engineers, BI teams, and AI teams to ensure models align with approved standards and support BI, analytics, and AI use cases.

Qualifications

• 8–12 years of Data Modeling experience.
• Strong conceptual, logical and physical data modeling skills.
• Experience with North Star data modeling and S2T mappings.

Responsibilities

• Design North Star Data Models and semantic layers for enterprise data.
• Develop conceptual, logical, and physical models (Star/Snowflake).
• Create detailed source-to-target mappings with business logic.
• Define entities, attributes, relationships, keys, hierarchies and KPIs.
• Ensure models support BI, analytics, and AI/GenAI consumption.
• Collaborate with data engineers, BI teams, and AI teams.
• Maintain data-model documentation and mappings.
• Participate in reviews and enforce standards.

Skills

Conceptual Data Modeling

Logical Data Modeling

Physical Data Modeling

Dimensional Modeling

Star & Snowflake schemas

SCD

SQL

North Star Data Modeling

Source-to-Target mappings

Ontology/Context Layers

BI/Analytics support

Power BI

Sigma

Tools

Snowflake

Power BI

Sigma

Job description

Senior Data Modeler

Location: Any Mastek Office India

Experience

10–12 years of hands‑on experience in Data Modeling, Data Warehousing, and SQL.

Role Overview

We are looking for an experienced Senior Data Modeler with strong expertise in enterprise data modeling and modern analytical data environments.

The candidate should have a strong understanding of fundamental and advanced data modeling concepts and hands‑on experience designing North Star Data Models, source-to-target mappings, and semantic/ontology/context layers that support downstream BI, analytics, and AI use cases.

Key Responsibilities

• Design, develop, and maintain North Star Data Models that provide a consistent and business-oriented representation of enterprise data.
• Develop conceptual, logical, and physical data models based on business and analytical requirements.
• Design normalized and dimensional models, including Star and Snowflake schemas.
• Create detailed source-to-target mappings, including source attributes, target attributes, transformation rules, business logic, and data relationships.
• Translate source-system structures and business requirements into standardized target data models.
• Define business entities, attributes, relationships, keys, hierarchies, measures, and KPIs.
• Design and maintain semantic, ontology, and context layers that provide consistent business meaning across data.
• Ensure the North Star Data Model and semantic layer can effectively support downstream consumption through Power BI, Sigma, and AI/GenAI applications.
• Work closely with data engineers, business analysts, BI teams, and AI teams to ensure the implemented models align with the approved data models.
• Review and enhance existing data models for consistency, scalability, usability, and performance.
• Maintain data-model documentation, data dictionaries, business definitions, and source-to-target mapping specifications.
• Participate in data-model reviews and ensure modeling standards and best practices are followed.

Required Technical Skills

• 8–12 years of Data Modeling experience.
• Strong understanding of:
• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Dimensional Modeling
• Star and Snowflake schemas
• Normalization and denormalization
• Fact and Dimension modeling
• Slowly Changing Dimensions (SCD)
• Primary and foreign keys
• Hierarchies and relationships
• Business rules and data definitions
• Hands‑on experience with North Star Data Modeling or similar enterprise‑wide canonical/business data modeling approaches.
• Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and data validation.
• Strong understanding of Snowflake.
• Strong experience creating Source-to-Target (S2T) mappings.
• Understanding of Semantic Layer, Ontology Layer, and Context Layer concepts.
• Understanding of how well‑designed data models support BI, analytics, and AI/GenAI consumption.
• Experience with Power BI and/or Sigma is preferred.

Retail Domain Experience – Preferred

Experience working in the Retail domain is highly preferred, with an understanding of areas such as:

• Product and Product Hierarchies
• Store and Location
• Sales and Transactions
• Pricing and Promotions
• Marketing and Advertising

Ideal Candidate

The ideal candidate should be able to work across the complete data-modeling lifecycle: