:

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 (Hyderabad)
🏢 Digital Business People
📍 Hyderabad