Job Description:

Key Responsibilities

• 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:

o Life & Annuities (Policy Administration, Claims, Billing, Underwriting, Customer, Financials)

o 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.

• Robust 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:

o Star Schema

o Snowflake Schema

o Fact and Dimension Modeling

o 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.

• Experience supporting large-scale digital transformation, modernization, or enterprise data programs.

• Excellent communication and stakeholder management skills with the ability to work independently with clients and leadership teams.

• Strong documentation, presentation, and requirement-gathering capabilities.

Key Competencies

• Client-facing consulting experience

• Business and technical stakeholder management

• Analytical and problem-solving abilities

• Data governance and standards adherence

• Communication and presentation skills

• Enterprise data architecture mindset

• Ability to work in an agile delivery environment

📌 Sr. Data Modeler - Immediate Joiner (Secunderabad)
🏢 Digital Business People
📍 Secunderabad