Guidewire Claim Center data mapper

• Jobseeker Video Testimonials
  
• Employee Glassdoor Reviews
  

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long-term project. Here are a few details.

Requirements

We are seeking a highly skilled Data Mapper to support the migration of Property & Casualty (P&C) insurance claims data from legacy systems into Guidewire ClaimCenter. The ideal candidate will possess strong P&C insurance domain knowledge hands-on experience with Guidewire ClaimCenter data models and advanced SQL expertise to analyze map and validate data during large-scale data migration initiatives. This role requires close collaboration with both business and technical teams to ensure data accuracy consistency and completeness throughout the migration lifecycle.

Key Responsibilities

Data Analysis & Mapping

• Analyze legacy claims data structures tables and relationships to understand source system data.
  

• Map legacy system data elements to corresponding Guidewire ClaimCenter entities extensions and typelists.
  

• Define transformation logic default values and business rules required for accurate data migration.
  

SQL & Data Validation

• Develop optimize and execute SQL queries to extract transform and validate data from legacy systems.
  

• Perform data profiling reconciliation and validation to ensure migrated data meets business and technical requirements.
  

• Identify data gaps inconsistencies and anomalies and work with stakeholders to resolve issues.
  

Collaboration & Stakeholder Engagement

• Work closely with claims business users data architects ETL developers and Guidewire technical teams.
  

• Participate in design discussions walkthroughs and data validation sessions with business stakeholders.
  

• Support testing phases including unit testing system testing and user acceptance testing (UAT).
  

Documentation & Governance

• Create and maintain detailed data mapping documents transformation specifications and validation rules.
  

• Document data issues resolutions and assumptions for auditability and knowledge transfer.
  

• Ensure adherence to data governance compliance and best practices during migration.
  

Required Qualifications

Technical Skills

• Strong proficiency in SQL (complex joins subqueries performance tuning).
  

• Hands-on experience with data mapping and ETL processes for large datasets.
  

• Solid understanding of Guidewire ClaimCenter data model including core entities and extensions.
  

• Experience working with relational databases (Oracle SQL Server or similar).
  

Domain Expertise

• Proven experience in Property & Casualty (P&C) insurance specifically claims data.
  

• Strong understanding of claims lifecycle coverages exposures reserves payments recoveries and loss details.
  

Professional Experience

• 5 years of experience in data migration data mapping or data analysis roles (Guidewire preferred).
  

• Prior experience supporting Guidewire ClaimCenter implementations or upgrades is highly desirable.
  

Preferred Qualifications

• Experience with Guidewire data migration tools or frameworks.
  

• Familiarity with ETL tools (Informatica Talend DataStage or similar).
  

• Experience working in Agile/Scrum environments.
  

• Strong analytical problem-solving and communication skills.
  

Additional Information

• Ability to work independently and manage multiple data streams simultaneously.
  

• Strong attention to detail and commitment to data accuracy.
  

• Excellent documentation and stakeholder communication skills.
  

Benefits