Job DescriptionJob Title: Data Modeler

NLocation: Bangalore / Pune

NWork Mode: Hybrid

NShift: UK Shift / US Overlapping Shift

NExperience: 10–15 Years

NKey Skill - Data Modeling, Snowflake, SQL, SAP HANA

NAbout the Role

nWeare seeking an experienced Data Modeler to support enterprise data warehouse modernization and cloud

Nmigration initiatives. The role will focus on designing, developing, and implementing logical and physical data models

Nwithin a Snowflake workplace, ensuring scalable, high-performance, and business-aligned data structures. The

Nideal candidate should have strong expertise in data warehousing concepts, dimensional modeling, cloud data

Nplatforms, and enterprisedata architecture.

NKey Responsibilities

n

N
- Design and develop logical and physical data models for enterprise data warehouse solutions.
N
- Translate business and architectural requirements into implementation-ready data models.
N
- Reverse-engineer existing SAP HANA data structures, Calculation Views, and Stored Procedures into
N

nSnowflake-compatible models.

N

n
- Define and document entity relationships, naming conventions, and data modeling standards.
N
- Develop dimensional models using Kimball methodology and apply Data Vault 2.0 concepts where
N

napplicable.

n

N
- Create and maintain conceptual, logical, and physical ERDs using industry-standard modeling tools.
N
- Collaborate with Data Architects, Data Engineers, Business Analysts, and stakeholders to ensure
N

nconsistency acrossdata assets.

N

n
- Design Snowflake schemas, table structures, clustering strategies, and optimization techniques.
N




- Work closely with dbt developers for model implementation, testing, and deployment.
N
- Participate in data migration and modernization projects involving cloud data warehouse platforms.
N
- Ensure data quality, consistency, scalability, and governance across all models.
N
- Support performance tuning and optimization of data structures within Snowflake.
N

nTechnical Skills

NData Modeling

n

n
- Logical Data Modeling
N
- Physical Data Modeling
N
- Dimensional Modeling (Kimball Methodology)
N
- Data Vault 2.0
n
- Conceptual Modeling
N
- Data Warehouse Design
N

nCloud Data Warehouse

N

n
- Snowflake Data Platform
N
- Schema Design
n
- Clustering Keys
N
- Table Design & Optimization
N
- Data Migration Strategies
N

nDatabase & Development

N

n
- Advanced SQL
n
- Data Warehousing Concepts
N
- ETL/ELT Understanding
N
- dbt (Data Build Tool)
N

nModeling Tools

n

N
- Erwin Data Modeler
n
- ER/Studio
N
- Similar Enterprise DataModeling Tools
N

nMigration Expertise

N

n
- SAP HANA Data Structures
N
- Calculation Views
n
- Stored Procedures
N
- Migration Mapping & Transformation Design
N

nMandatory Skills

N

n
- Snowflake Data Modeling
N
- Logical & Physical DataModeling
N
- Kimball Dimensional Modeling
N
- SQL
n
- Data Warehousing
N
- dbt
n
- ERD Modeling Tools (Erwin / ER Studio)
N
- SAP HANA Migration Understanding
N

nGood-to-Have Skills

N

n
- Data Vault 2.0
N
- Redshift / BigQuery Experience
N
- Cloud Data Migration Projects
N
- Data Governance & Data Quality Frameworks
N
- Performance Optimization in Snowflake
N
- Healthcare, Finance, orLarge Enterprise Data Platforms
N

📌 Hiring: Data Modeler (Bengaluru)
🏢 Movate
📍 Bengaluru