Role: Technical Lead
Required Skills: Data Modeling
Experience: 12 - 15 Years
Function: TECHNOLOGY
Apply By: 2026-12-18
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."