Description

You will lead the design and development of conceptual, logical, and physical data models to support enterprise life insurance data initiatives.

Responsibilities

• Design and develop data models for policy administration, claims, underwriting, actuarial, and customer data domains.
• Translate business requirements into scalable models, maintaining data dictionaries, ERDs, and metadata documentation.
• Ensure all models align with industry standards, enterprise architecture, and regulatory requirements like NAIC, IFRS 17, and SOX.
• Collaborate with ETL, data governance, and data quality teams to support data lineage and master data management.
• Optimize existing data models for performance and integrity within OLTP and OLAP environments.
• Support dimensional modeling using star and snowflake schemas for warehousing and analytics.

Required Skills

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

Preferred Skills

• Experience with cloud platforms including AWS, Azure, or GCP.
• Exposure to life insurance systems such as Ingenium, ALIP, Vantage, or AdminServer.
• Knowledge of data integration tools like Informatica, Talend, or SSIS.
• Experience working within Agile/Scrum methodologies.

Key Skills

Education

Any Gradute