Exp: 5 - 15 yrs

Location: Bangalore, Chennai, Pune, Kolkata, and Gurgaon

Work Mode: Hybrid

Mandatory Skills: ERwin, Data Modeling, Dimensional Modeling, OLAP, OLTP, Logical Data Modeling, Physical Data Modeling, Medallion Architecture, Data Lake, Kimball, Cloud Data, Data Governance, Data Quality, Data Dictionary, ETL, API Integration, Stakeholder Management, Agile, Enterprise Data, Migration, and Data Flow Diagram.

Domain: Retail, Supply Chain, CPG, Foods & Beverages, Or Any other domain.

Job Overview:

We are seeking an experienced Senior Data Modeler with strong expertise in ERwin, data modeling techniques (logical and physical), and OLTP/OLAP systems. The ideal candidate will serve as a Solution Architect for Data Modeling, collaborating with product and engineering teams to define robust, scalable, and reusable data models across enterprise functions such as Sales, Procurement, Finance, Supply Chain, and R&D.;

You will play a key role in contemporary data transformation initiatives including Data Lake foundation building, migrations, modern data architecture (Medallion/Kimball),



and cloud-native design.

Key Responsibilities:

-
Design and develop logical and physical data models using tools like ERwin based on business requirements.

-
Implement dimensional modeling techniques for analytical workloads and normalized models for OLTP systems.

-
Work across OLTP and OLAP environments to support real-time and analytical data processing.

-
Understand and model enterprise datasets (Sales, Procurement, Finance, SCM, R&D;, Advanced Planning) from SAP, Oracle, and other ERP sources.

-
Develop scalable, reusable data models in bronze, silver, and gold layers as per Medallion architecture or Kimball EDW principles.

-
Collaborate with Data Engineers, Product Owners, and Business Analysts to translate requirements into high-quality data specifications.

-
Evaluate true source systems and existing data warehouses to define optimal data grain and model structure.

-
Create

📌 Data Modeler (Pune)
🏢 VIDPRO CONSULTANCY SERVICES
📍 Pune