

RIIM
Data Modeler with P&C Insurance
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler with P&C Insurance, offering a contract length of "unknown" at a pay rate of "unknown." Key skills include 15 years in Data and Insurance, 10+ years in data modeling, strong P&C insurance knowledge, and proficiency in SQL and ERwin.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
May 15, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York, United States
-
🧠 - Skills detailed
#Data Design #Data Modeling #ERWin #Normalization #SQL (Structured Query Language) #Slowly Changing Dimensions
Role description
Required Skills & Qualifications
• 15 years years strong experience in Data and Insurance .
• 10+ years of experience in data modeling and data design (adjust as needed).
• Strong P&C insurance domain knowledge, especially in:
• Claims (FNOL, reserves, payments, recoveries/subrogation)
• Policy (quotes, endorsements, renewals, cancellations, coverages)
• Broker/Producer (hierarchies, commissions, appointments)
• Insured / Party (customer, risk/locations, roles, relationships)
• Hands-on expertise creating ER models and dimensional models for analytics.
• Strong command of modeling concepts: normalization, referential integrity, slowly changing dimensions, surrogate keys, etc.
• Experience with Erwin Modeling tool
• Proficiency with SQL and ability to validate data through analysis and profiling.
• Strong communication skills with the ability to work with cross-functional and distributed/offshore teams.
Required Skills & Qualifications
• 15 years years strong experience in Data and Insurance .
• 10+ years of experience in data modeling and data design (adjust as needed).
• Strong P&C insurance domain knowledge, especially in:
• Claims (FNOL, reserves, payments, recoveries/subrogation)
• Policy (quotes, endorsements, renewals, cancellations, coverages)
• Broker/Producer (hierarchies, commissions, appointments)
• Insured / Party (customer, risk/locations, roles, relationships)
• Hands-on expertise creating ER models and dimensional models for analytics.
• Strong command of modeling concepts: normalization, referential integrity, slowly changing dimensions, surrogate keys, etc.
• Experience with Erwin Modeling tool
• Proficiency with SQL and ability to validate data through analysis and profiling.
• Strong communication skills with the ability to work with cross-functional and distributed/offshore teams.






