Data Modeler

Required

Looking Senior from 12+ to 20+ years (perferred Califonia Candidate)

Enterprise data modeling with 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

preferred

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