Data Modeller

JD for Data ModelerExecutive Summary (Resume/JD Version)Responsible for analyzing business requirements, profiling and mapping data, designing conceptual/logical/physical data models, developing data warehouse and dimensional models, defining data governance standards, and delivering reporting and analytics solutions that enable trusted, scalable, and business-driven decision making.Key ResponsibilitiesBusiness & Data Requirements Analysis - Collaborate with business stakeholders to gather, analyze, and document business requirements, KPIs, and reporting needs.Data Analysis & Data Mapping - Analyze source systems, profile data, identify data quality issues, and define source-to-target mappings, transformation logic, and business rules.Data Modeling & Database Design - Design conceptual, logical, and physical data models, including Fact/Dimension structures, Star Schema, Snowflake Schema, and Data Marts.Data Governance & Quality Management - Establish data standards, metadata, data dictionaries, lineage, integrity controls, and governance processes to ensure reliable and compliant data assets.Reporting & Analytics Enablement - Translate business requirements into dashboards, reports, and analytical solutions while ensuring data structures support efficient analytics and decision-making.Cross-Functional Collaboration - Work closely with Business Analysts, Data Architects, Data Engineers, Developers, and QA teams to deliver scalable and business-aligned data solutions.Performance Optimization & Continuous Improvement - Optimize data models, database structures, and reporting solutions for performance, scalability, and maintainability.Key Deliverables

• Data Mapping Specifications (DMS/LMS)
• Conceptual, Logical, and Physical Data Models
• Fact & Dimension Models
• Star Schema and Snowflake Schema Designs
• Data Dictionary and Metadata Repository
• Data Lineage Documentation
• Data Quality Assessment Reports
• KPI Definitions and Metrics Catalog
• Dashboards, Reports, and Analytical Visualizations
• Data Warehouse / Lakehouse Design Documentation
• Source-to-Target Mapping and Transformation Rules
• Data Governance & Standards Documentation