Data Modeler – Azure Databricks

Experience: 5–7 Years

Locations: Bangalore / Pune / Mumbai / Hyderabad / Noida

Work Mode: Hybrid

Working Hours: 11:00 AM – 8:00 PM IST

US Overlap: Up to 4 hours overlap with US working hours, as required

Job Summary

We are looking for an experienced Data Modeler with strong hands-on expertise in Azure Databricks and Delta Lake to design and deliver implementation-ready Conceptual, Logical, and Physical Data Models.

The ideal candidate should have robust expertise in modern data modeling techniques and Medallion Architecture (Bronze, Silver, Gold). The candidate will be responsible for translating complex business requirements into scalable data models, schemas, SQL/DDL structures, transformation logic, and documentation that can be directly consumed by Data Engineering teams.

Key Responsibilities

- Design and deliver Logical and Physical Data Models using Azure Databricks and Delta Lake.
- Develop Conceptual, Logical, and Physical Data Models (CDM/LDM/PDM).
- Design scalable data structures following Medallion Architecture – Bronze, Silver, and Gold layers.
- Define entities, attributes, relationships, keys, constraints, schemas, and data types.
- Create DDL-ready SQL definitions for Data Engineering implementation.
- Define transformation logic across Bronze, Silver, and Gold layers.
- Apply Delta Lake best practices when designing data models.
- Design and implement models using:
- 3rd Normal Form (3NF)
- Star Schema
- Snowflake Schema
- Data Vault
- Ensure data models are implementation-ready with minimal ambiguity for Data Engineering teams.
- Create and maintain ER diagrams, data dictionaries, source-to-target mappings, and mapping documentation.
- Translate complex business requirements into robust, scalable,



and maintainable data models.
- Ensure data integrity, scalability, performance, and accessibility.
- Collaborate closely with Data Engineers, Data Architects, Business Analysts, and other stakeholders.
- Review, validate, and refine data models based on technical and business requirements.

Mandatory Skills Candidates must have hands-on experience with the following:

- Azure Databricks
- Delta Lake
- Medallion Architecture – Bronze / Silver / Gold
- Conceptual, Logical & Physical Data Modeling
- Advanced Data Modeling
- 3NF
- Star Schema
- Snowflake Schema
- Data Vault
- SQL / DDL
- ER Diagrams
- Data Dictionary
- Source-to-Target Mapping
- Mapping Documentation

Candidate Requirements

- 5–7 years of relevant experience in Data Modeling / Data Engineering.
- Strong hands-on experience designing logical and physical data models.
- Strong experience with Azure Databricks and Delta Lake.
- Strong understanding of Medallion Architecture.
- Practical knowledge of 3NF, Star Schema, Snowflake Schema, and Data Vault.
- Strong understanding of data architecture, entities, relationships, keys, constraints, schemas, and data types.
- Strong SQL and DDL skills.
- Ability to create implementation-ready models for Data Engineering teams.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management skills.
- Ability to work effectively with Data Engineers, Architects, Business Analysts, and technical stakeholders.

Important Note This position requires hands-on Data Modeling experience. Candidates with only theoretical knowledge of Azure Databricks or data modeling concepts may not be suitable.

Experience

- Data modelling: 5 years (Required)
- Data Engineering: 5 years (Required)

Work Location: Hybrid remote in Noida, Uttar Pradesh

📌 Data Modeler – Azure Databricks (Noida)
🏢 Tech Next
📍 Noida