Data Modeller

Tekskills; Greater Noida; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Tekskills is seeking an experienced Data Modeller to lead end-to-end Data Warehouse design, dimensional modelling and enterprise data architecture from scratch. The role requires building data warehouses, data marts and robust data governance across sources and targets.

You will define scalable data models, collaborate with ETL/ELT teams, and ensure data quality, lineage and metadata management while aligning with business requirements and performance goals.

Qualifications

• 5+ yrs in Data Modelling / DWH
• Strong in ER Modelling & Dimensional Modelling (Kimball/Inmon)
• Tools: ERWin, PowerDesigner, SQLDBM, Lucidchart
• Strong SQL, Stored Procedures, Performance Tuning
• Cloud: Azure / AWS / GCP
• ETL Tools: ADF, Informatica, Talend, DBT, SSIS
• DBs: SQL Server, Snowflake, Redshift, BigQuery, Oracle
• Good to Have Data Vault Modelling
• BI Tools: Power BI, Tableau, Qlik
• DevOps / CI-CD
• Must Have Experience building DWH from scratch
• Strong knowledge of end-to-end DWH lifecycle

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

DWH

ER Modelling

Dimensional Modelling

SQL

Stored Procedures

Performance Tuning

Azure

AWS

GCP

Power BI

Tableau

Qlik

CI/CD

End-to-end DWH lifecycle

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

• 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

Required Skills

• 5+ yrs in Data Modelling / DWH
• Strong in ER Modelling & Dimensional Modelling (Kimball/Inmon)
• Tools: ERWin, PowerDesigner, SQLDBM, Lucidchart
• Strong SQL, Stored Procedures, Performance Tuning
• Cloud: Azure / AWS / GCP
• ETL Tools: ADF, Informatica, Talend, DBT, SSIS
• DBs: SQL Server, Snowflake, Redshift, BigQuery, Oracle
• Good to Have Data Vault Modelling
• BI Tools: Power BI, Tableau, Qlik
• DevOps / CI-CD
• Must Have Experience building DWH from scratch
• Strong knowledge of end-to-end DWH lifecycle