Data Modeler / Data modeling specialist with P&C Insurance Domain

Immediate need for a talented  Data Modeler / Data modeling specialist with P&C Insurance Domain. This is a 06+months contract opportunity with long-term potential and is located in Hartford, CT (Hybrid). Please review the job description below and contact me ASAP if you are interested.

Job Diva ID- 26-13632

Pay Range: $50   - $63 /hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities

• *Note- The resource will be in direct touch with Business teams.
• Business & Domain Engagement
• Partner with business SMEs, underwriting, actuarial, and product teams to understand insurance product structures, coverage, rating, policy, premium, claims, and exposure concepts across WC, CMP, UMB, and GL.
• Lead requirements elicitation sessions to translate business needs into conceptual and logical data models.
• Explain data models in business-friendly terminology, ensuring shared understanding and signoff.
• Data Modeling & Architecture
• Extend and customize the OMG Insurance Industry Data Model to support new lines of business while maintaining crossLOB consistency.
• Design and maintain:
• Conceptual Data Models reflecting business entities and relationships
• Logical Data Models with normalized structures, attributes, and rules
• Physical Data Models optimized for Lakehouse (Client / Parquetbased) storage
• Ensure models support multisource integration, including:
• Legacy RQI systems
• Guidewire platform (PolicyCenter, ClaimCenter, BillingCenter as applicable)
• Lakehouse & Modern Data Platform Alignment
• Design models aligned with Lakehouse architecture principles, supporting both:
• Operational analytics and reporting
• Advanced analytics and downstream data products
• Work closely with data engineers to ensure models align with medallion architecture (Bronze/Silver/Gold) patterns.
• Define data standards for:
• Keys, hierarchies, grain
• Slowly Changing Dimensions (SCD)
• Conformed dimensions across LOBs
• Data Quality, Governance & Metadata
• Ensure data models adhere to enterprise data governance standards.
• Define business definitions, data lineage, and metadata required for effective data cataloging.
• Support data quality rule definition in collaboration with data governance teams.
• Collaboration & Delivery
• Collaborate with solution architects, data engineers, BI teams, and QA to ensure seamless implementation.
• Participate in design reviews and ensure modeling best practices are consistently applied.
• Support incremental delivery as new products and coverages are onboarded.

Key Requirements and Technology Experience: 

• Must have skills: - “P&C", "Teradata", “SQL”, "Data Modeler
• Must haves - 11+ years of expr.
• Data Modeler
• Tera data
• Expr with Cloud - (Unity)
• SQL Server
• Strong experience in Property & Casualty (P&C) Insurance, specifically:
• WC, CMP, General Liability, Umbrella
• Policy, premium, coverage, exposure, claims, and risk entities
• Hands-on experience working with OMG Insurance Industry Data Model (customization and extension).
• Data Modeling Expertise
• Proven expertise in Conceptual, Logical, and Physical Data Modeling.
• Experience modeling enterprise-scale insurance data platforms.
• Strong understanding of dimensional and normalized modeling patterns.
• Technology & Platform
• Experience with modern data platforms / Lakehouse architectures (Databricks, Client Lake, Client, or equivalent).
• Familiarity with Guidewire data structures is strongly preferred.
• Experience integrating legacy systems and modern platforms into a unified model.
• Tools & Methods
• Proficiency in data modeling tools ERwin
• Ability to document models using clear business definitions and metadata artifacts

Our client is a leading  IT industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

By applying to our jobs, you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .

#accJ2W:CB3