Data Modelling

Intellics Global Services; Dadri; In loco; INR 4.000.000 - 6.000.000; Tempo pieno

Descrizione del lavoro

Intellics Global Services is seeking an experienced Senior Data Modeler to analyze, design and optimize large-scale data models within a Databricks Lakehouse environment. You will work with stakeholders and engineering teams to modernize enterprise data platforms and ensure scalable Bronze, Silver, and Gold layer architectures.

The role emphasizes strong dimensional modeling skills, governance, data quality, and cross-functional collaboration across data engineering and analytics teams.

Competenze

• 10 years of experience in Data Modeling and Data Warehousing.
• Strong expertise in Dimensional Modeling, Star Schema, Snowflake Schema, and design of facts and dimensions.
• Hands-on experience with Databricks Lakehouse architecture and Medallion design patterns.

Mansioni

• Analyze and assess existing Fact/Dimension data models and data flows.
• Design Bronze/Silver/Gold layer data models in Databricks.
• Translate business requirements into logical and physical data models.

Conoscenze

Dimensional modeling

Star schema design

Snowflake schema

Databricks Medallion Architecture

Delta Lake governance

SQL / Databricks SQL

Erwin / ERStudio / Lucidchart

Data warehouse modernization

Stakeholder management

Strumenti

Databricks

Erwin

ERStudio

Lucidchart

Descrizione del lavoro

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