Data Modeler

Role: Data Modeler - Large Commercial Insurance

Location: Edison - New Jersey - USA Remote

Contract

Skills:

Mandatory Skills: Snowflake, Snowflake Administration

Primary Skills

Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake

Experience in translating business requirements into logical and physical data model

Ability to perform data analysis on source data to come up with relevant models

Experience in developing SCD1SCD2SCD3 Dimension Data models and data warehouse

Define data entities attributes and relationships based on business requirements data sources and analytical needs

Map source data structures to target data models and schemas ensuring data consistency integrity and quality during the ingestion process

Strong experience working with Erwin Data Modeler for conceptual logical and physical models

Strong in Snowflake data warehousing concepts staging curated layers marts

Strong SQL skills with the ability to validate transformations and model outputs

Insurance Domain Expertise Underwriting Policy Administration Claims Reinsurance

Secondary Skills

Data Vault Modelling

Master Data Management MDM

Metadata Management Canonical Data Models

Data Governance Data Lineage Data Quality Frameworks

AWS Azure Cloud Platforms

Soft Skills

Communication Skills Ability to interact with business users architects analysts and developers to understand and clarify requirements

Analytical Thinking Ability to understand complex business processes and translate them into structured data models

Stakeholder Management Ability to collaborate effectively with business SMEs project teams and leadership across multiple functions

Attention to Detail Ensuring accuracy in data models relationships naming conventions and data definitions

Problem-solving Skills Ability to identify data issues assess impacts of system changes and recommend effective solutions