Job Summary
We are seeking an experienced Senior Data Modeler to design, develop, and maintain enterprise-wide data models that support business intelligence, analytics, regulatory reporting, and operational systems. The ideal candidate will have strong expertise in data modeling methodologies, data architecture, dimensional modeling, data warehousing, and cloud-based data platforms. The role requires close collaboration with business stakeholders, data architects, engineers, and application teams to ensure scalable, high-quality, and governed data solutions.

Key Responsibilities
Data Modeling & Architecture
Design and develop conceptual, logical, and physical data models for enterprise applications and analytics platforms.
Create and maintain dimensional models (Star Schema, Snowflake Schema, Data Vault) for data warehouse and reporting solutions.
Define data structures, relationships, hierarchies, metadata, and business rules.
Ensure consistency, scalability, and reusability of data models across systems.
Perform impact analysis for data model changes and enhancements.
Data Governance & Quality
Establish and enforce data modeling standards, naming conventions, and best practices.
Partner with data governance teams to maintain data lineage, metadata management, and data quality frameworks.
Identify and resolve data integrity and consistency issues.
Ensure compliance with enterprise data management policies and regulatory requirements.
Stakeholder Collaboration
Work closely with business analysts, product owners, architects, and developers to translate business requirements into data models.
Facilitate data discovery workshops and requirements-gathering sessions.




Provide recommendations for optimizing data structures and business processes.
Data Warehousing & Analytics
Support enterprise data warehouse, data lake, and lakehouse initiatives.
Design optimized models for reporting, analytics, machine learning, and self-service BI solutions.
Collaborate with ETL/ELT developers to ensure effective data integration and transformation processes.
Performance Optimization
Optimize database design for performance, scalability, and maintainability.
Conduct model reviews and performance tuning activities.
Ensure data models support high-volume transactional and analytical workloads.
Experience
8+ years of experience in Data Modeling and Data Architecture.
Hands-on experience designing enterprise-scale data models.
Strong experience with Data Warehouse and BI environments.
Technical Skills
Expertise in:
Conceptual, Logical, and Physical Data Modeling
Dimensional Modeling (Kimball)
Data Vault 2.0 Modeling
Normalization and Denormalization techniques
Master Data Management (MDM)
Metadata Management
Hands-on experience with:
ERwin Data Modeler, ER/Studio, PowerDesigner, or similar tools
SQL and Database Design
Oracle, SQL Server, PostgreSQL, Snowflake, Redshift, or Teradata
Cloud platforms: Azure, AWS, or Google Cloud
Data Warehousing and ETL/ELT tools
Preferred Skills
Knowledge of Databricks, Azure Synapse, Snowflake, BigQuery, or Redshift.
Experience with data governance tools such as Collibra, Alation, or Informatica.
Familiarity with Agile/Scrum methodologies.
Understanding of data security, privacy, and regulatory compliance requirements.
Snowflake Certification

Role Category: Data Architecture / Data Management / Data Engineering

📌 senior data Modeler (Mumbai)
🏢 Tech Mahindra
📍 Mumbai