Job location: Noida
Overall experience: 5 to 8 years
Employment type: Full Time, Permanent
Job type: fulltime
Salary: 15-30 Lacs
Job description Job Description Senior Data Modeler Databricks Medallion Architecture Role Overview We are seeking an experienced Data Modeler with strong expertise in analyzing existing FactDimension StarSnowflake data models and designing scalable Databricks Medallion Architecture Bronze Silver Gold data models The candidate will work closely with business stakeholders data architects and engineering teams to modernize and optimize enterprise data platforms Key Responsibilities Analyze and assess existing FactDimension data models data flows and business processes Design and implement scalable Bronze Silver and Gold layer data models in Databricks Translate business requirements into logical and physical data models Define data governance conformed dimensions surrogate key strategies and data quality standards Collaborate with Data Engineers to optimize data ingestion transformation and analytics workloads Create and maintain data dictionaries mapping documents and model documentation Drive data model performance optimization partitioning and query tuning Support migration of legacy data warehouses and reporting platforms to Databricks Lakehouse Required Skills 10 years of experience in Data Modeling and Data Warehousing Strong expertise in Dimensional Modeling Star Schema Snowflake Schema Fact and Dimension design Handson experience with Databricks Lakehouse Architecture and Medallion Design Patterns Strong understanding of Delta Lake Data Governance Data Lineage and Data Quality frameworks Experience with SQL Databricks SQL and data modeling tools Erwin ERStudio Lucidchart etc Knowledge of Data Warehouse modernization and cloud data platforms Strong stakeholder management and requirement analysis skills Preferred Skills Experience with Azure Databricks andor AWS Databricks Knowledge of Unity Catalog Delta Live Tables and Data Mesh concepts Exposure to Power BI Tableau or other BIreporting tools Experience in Life Sciences Healthcare Supply Chain or Commercial Analytics domains Key Competencies Data Architecture Modeling Business Requirement Analysis Problem Solving Analytical Thinking Documentation Communication Stakeholder Management Ideal Candidate A senior data modeler who can evaluate existing enterprise warehouse models define targetstate Databricks Lakehouse models and lead endtoend data model modernization initiatives Skills Mandatory Skills : Dimensional Data Modeling Good to Have Skills : TOAD Data Modeler