HIRING STREET
Data Modeler — Insurance (Life & Annuity)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Data Modeler — Insurance (Life & Annuity) for a contract of unspecified length, paying $36.70 - $44.20 per hour, located onsite in Boston/NY. Key skills include data modeling, Amazon Redshift, and advanced SQL, with insurance domain expertise required.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
352
-
🗓️ - Date
February 12, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Boston, NY 14025
-
🧠 - Skills detailed
#Redshift #Amazon Redshift #Compliance #Data Analysis #SQL (Structured Query Language) #Data Governance #Cloud #Metadata #Data Architecture #Snowflake #Data Modeling #Data Engineering #Data Warehouse #SQL Queries #Datasets #Physical Data Model #BI (Business Intelligence) #EDW (Enterprise Data Warehouse) #Scala #Data Management
Role description
Position Name: Data Modeler — Insurance (Life & Annuity)
Location: Boston/NY-Onsite
Client: One of the world’s largest wealth management firm
Description:
We are seeking an experienced Data Modeler for one of our clients with strong domain expertise in Insurance (Life & Annuity) to design and maintain scalable enterprise data models that support analytics, financial reporting, actuarial valuation, risk, and regulatory reporting. The ideal candidate will have deep experience in data warehousing, dimensional modeling, and Amazon Redshift, along with the ability to translate complex insurance business requirements into robust analytical data structures.
Role and Responsibilities:
Data Modeling
· Design and maintain conceptual, logical, and physical data models for insurance data platforms.
· Develop dimensional (star/snowflake) and canonical data models supporting:
o Policy administration
o Premiums and billing
o Claims
o Reinsurance
o Actuarial data
o Investment data
· Translate insurance business, regulatory, actuarial, and financial reporting requirements into scalable analytical data models.
· Ensure data consistency, integrity, and governance standards across enterprise data assets.
· Design models that support risk reporting, valuation, financial reporting, and compliance.
Technical Responsibilities
· Design and optimize data models in Amazon Redshift enterprise data warehouse environments.
· Apply MPP data warehouse design principles and performance optimization techniques.
Write advanced SQL queries for:
o Data validation
o Reconciliation
o Data analysis
· Collaborate closely with:
o Data Engineering teams
o BI/Analytics teams
o Actuarial teams
o Insurance business stakeholders
Required Qualifications:
· Strong experience in data modeling within the insurance domain (Life & Annuity preferred).
· Expertise in dimensional modeling and canonical data modeling.
· Hands-on experience with Amazon Redshift.
· Strong understanding of enterprise data warehousing and MPP architecture.
· Advanced SQL skills.
· Ability to translate business and actuarial requirements into technical data models.
· Strong collaboration and communication skills.
Preferred / Nice to Have:
· Experience working with insurance policy administration systems.
· Familiarity with actuarial and financial reporting datasets.
· Experience in data governance and metadata management.
· Exposure to cloud data platforms and modern data architectures.
Job Type: Contract
Pay: $36.70 - $44.20 per hour
Expected hours: 40 per week
Benefits:
401(k)
Work Location: In person
Position Name: Data Modeler — Insurance (Life & Annuity)
Location: Boston/NY-Onsite
Client: One of the world’s largest wealth management firm
Description:
We are seeking an experienced Data Modeler for one of our clients with strong domain expertise in Insurance (Life & Annuity) to design and maintain scalable enterprise data models that support analytics, financial reporting, actuarial valuation, risk, and regulatory reporting. The ideal candidate will have deep experience in data warehousing, dimensional modeling, and Amazon Redshift, along with the ability to translate complex insurance business requirements into robust analytical data structures.
Role and Responsibilities:
Data Modeling
· Design and maintain conceptual, logical, and physical data models for insurance data platforms.
· Develop dimensional (star/snowflake) and canonical data models supporting:
o Policy administration
o Premiums and billing
o Claims
o Reinsurance
o Actuarial data
o Investment data
· Translate insurance business, regulatory, actuarial, and financial reporting requirements into scalable analytical data models.
· Ensure data consistency, integrity, and governance standards across enterprise data assets.
· Design models that support risk reporting, valuation, financial reporting, and compliance.
Technical Responsibilities
· Design and optimize data models in Amazon Redshift enterprise data warehouse environments.
· Apply MPP data warehouse design principles and performance optimization techniques.
Write advanced SQL queries for:
o Data validation
o Reconciliation
o Data analysis
· Collaborate closely with:
o Data Engineering teams
o BI/Analytics teams
o Actuarial teams
o Insurance business stakeholders
Required Qualifications:
· Strong experience in data modeling within the insurance domain (Life & Annuity preferred).
· Expertise in dimensional modeling and canonical data modeling.
· Hands-on experience with Amazon Redshift.
· Strong understanding of enterprise data warehousing and MPP architecture.
· Advanced SQL skills.
· Ability to translate business and actuarial requirements into technical data models.
· Strong collaboration and communication skills.
Preferred / Nice to Have:
· Experience working with insurance policy administration systems.
· Familiarity with actuarial and financial reporting datasets.
· Experience in data governance and metadata management.
· Exposure to cloud data platforms and modern data architectures.
Job Type: Contract
Pay: $36.70 - $44.20 per hour
Expected hours: 40 per week
Benefits:
401(k)
Work Location: In person
