Job Description

Senior Data Modeler – Data Platform

Location: Hyderabad, India (Hybrid)

We are looking for a Senior Data Modeler to design and govern enterprise-scale data models for a modern AWS-based lakehouse data platform. This role is responsible for building scalable, well-governed, analytics- and AI-ready data models using Apache Iceberg and cloud-native AWS services.

Key Responsibilities

· Design and maintain conceptual, logical, and physical data models for an enterprise data platform.

· Build fact, dimension, and reference data models supporting analytics, reporting, and ML use cases.

· Design data models optimized for an AWS lakehouse using Apache Iceberg, including schema evolution, partitioning strategies, and historical data access.

· Define and enforce data modeling standards, naming conventions, and business definitions.

· Ensure data models support data quality, consistency, and long-term scalability.

· Collaborate with Data Engineering, Product, Analytics, and Data Science teams to translate requirements into robust models.

· Review and validate data models to ensure alignment with platform standards.

Required Qualifications

· 8+ years of experience in enterprise data modeling.

· Strong expertise in dimensional modeling (facts, dimensions), analytical and relational data modeling, and reference/master data modeling.

· Hands-on experience modeling data in an AWS lakehouse using Apache Iceberg (must-have).

· Strong experience with AWS data services such as S3, Glue Data Catalog, Athena, or Snowflake on AWS.

· Experience with Snowflake or other cloud data warehouses

· Deep understanding of SCD Type 1/Type 2 strategies, historical correctness, and auditability.

· Strong SQL skills and ability to reason about source system schemas and transformations.

Nice to Have

· Exposure to ML/AI use cases supported by analytical data models.

· Experience with data cataloging, metadata, or lineage tools.

· Background in high-volume transactional or financial data domains.