Life Insurance Data Modeler | SQL & Analytics

Tata Consultancy Services Limited; West Des Moines (IA); On-site; USD 90,000 - 110,000; Full time

Job summary

Tata Consultancy Services Limited in West Des Moines, IA is seeking a data architect to design conceptual, logical, and physical models for life insurance and annuity data domains. You will define entities, relationships, keys, data grain, and support analytics with enterprise data platforms.

Collaborate with business stakeholders, architects, and engineers to map source data, create mappings and documentation, validate definitions, and drive data quality. Salary range: $90,000-$110,000 per year.

Qualifications

• Experience with life insurance and annuity data, including policies, products, premiums, customers, producers or agents, and related business processes.
• Strong conceptual, logical, and physical data modeling skills, particularly for relational databases and data warehouses.
• Ability to define entities, attributes, relationships, primary and foreign keys, data grain, and historical data requirements.
• Proficiency in SQL and experience analyzing source data, mapping fields, and documenting business definitions and data models.

Responsibilities

• Develop and maintain conceptual, logical, and physical models for life insurance and annuity data domains.
• Define consistent business entities and relationships across source systems, enterprise data platforms, and reporting.
• Review source structures and data flows; create mappings and documentation that support integration and analytics.
• Partner with business and technical teams to validate definitions, resolve modeling issues, and support data quality.

Skills

Data Modeling

SQL

Life Insurance Domain

Job description

Tata Consultancy Services Limited in West Des Moines, IA is seeking a data architect to design conceptual, logical, and physical models for life insurance and annuity data domains. You will define entities, relationships, keys, data grain, and support analytics with enterprise data platforms.

Collaborate with business stakeholders, architects, and engineers to map source data, create mappings and documentation, validate definitions, and drive data quality. Salary range: $90,000-$110,000 per year.