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 effective 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

📌 Data Modeller (Bangalore Rural)
🏢 Hexaware Technologies
📍 Bangalore Rural