Data Modeler

Data Modeler / Technical Lead

Full Time / Contract (W2/C2C)

Newport Beach, CA 92660

Role Summary – We are looking for a hands-on Data Modelling Technical Lead to own the target-state logical and physical data model for a Fortune 500 enterprise’s multi-wave, enterprise-scale data modernization program. You will design and govern Snowflake-native dimensional and relational models across 9 certified data products — spanning Policy, Claims, Finance, Actuarial, and MDM domains — and establish the ACORD-based modeling standards that the full delivery team will build on. Working directly alongside the onshore Technical Architect, you will be the authoritative voice on schema quality, naming conventions, and Collibra-aligned lineage definitions throughout this multi-year engagement.

Why This Role Matters – The foundation of every certified data product in this program is the data model — get it right and 27 engineers build on a stable, reusable, lineage-ready schema; get it wrong and technical debt compounds across three waves and 80 source systems. This engagement migrates 372 production database instances into a unified Snowflake cloud-native platform, and the customer’s ACORD-based enterprise model must accommodate insurance domain complexity at scale while remaining dbt-compatible and Collibra-governed. The onshore placement is intentional — direct, synchronous engagement with the customer’s domain SMEs is how modeling decisions get made fast and right.

Skills / Experience

• 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
• Tech Stack Snapshot – Snowflake, dbt (data build tool), AWS S3, Matillion, Collibra, Profisee MDM, Python, SQL, Snowflake Data Metric Functions (DMFs), SnowConvert AI, ACORD Data Model, CI/CD (Azure DevOps), Git

Good to Have

• Familiarity with ACORD Life & Annuity data standards — Policy, Claims, Party, Product, Actuarial domain entities
• Insurance domain knowledge across life insurance, annuities, reinsurance, or employee benefits product lines
• SnowPro Core or SnowPro Advanced: Data Engineer certification

Exposure to Profisee MDM or equivalent enterprise MDM platforms and how golden record schemas integrate into Lakehouse layers