Data Modeller

Kryon knowledge works; Hyderabad, Chennai, Bengaluru; Hybride; INR 1 200 000 - 2 400 000; Plein temps

Résumé du poste

Kryon Knowledge Works Group is seeking a Lead Data Modeler to drive data modeling across Insurance domains (Life & Annuities, Property & Casualty) in a hybrid setup including Hyderabad. You will design conceptual, logical, and physical models and collaborate with cross-functional teams to ensure governance and data quality across enterprise data assets.

Responsibilities include engaging with stakeholders, creating data dictionaries and lineage, and optimizing models for performance and

Qualifications

• 3-10 years in Data Modeling, Data Architecture, or related data management roles.
• Strong Insurance domain knowledge: Life & Annuities; Property & Casualty.
• Hands-on with ERwin Data Modeler or other leading tools (ER/Studio/PowerDesigner).
• Strong SQL skills to analyze complex data structures across source systems.
• Knowledge of OLTP and OLAP modeling techniques.
• Understanding of normalization, denormalization, and 1NF–5NF.
• Familiarity with data warehousing concepts: Star/Snowflake, Fact/Dim, SCD.
• Experience creating enterprise, canonical, and integration data models.
• Experience with data governance, metadata, MDM, and data quality.

Responsabilités

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

Connaissances

Data Modeling

Data Architecture

SQL

OLTP/OLAP

Normalization/5NF

Data Governance

MDM

Data Warehousing

Stakeholder Management

Cloud Knowledge

Outils

ERwin Data Modeler

ER/Studio

PowerDesigner

SAP PowerDesigner

Enterprise Architect

Description du poste

Role: Data Modeler / Senior Data Modeler / Lead Data Modeler

Experience: 3 - 10 Years

Domain: Insurance (Life & Annuities and Property & Casualty)

Location: (Hybrid)- Bengaluru, Chennai, Hyderabad, Pune

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




• Star Schema


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


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