Solutions Engineer, Data (Guidewire Policy Center)

Description
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.
Key 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.

Qualifications

• 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
• Required Technical Skills:
  
  • 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.
  
  Preferred Skills:
  
  • 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).

About Us
Pay Philosophy: The typical starting salary range for this role is determined by a number of factors including skills, experience, education, certifications and location. The full salary range for this role reflects the competitive labor market value for all employees in these positions across the national market and provides an opportunity to progress as employees grow and develop within the role. Some roles at Liberty Mutual have a corresponding compensation plan which may include commission and/or bonus earnings at rates that vary based on multiple factors set forth in the compensation plan for the role.
At Liberty Mutual, our goal is to create a workplace where everyone feels valued, supported, and can thrive. We build an environment that welcomes a wide range of perspectives and experiences, with inclusion embedded in every aspect of our culture and reflected in everyday interactions. This comes to life through comprehensive benefits, workplace flexibility, professional development opportunities, and a host of opportunities provided through our Employee Resource Groups. Each employee plays a role in creating our inclusive culture, which supports every individual to do their best work. Together, we cultivate a community where everyone can make a meaningful impact for our business, our customers, and the communities we serve.
We value your hard work, integrity and commitment to make things better, and we put people first by offering you benefits that support your life and well-being. To learn more about our benefit offerings please visit: https://LMI.co/Benefits
Liberty Mutual is an equal opportunity employer. We will not tolerate discrimination on the basis of race, color, national origin, sex, sexual orientation, gender identity, religion, age, disability, veteran's status, pregnancy, genetic information or on any basis prohibited by federal, state or local law.
Fair Chance Notices

• California

• Los Angeles Incorporated

• Los Angeles Unincorporated

• Philadelphia

• San Francisco

USD $134000.00 - $254000.00