Data Modeller

Job description

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