Data Modeler

Please find the job details below for your reference:Role: Data Modeler – Azure Data bricks (Medallion Architecture)Notice Period: Immediate to 15 DaysLocation: India (Bangalore /Gurgaon /Remote)Work Mode: Remote Role Purpose Design and deliver implementation-ready logical and physical data models within Azure Databricks (Delta Lake) following Medallion Architecture (Bronze, Silver, Gold). The role ensures Data Engineers can immediately begin development with clear schema definitions, SQL structures, and zero ambiguity.Key Responsibilities1. Data Modelling & DesignDevelop Conceptual, Logical, and Physical Data Models.Define schemas, entities, attributes, relationships, keys, constraints, and data types.Provide DDL-ready SQL definitions for implementation.Clearly define fact table grain and dimensional structures.2. Azure Databricks – Medallion ModellingDesign structured models across:Bronze Layer – Raw ingestion, schema controlSilver Layer – Cleansed, conformed, standardized dataGold Layer – Business-ready dimensional modelsDefine transformation logic across layers (Bronze → Silver → Gold).Incorporate Delta Lake best practices (partitioning, performance, scalability).3. Advanced Modelling Techniques Strong hands-on expertise in:3rd Normal Form (3NF)Star SchemaSnowflake SchemaData Vault (Hubs, Links, Satellites)Must clearly define:Fact grainSurrogate key strategySlowly Changing Dimensions (Type 1 & Type 2)Conformed dimensionsAggregation strategy4. Engineering & Governance AlignmentEnsure models are build-ready for Data Engineering teams.Review implementation alignment with design.Maintain ER diagrams, data dictionary, and mapping documents.Enforce enterprise naming standards and modelling best practices.Required Skills & Experience5+ years of hands-on Data Modelling experience.Strong SQL (DDL, partitioning, performance concepts).Proven experience in Azure Databricks and Delta Lake environments.Deep understanding of Medallion Architecture.Experience in enterprise Data Warehouse or Modern Data Platform projects.Proficiency with data modelling tools (ERwin, ER Studio, PowerDesigner, Lucidchart, or similar).If you are interested in exploring this opportunity, please share your updated resume along with your availability for a discussion.Looking forward to hearing from youIf you are interested, please Confirm :Updated ResumeCurrent Location : Notice Period : Current & Expected CTC : If you’re interested or know someone who might be a good fit, feel free to comment, tag, or send me a DM. Happy to connect!

Apply Now