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 robust 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 efficient 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 (India)
🏢 Mahindra Satyam
📍 India