Data Modeling Technical Lead

Tata Consultancy Services; Los Angeles (CA); On-site; USD 108,000 - 135,000; Full time

Benefits offered by this job

Annual incentive

Medical coverage

Dental & Vision

Disability insurance

401K plan

Parental leave

Training reimbursement

Vacation & holidays

Commuter benefits

Job summary

Tata Consultancy Services Limited is seeking a Data Modeling Technical Lead in Woodland Hills, CA. The role focuses on enterprise, domain, event, and analytical models for real-time consumption within an event-based architecture.

Required expertise includes Data Vault 2.0, canonical modeling, RDBMS/NoSQL databases like AWS Aurora, and deep insurance domain knowledge, particularly Property & Casualty lines. Collaboration with architects, engineers, and governance teams is essential.

Qualifications

• Expertise in data modeling tools such as Erwin.
• Data Vault 2.0 framework and architecture.
• Canonical modeling.
• Strong experience with RDBMS and NoSQL databases.
• Experience with AWS Aurora and OpenSearch/Elasticsearch.
• Insurance domain knowledge in Property & Casualty.

Responsibilities

• Model event-based architectures and real-time consumption models.
• Translate bounded contexts and domain events into durable data contracts.
• Develop enterprise and domain models and reconcile heterogeneous data sources.
• Design temporal and historical relational models and NoSQL models.
• Work with event-streaming platforms, schema registries, and CDC.

Skills

Data Modeling

Data Vault 2.0

Canonical modeling

RDBMS/AWS Aurora

NoSQL databases

Event modeling

Domain-Driven Design

Insurance domain knowledge

AWS

OpenSearch/Elasticsearch

Tools

Erwin

Job description

Role - Data Modeling Technical Lead

Location - Woodland Hills, California (Preferred)

Experience Required - 15+ years

Job Summary

The Senior Data Modeler will design enterprise, domain, event, transactional, analytical, and projection models supporting event-based architectures and real-time consumption. The role requires expertise in data modeling tools, Data Vault 2.0, canonical modeling, relational and NoSQL databases, streaming data products, data governance, and Property & Casualty insurance concepts. This position will collaborate with domain subject-matter experts, architects, engineers, and governance teams to create reusable enterprise models.

Must Have Technical/Functional Skills

• Expertise in data modeling tools such as Erwin
• Data Vault 2.0 framework and architecture
• Experience in canonical modeling
• Analytical and decision-making skills
• Strong experience with RDBMS, including AWS Aurora, and NoSQL databases
• Technical and domain knowledge of Property & Casualty insurance, including Auto, Home, and Umbrella lines of business
• Event modeling, including business events, envelopes, payloads, state and snapshot events, versioning, ordering, correlation, and idempotency
• Domain-Driven Design, including bounded contexts, aggregates, domain events, and ubiquitous language
• Conceptual and logical modeling, including enterprise and domain models, semantic boundaries, canonical concepts, and reconciliation of heterogeneous sources
• Relational and NoSQL modeling, including temporal and historical design and access-pattern-driven document, key-value, and search models
• Event-streaming platforms, schema registries, CDC, and state reconstruction
• Analytical and lakehouse modeling, including dimensional and history-oriented models and Iceberg/Delta-style architectures
• API and projection modeling across events, APIs, transactional, analytical, and search stores
• Data governance, including semantic ownership, lineage, data quality, contract versioning, and model lifecycle
• Insurance and Property & Casualty experience
• Familiarity with ACORD
• Large-enterprise modernization experience
• Hands-on experience with AWS, Iceberg, Aurora/PostgreSQL, and OpenSearch/Elasticsearch
• Graph modeling experience preferred

Roles & Responsibilities

• Model event-based architectures and real-time consumption models while distinguishing between event, domain, state, and consumer projection models.
• Translate bounded contexts, aggregates, domain events, and ubiquitous language into durable data and event contracts.
• Develop enterprise and domain models, define semantic boundaries and canonical concepts, and reconcile heterogeneous data sources.
• Design temporal and historical relational models and access-pattern-driven NoSQL models.
• Work with event-streaming platforms, schema registries such as Avro, JSON Schema, and Protobuf, change data capture, and state reconstruction.
• Translate event and state models into dimensional, history-oriented, and lakehouse analytical models.
• Maintain consistent domain representations across events, APIs, transactional systems, analytical platforms, and search stores.
• Support semantic ownership, lineage, data quality, contract versioning, and model lifecycle governance.
• Collaborate with domain subject-matter experts, architects, engineers, and governance teams to produce reusable enterprise models.

Base Salary Range :

$108,000 to $135,000 Per Annum

TCS Employee Benefits Summary:

"Discretionary Annual Incentive. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. Family Support: Maternal & Parental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing."

Location

Woodland Hills, CA

Function

TECHNOLOGY

Role

Technical Lead

ID

437157

Skills

Data Modeling

Salary Range

$108,000 - $150,000