Data Modeler

Movate; Bengaluru; On-site; INR 800,000 - 1,800,000; Full time

Job summary

Movate in Bengaluru, India is seeking an experienced Data Modeler to support enterprise data warehouse modernization and cloud migration.

Responsibilities include designing logical and physical data models in Snowflake, translating business requirements, and collaborating with dbt developers to implement scalable data structures. Prior experience with Kimball modeling and SAP HANA reverse-engineering is preferred.

Qualifications

• Experience in designing logical and physical data models.
• Strong knowledge of Kimball dimensional modeling and Data Vault 2.0 concepts.
• Experience with Snowflake and cloud data warehouses.
• Ability to translate business requirements into data models.
• Reverse-engineer SAP HANA structures into data models.

Responsibilities

• Design and develop logical and physical data models for enterprise DW.
• Translate requirements into implementation-ready models.
• Collaborate with data architects and dbt developers.
• Define ERDs and data modeling standards.
• Optimize Snowflake schemas and performance.
• Support data migration and modernization projects.
• Ensure data quality and governance across models.
• Participate in data warehouse modernization initiatives.

Skills

Data Modeling

Dimensional Modeling (Kimball)

Data Warehouse Design

Cloud Data Warehouse

Snowflake

SQL

dbt

Erwin Data Modeler

SAP HANA

Tools

Erwin Data Modeler

Snowflake

SQL

SAP HANA

Job description

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

About the Role

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

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

within a Snowflake environment, ensuring scalable, high-performance, and business-aligned data structures. The

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

platforms, and enterprise data architecture.

Key Responsibilities

Design and develop logical and physical data models for enterprise data warehouse solutions.

Translate business and architectural requirements into implementation-ready data models.

Reverse-engineer existing SAP HANA data structures, Calculation Views, and Stored Procedures into

Define and document entity relationships, naming conventions, and data modeling standards.

Develop dimensional models using Kimball methodology and apply Data Vault 2.0 concepts where

applicable.

Create and maintain conceptual, logical, and physical ERDs using industry-standard modeling tools.

Collaborate with Data Architects, Data Engineers, Business Analysts, and stakeholders to ensure

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

Work closely with dbt developers for model implementation, testing, and deployment.

Participate in data migration and modernization projects involving cloud data warehouse platforms.

Ensure data quality, consistency, scalability, and governance across all models.

Support performance tuning and optimization of data structures within Snowflake.

Technical Skills

Data Modeling

Dimensional Modeling (Kimball Methodology)

Data Warehouse Design

Cloud Data Warehouse

Database & Development

Data Warehousing Concepts

Modeling Tools

Erwin Data Modeler

Migration Expertise

Mandatory Skills

Logical & Physical Data Modeling

Kimball Dimensional Modeling

Data Warehousing

Good-to-Have Skills

Data Governance & Data Quality Frameworks

Healthcare, Finance, or Large Enterprise Data Platforms