Data Modeler

Job description

**Job Title:** Data Modeller **Skills:** Data Modelling **Experience: 5** - 13 years **Location:** Greater Noida, Hyderabad, Pune 5 days work from office mandator y We at Coforge are hiring Data Modeler with the following skillse **t: Job Summ** ary We are seeking an experienced Data Modeler with strong expertise in Dimensional Modelling, Data Warehousing, Data Vault Modeling, Data Profiling, Enterprise Data Modeling, Data Governance, and Data Lineage. The ideal candidate will be responsible for designing scalable, high-performance data models that support enterprise reporting, analytics, and business intelligence initiati **ves. Mandatory S** - kills Dimensional Modeling (Star Schema, Snowflake S - chema)Data Warehouse Concepts & Archit - ectureData Vault Modeling (Hub, Link, Sate - llite)Fact and Dimension Table - DesignSQL Data Pro - filingCanonical / Enterprise Data Mo - delingPerformance Optimization & Data Gove - rnanceData Lineage and Metadata Mana **gement Key Responsib** - ilities Design, develop, and maintain conceptual, logical, and physical data - models.Create and o **ptimize Fac** t Tab **les and Dimensio** n Tables for enterprise reporting and an - alytics.Develop and im **plement Data Vaul** t models to support scalable and auditable data warehouse so - lutions. **Perform SQL-based data p** rofiling to analyze data quality, completeness, consistency, and business rule ad - herence.Design and m **aintain Canonical/Enterprise Dat** a Models across multiple business - domains.Define and document data lineage from source systems to reporting and analytics - layers.Collaborate with business stakeholders, data architects, ETL developers, and BI teams to understand data requi - rements.Implement data governance standards, data quality controls, and metadata management pr - ocesses.Optimize data models and queries for performance, scalability, and maintain - ability.Create and maintain data dictionaries, business glossaries, and model docume **ntation. Required Quali** - fications5+ years of experience in Data Modeling and Data Warehouse - projects.Strong expertise in SQL and relational database - concepts.Hands-on experience with Data Vault 2.0 met - hodology.Experience designing Enterprise Data Models and Dimensiona - l Models.Strong understanding of fact tables, dimension tables, surrogate keys, and slowly changing dimension - s (SCDs).Experience in data profiling, data quality assessment, and lineage - tracking.Excellent analytical and problem-solvin **g skills. Prefer** - red Skills Experience with cloud data platforms such as AWS, Azu - re, or GCP.Exposure to data governance tools such as Collibra, Informatica EDC, Alation, - or Purview.Knowledge of ETL/ELT tools and modern data - platforms.Familiarity with Agile/Scrum met hodologies.