What are the responsibilities and job description for the Solutions Engineer, Data (Guidewire Policy Center) position at Liberty Mutual Insurance Group?
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. 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. 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).