Role: Senior Data Modeler - Enterprise Data Model/Snowflake/Source-to-Target (S2T) mappings/SQL
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 robust 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 spec

📌 enior Data Modeler (Chennai)
🏢 Mastek
📍 Chennai