Data Modelling

Intellics Global Services; Mumbai, Bengaluru; On-site; INR 1,500,000 - 1,900,000; Full time

Job summary

Intellics Global Services in Mumbai seeks an experienced Data Modeler to analyze existing FactDimension models and design scalable Databricks Medallion Architecture Bronze-Silver-Gold data models. You will work with business stakeholders, data architects and engineers to modernize enterprise data platforms.

The ideal candidate has 10 years in data modeling and warehousing, strong dimensional modeling skills, hands-on Databricks experience, and a track record of driving data governance and data

Qualifications

• 10 years of experience in Data Modeling and Data Warehousing.
• Dimensional Modeling, Star & Snowflake schemas; fact/dimension design.
• Hands-on with Databricks Lakehouse Architecture and Medallion patterns.
• Delta Lake, Data Governance, Data Lineage and Data Quality.
• SQL, Databricks SQL; Erwin, ERStudio, Lucidchart.

Responsibilities

• Analyze and assess existing FactDimension data models, data flows and business processes.
• Design Bronze, Silver and Gold data models in Databricks.
• Translate business requirements into logical and physical data models.
• Define conformed dimensions, surrogate keys and data quality standards.
• Collaborate with Data Engineers to optimize ingestion, transformation and analytics workloads.
• Create and maintain data dictionaries, mapping documents and model documentation.
• Drive data model performance through partitioning and query tuning.
• Support migration of legacy data warehouses to Databricks Lakehouse.

Skills

Dimensional Modeling

Star Schema

Snowflake Schema

Fact and Dimension design

Databricks Lakehouse Architecture

Medallion Design Patterns

Delta Lake

Data Governance

Data Lineage

Data Quality frameworks

SQL

Databricks SQL

Erwin

ERStudio

Lucidchart

TOAD Data Modeler

Power BI

Tableau

Azure Databricks

Tools

Databricks

TOAD Data Modeler

Erwin

ERStudio

Lucidchart

Power BI

Tableau

Job description

Job description Senior Data Modeler Databricks Medallion Architecture

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 and/or AWS Databricks
• Knowledge of Unity Catalog, Delta Live Tables and Data Mesh concepts
• Exposure to Power BI, Tableau or other BI reporting 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 target state Databricks Lakehouse models and lead endtoend data model modernization initiatives

Skills

• Mandatory Skills : Dimensional Data Modeling
• Good to Have Skills : TOAD Data Modeler