senior data Modeler
Mahindra Satyam · Mumbai, India
FULL TIME
Job Description
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 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
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 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
Details
| Company | Mahindra Satyam |
| Location | Mumbai, India |
| Type | FULL TIME |
| Niche | general |