We are looking for an experienced Data Modeler with robust expertise in enterprise data modeling, dimensional modeling, and modern Lakehouse architecture. The ideal candidate should have hands-on experience designing scalable, optimized, and governed data models using Databricks, Delta Lake, and Unity Catalog.

Location: Pune

Experience: 5–10 Years

Notice Period: Only Immediate Joiners

Key Responsibilities :

- Design and develop Conceptual, Logical, and Physical Data Models for enterprise data platforms.
- Build dimensional models using Star and Snowflake schemas, including Fact and Dimension tables.
- Define data relationships, grain, keys, cardinality, and referential integrity.
- Design and implement data models for Data Warehouse, Data Lake, and Lakehouse architectures.
- Develop data models across Bronze, Silver, and Gold layers.
- Implement SCD Type 1 and Type 2 for historical data tracking.
- Perform source-to-target mapping and define data transformation rules.




- Ensure data quality, consistency, normalization, and performance optimization.
- Collaborate with Data Architects, Data Engineers, and BI teams to translate business requirements into effective data models.
- Support metadata management, data lineage, and data governance initiatives.

Mandatory Skills :

- Strong experience in Conceptual, Logical & Physical Data Modeling.
- Hands-on expertise in Dimensional Modeling, Fact & Dimension Design.
- Strong understanding of Star and Snowflake schemas.
- Experience in Relational Data Modeling and ER Modeling.
- Hands-on experience with Databricks, Delta Lake, and Unity Catalog.
- Good understanding of Lakehouse Architecture.
- Knowledge of Normalization, Denormalization, and SCD Type 1 & Type 2.
- Experience in Master Data and Reference Data Modeling.

📌 Data Modeler (Pune)
🏢 Talentmatics
📍 Pune