Data Modeller

Tekskills

Dadri

On-site

INR 2,000,000 - 3,200,000

Full time

6 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Tekskills is seeking an experienced Data Modeller with strong expertise in end-to-end Data Warehouse (DWH) design, dimensional modelling, and enterprise data architecture. The candidate must have experience building data warehouses from scratch.

You will design and implement enterprise data warehouses and data marts, perform source system analysis, develop conceptual/logical/physical data models, and ensure governance and data quality across the data ecosystem.

Qualifications

5+ years in Data Modelling / DWH
Strong in ER Modelling & Dimensional Modelling (Kimball/Inmon)
Experience building DWH from scratch
Experience with SQL, stored procedures and performance tuning
Cloud experience: Azure / AWS / GCP
ETL Tools: ADF, Informatica, Talend, DBT, SSIS
Databases: SQL Server, Snowflake, Redshift, BigQuery, Oracle
BI tools: Power BI, Tableau, Qlik

Responsibilities

Design & implement enterprise data warehouses & data marts
Perform source system analysis & data profiling
Develop conceptual, logical & physical data models
Design Star Schema, Snowflake, 3NF models
Define SCD (Type 1/2/3), transformations & data quality rules
Collaborate with ETL/ELT teams for pipeline development
Ensure data governance, lineage & metadata management
Translate business requirements into technical solutions

Skills

Data modelling

Dimensional modelling

ER modelling

SQL

Stored procedures

Performance tuning

Cloud platforms

ETL/ELT

DWH lifecycle

BI tools

Tools

ERWin

PowerDesigner

SQLDBM

Lucidchart

Job description

Job Summary

Looking for an experienced Data Modeller with strong expertise in end-to-end Data Warehouse (DWH) design, dimensional modelling, and enterprise data architecture. Candidate must have experience building data warehouses from scratch.

Key Responsibilities