Data Modeler

Tata Consultancy Services; 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

Job Description

Preferred Qualifications

• Experience working 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.
• Ability to work with business stakeholders, architects, and engineers to turn requirements into practical data designs.

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

Salary Range- $90,000-$110,000 a year

Location

West Des Moines, IA

Skills

• Data Modeling