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 productive 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 (Maharashtra)
🏢 Tech Mahindra
📍 Maharashtra