Data Modeller

Hexaware Technologies; Hyderabad, Pune District, Bangalore Rural; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Hexaware Technologies in Hyderabad, India, seeks a Data Modeler to analyze business requirements, profile data, and design conceptual, logical, and physical data models for data warehouses and analytics.

You will establish data governance standards, ensure data quality, and deliver dashboards, reports, and analytics solutions that enable trusted, scalable decision making, working closely with BAs, Data Architects, Data Engineers and QA teams.

Qualifications

• Experience in analyzing business requirements and KPIs.
• Ability to profile data, identify data quality issues, and map source-to-target data.
• Design of conceptual, logical, and physical data models including star and snowflake schemas.
• Knowledge of data governance, metadata, and data lineage.
• Translate requirements into dashboards and analytics solutions.

Responsibilities

• Collaborate with stakeholders to collect business requirements, KPIs, and reporting needs.
• Analyze source systems, profile data, and define mappings and transformation rules.
• Design data models: conceptual, logical, physical, star and snowflake schemas.
• Establish data governance standards, metadata, and quality controls.
• Deliver dashboards and analytical visuals to enable business decisions.

Skills

Data requirements analysis

Data profiling

Data mapping

Data modeling

Data governance

Reporting & analytics

Performance optimization

Cross-functional collaboration

Education

Tools

SQL

ETL

Data warehousing

BI dashboards

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