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." </div

Requirements

Must-haves

Role - Data Modeling Technical Lead
Experience Required - 15+ years
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
Roles & Responsibilities

Nice-to-haves

Location - Woodland Hills, California (Preferred)
Graph modeling experience preferred

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awsapi

Platform: careers-page
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Parental Leave