Job ID: 114449-1
Job Title: Data Modeler / Technical Lead
Location: Woodland Hills, Los Angeles,CA- (Preferred)/Remote Work
Duration: 6 months
Pay Rate: $45-$50/hr on W2/C2C
Description:
Hands-on experience modeling event-based architectures and real-time consumption models, with a clearunderstanding that event, domain, state, and consumer projection models are related but distinct.
Required Skills and Experience:
· Event modeling: Business events, envelopes, payloads, state/snapshot events, versioning, ordering,correlation, and idempotency
· Domain-Driven Design: Bounded contexts, aggregates, domain events, and ubiquitous language,turned into durable data and event contracts
· Conceptual/logical modeling: Enterprise and domain models, semantic boundaries, canonicalconcepts, and reconciling heterogeneous sources
· Relational and NoSQL modeling: Temporal and historical design, plus access-pattern-drivendocument, key-value, and search models (graph preferred)
Streaming and data products: Event-streaming platforms, schema registries (Avro, JSON Schema, Protobuf), CDC, and state reconstruction
· Analytical/lakehouse modeling: Dimensional and history-oriented models, Iceberg/Delta-style architectures, and translating event and state models into analytical forms
· API and projection modeling: Consistent domain representations across events, APIs, transactional, analytical, and search stores · Governance: Semantic ownership, lineage, data quality, contract versioning, and model lifecycle in a large enterprise
· Collaboration: Working with domain SMEs, architects, engineers, and governance teams to produce reusable enterprise models
Preferred: Insurance/P&C and ACORD familiarity; large-enterprise modernization; hands-on AWS, Iceberg, Aurora/PostgreSQL, and OpenSearch/Elasticsearch.
Must Have Technical/Functional Skills:
· Expertise in Data Modeling tools like Erwin
· DataVault 2.0 Framework and Architecture
· Experience in Canonical modeling
· Analytical & Decision Making Skills
· Strong experience on RDBMS (AWS Aurora), NoSQL databases
· Technical & Domain Awareness: Property & Casualty Insurance domain(Auto, Home, Umbrella LOBs)
Experience Required: 15+
Role Descriptions: Hands-on experience modeling event-based architectures and real-time consumption models| with a clear understanding that event| domain| state| and consumer projection models are related but distinct.
Essential Skills: DBT| Snowflake
Desirable Skills:
Keyword:
Skills: Digital : Snowflake~Data Build Tool
Experience Required: 10 & Above