Data Modeling Technical Lead

Location

: Woodland Hills, CA

Experience

: 12

• 15 Years
  Apply By
  : 18th December 2026
  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