Data Modeller - Technical Lead
Lorven Technologies Inc
Newport Beach, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Newport Beach, United States of America
Tech stack
Query Performance
Code Coverage
Data Integration
Dimensional Modeling
Metadata
YAML
Data Processing
Snowflake
Collibra
Requirements
- 8+ years in enterprise data modeling with 3+ years leading modeling on complex, multi-source data platform programs
- Deep expertise in logical and physical data modeling - dimensional modeling (star/snowflake schemas), normalized models, and Snowflake-native wide-table patterns
- Hands-on Snowflake experience - schema design, clustering strategies, materialization types, and query performance fundamentals
- Strong command of dbt - translating logical model designs into modular dbt model structures, YAML schema definitions, and test coverage
- Experience integrating data models with a metadata governance platform (Collibra preferred) - business glossary, attribute-level lineage, and data contract definition
- Demonstrated ability to produce and maintain data dictionaries, ERDs, and source-to-target mapping documents across multi-domain enterprise programs
- Experience in a regulated industry (insurance, healthcare, or financial services) with awareness of PII/PHI data handling and compliance requirements
About the company
© 2026 Careerjet All rights reserved
