Role: Data Modeling Technical Lead
Location: Woodland Hills, CA (REMOTE)
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