Sr. Data Modeler - Immediate Joiner

Digital Business People; Hyderabad; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Digital Business People is seeking an experienced Data Modeler to design and maintain enterprise data models for Insurance domains, including Life & Annuities and Property & Casualty. You will collaborate with cross-functional teams to translate requirements into scalable data architectures.

You will apply best practices in data governance, metadata, and MDM while supporting data warehousing, analytics, and integration initiatives. Experience with ERwin and cloud platforms is preferred.

Qualifications

• 3-6 years of experience in Data Modeling, Data Architecture, or related data management roles.
• Strong domain expertise in Insurance, including Life & Annuities and Property & Casualty.
• Hands-on experience with ERwin Data Modeler or other leading data modeling tools such as ER/Studio, PowerDesigner, SAP PowerDesigner, or Enterprise Architect.
• Strong knowledge of conceptual, logical, and physical data modeling techniques.
• Expertise in OLTP and OLAP data model design principles.
• In-depth understanding of normalization, denormalization, and Normal Forms (1NF through 5NF).
• Strong knowledge of Data Warehousing concepts including: Snowflake Schema, Fact and Dimension Modeling, Slowly Changing Dimensions (SCD Type 1, 2, and 3).
• Experience creating enterprise data models, canonical data models, and integration data models.
• Strong SQL skills and ability to analyze complex data structures across multiple source systems.
• Understanding of data governance, metadata management, master data management (MDM), and data quality concepts.

Responsibilities

• Engage directly with business and client stakeholders to understand business requirements and translate them into scalable enterprise data models.
• Design, develop, and maintain conceptual, logical, and physical data models for Insurance domains.
• Collaborate with business analysts, architects, developers, and data engineers to ensure alignment with objectives and standards.
• Develop subject area models, data dictionaries, metadata, and data lineage documentation.
• Apply data modeling best practices, naming standards, governance principles, and methodologies.
• Support data warehouse, reporting, analytics, and operational system initiatives through robust data model design.
• Perform data analysis, source-to-target mapping, and data profiling to support model development and integration.
• Review and optimize existing data models for performance, scalability, and maintainability.
• Participate in data governance initiatives and ensure consistency across enterprise data assets.

Skills

Data modeling

Data architecture

SQL skills

Stakeholder management

Communication

Analytical thinking

Agile

Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

SAP PowerDesigner

Enterprise Architect

Job description

• Engage directly with business and client stakeholders to understand business requirements, data needs, and translate them into scalable enterprise data models.
• Design, develop, and maintain conceptual, logical, and physical data models for Insurance (Life & Annuities and Property & Casualty) domains.
• Collaborate with business analysts, architects, developers, and data engineers to ensure alignment of data models with business objectives and enterprise architecture standards.
• Develop subject area models, data dictionaries, metadata, and data lineage documentation.
• Apply data modeling best practices, naming standards, governance principles, and modeling methodologies.
• Support data warehouse, reporting, analytics, and operational system initiatives through robust data model design.
• Perform data analysis, source-to-target mapping, and data profiling to support model development and data integration efforts.
• Review and optimize existing data models for performance, scalability, and maintainability.
• Participate in data governance initiatives and ensure consistency across enterprise data assets.

Required Skills & Qualifications

• 3-6 years of experience in Data Modeling, Data Architecture, or related data management roles.
• Strong domain expertise in Insurance, including:
  • Life & Annuities (Policy Administration, Claims, Billing, Underwriting, Customer, Financials)
  • Property & Casualty (Policy, Claims, Risk, Coverage, Premiums, Reinsurance)
• Hands-on experience with ERwin Data Modeler or other leading data modeling tools such as ER/Studio, PowerDesigner, SAP PowerDesigner, or Enterprise Architect.
• Strong knowledge of conceptual, logical, and physical data modeling techniques.
• Expertise in OLTP and OLAP data model design principles.
• In-depth understanding of normalization, denormalization, and Normal Forms (1NF through 5NF).
• Strong knowledge of Data Warehousing concepts including:
  • Snowflake Schema
  • Fact and Dimension Modeling
  • Slowly Changing Dimensions (SCD Type 1, 2, and 3)
• Experience creating enterprise data models, canonical data models, and integration data models.
• Strong SQL skills and ability to analyze complex data structures across multiple source systems.
• Understanding of data governance, metadata management, master data management (MDM), and data quality concepts.

Preferred Qualifications

• Experience with cloud data platforms such as Azure, AWS, Snowflake, Databricks, or Google Cloud.
• Knowledge of insurance industry data standards such as ACORD.
• Excellent communication and stakeholder management skills with the ability to work independently with clients and leadership teams.
• Strong documentation, presentation, and requirement-gathering capabilities.
• Business and technical stakeholder management
• Analytical and problem-solving abilities
• Data governance and standards adherence
• Communication and presentation skills
• Ability to work in an agile delivery environment