Data Modeler Lead

HG Solutions

Job Location:

San Diego, CA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Data Modeler Lead

Location: San Diego CA (Onsite)
Experience Required: 12 years hands-on in Data Modeling with Insurance domain background.

Responsibilities & Skills

Data Modeling: Logical and Physical Data Models for Snowflake Data Warehouse/Data Mart layers.
Tools: Strong experience with Erwin Data Modeler.
SCD Types: Developing SCD1 SCD2 and SCD3 dimension models.
Technical Stack: Snowflake DBT pipelines Power BI and SQL.
Data Analysis: Handling JSON/XML structures schema interpretation and source payload analysis.
Domain Expertise: Workers Compensation (WC) Commercial Multi-Peril (CMP) Excess Surplus (ES) and Excess Casualty.

Data Modeler Lead Location: San Diego CA (Onsite) Experience Required: 12 years hands-on in Data Modeling with Insurance domain background. Responsibilities & Skills Data Modeling: Logical and Physical Data Models for Snowflake Data Warehouse/Data Mart layers. Tools: Strong experience with Erwin ...