Data Modeller

Job description

**Job Title:** Data Modeller **Skills:** Data Modelling **Experience: 5** - 13 years **Location:** Greater Noida, Hyderabad, Pune We at Coforge are hiring Data Modeler with the following skillset We are seeking an experienced Data Modeler with strong expertise in Dimensional Modelling, Data Warehousing, Data Vault Modelling, Data Profiling, Enterprise Data Modelling, 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 **Mandatory Skills** - Dimensional Modeling (Star Schema, Snowflake Schema) - Data Warehouse Concepts & Architecture Data Vault Modeling (Hub, Link, Satellite)Fact and Dimension Table Design SQL - Data ProfilingCanonical / Enterprise Data Modeling - Performance Optimization & Data Governance - Data Lineage and Metadata Management **Key Responsibilities** - Design, develop, and maintain conceptual, logical, and physical datamodels.Create and o**ptimize Fac**t Tab**les and Dimensio**n Tables for enterprise reporting and analytics. - Develop and im**plement Data Vaul**t models to support scalable and auditable data warehouse solutions. - **Perform SQL-based data p**rofiling to analyze data quality, completeness, consistency, and business rule adherences - 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 requirements. - Implement data governance standards, data quality controls, and metadata management processes. - Optimize data models and queries for performance, scalability, and maintain ability. - Create and maintain data dictionaries, business glossaries, and model d**ocumentation.** **Required Qualifications** 5+ years of experience in Data ModelLing and Data Warehouse projects. - Strong expertise in SQL and relational database concepts. Hands-on experience with Data Vault 2.0 methodology. - Experience designing Enterprise Data Models and Dimensional Models. - Strong understanding of fact tables, dimension tables, surrogate keys, and slowly changing dimensions (SCDs).Experience in data profiling, data quality assessment, and lineage tracking. - Excellent analytical and problem-solving skills. **Preferred Skills** - Experience with cloud data platforms such as AWS, Azure, 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 methodologies.