Solutions Engineer, Data (Guidewire Policy Center)

Liberty Mutual • Boston, MA

35d

About The Position

Role Summary: The Guidewire Data Migration Solution Engineer will play a key role in the successful migration of policy data from legacy to the new Guidewire PolicyCenter Cloud platform. This role requires deep expertise in data architecture, ETL design, and end to end data migration lifecycle execution in Guidewire PolicyCenter Cloud ensuring accuracy, completeness and auditability of migrated data. The engineer will collaborate with architecture, business and integration teams to design, build, and validate a scalable, high quality data migration framework that supports multiple state roll out.

Requirements

• Bachelor`s or Master`s degree in technical or business discipline or equivalent experience; technical Master`s degree preferred
• Generally a minimum of 10 years related experience
• 7+ years of experience in data migration or data integration related roles.
• Strong expertise in Guidewire PolicyCenter application and its data model.
• Hands-on experience with ETL Tools like Informatica (IDMC) or similar.
• Strong proficiency in SQL (PostgreSQL, DB2).
• Experience with cloud platforms (e.g., AWS, Snowflake).
• Hands-on experience building and deploying CI/CD pipelines (e.g., GitHub Actions, Bamboo) and Liquibase for database schema versioning.
• Exposure to Job Schedulers such as Control-M or Stonebranch.

Nice To Haves

• Guidewire Certified Associate or Ace Developer certification in PolicyCenter.
• Experience with PolicyCenter multi state rollout migration projects.
• Experience with Guidewire PolicyCenter Migration Tool (PMT).
• Intermediate experience using Python for data transformation, integration, and automation.
• Familiarity with Guidewire Cloud Data Access (CDA).

Responsibilities

• Design and implement end-to-end data migration solutions to the Guidewire PolicyCenter platforms.
• Develop and maintain ETL workflows for data extraction, transformation, and load using Informatica (IDMC) or equivalent tools.
• Design and implement reconciliation and audit frameworks to ensure data quality and completeness.
• Define mapping specifications between legacy policy systems and Guidewire target data models.
• Conduct data profiling, cleansing, and validation using tools like Informatica (IDMC) Data Quality, Cloud Data Governance & Catalog or SQL based profiling scripts.
• Partner with business and technical stakeholders to identify data gaps, transformation logic, and migration sequencing.
• Collaborate with infrastructure and Devops teams for environment set up, pipeline automation, and migration run scheduling.
• Lead data validation during System Integration and User AcceptanceTesting, resolving defects through analysis and fixes in ETL or mapping layers.
• Ensure compliance with data governance, PII handling and security standards.
• Participate in Agile sprint planning, backlog refinement and other agile ceremonies.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities
• Number of Employees: 5,001-10,000 employees