Description

Lead the design and development of conceptual, logical, and physical data models for enterprise life insurance initiatives.

This role is hybrid.

Responsibilities

• Design data models for policy administration, claims, underwriting, actuarial, and customer domains.
• Translate business requirements into scalable models, maintaining data dictionaries, ERDs, and metadata.
• Ensure models align with enterprise architecture and regulatory standards like NAIC, IFRS 17, and SOX.
• Collaborate with ETL and data governance teams to support data lineage and master data management.
• Optimize existing data models for performance and integrity within OLTP and OLAP environments.

Required Skills

• 7+ years in data modeling, including 3+ years in the life insurance domain.
• Proficiency with modeling tools: Erwin, ER/Studio, SAP PowerDesigner, or IBM InfoSphere Data Architect.
• Strong expertise in relational databases: Oracle, SQL Server, PostgreSQL.
• Experience with data warehouse platforms: Snowflake and Redshift.
• Deep knowledge of 3NF, Data Vault, dimensional modeling, and normalization techniques.
• Advanced SQL skills for understanding and optimizing complex queries.
• Understanding of insurance data structures: products, riders, beneficiaries, premiums, claims.
• Familiarity with data governance, data quality, and metadata management practices.

Preferred Skills

• Experience with cloud platforms: AWS, Azure, or GCP.
• Exposure to life insurance systems: Ingenium, ALIP, Vantage, or AdminServer.
• Knowledge of data integration tools: Informatica, Talend, or SSIS.

Key Skills

Education

Any Gradute