Data Migration Lead Architect

Guidewire Software

3d • $183,000 - $275,000

About The Position

Guidewire Professional Services is seeking a hands-on Guidewire Data Migration Lead Architect who will be responsible for leading the end-to-end process of migrating critical insurance data from our legacy systems into the Guidewire InsuranceSuite platform (PolicyCenter, ClaimCenter, and/or BillingCenter), utilizing Guidewire tools, standards and best practices. As a member of our organization, you will be expected to work with our customers, partners and other Guidewire team members to ensure successful delivery of your projects. In addition to your dedication to our customers' success you will share your knowledge and benefit of your experiences with other Guidewire colleagues, enhance our project methodology and build/expand our tooling to improve our project execution to enable predictable outcomes. In Guidewire Professional services, we provide implementation and production services to our customers around the world. We foster a culture of curiosity, innovation, and responsible use of AI, empowering our teams to continuously leverage emerging technologies and data-driven insights to enhance productivity and outcomes. One of our principles is to have fun while we deliver, so this role will need to keep the delivery process fun and engaging for the team in collaboration with the broader organization. Given the dynamic nature of the work in the Data and Analytics team, we are looking for decisive, highly-skilled technical problem solvers who are self-motivated and take proactive actions for the benefit of our customers and ensure that they succeed in their journey to Guidewire Cloud Platform. You will collaborate closely with teams located around the world and adhere to our core values Integrity, Collegiality, and Rationality.

Requirements

• Bachelor’s or Master’s Degree in Computer Science, or equivalent level of demonstrable professional competency, and 15 years + in delivery and/or consulting type role.
• Deep understanding of the P&C insurance domain, including concepts like policies, claims, billing, and underwriting.
• Hands-on experience with the Guidewire InsuranceSuite (PolicyCenter, BillingCenter, ClaimCenter).
• Hands-on experience with Guidewire Migration tools - PMT, CMT, BMT.
• Previous large scale data migration experience of successfully migrating data from mainframe or other complex legacy systems.
• Familiarity with data processing and ETL (Extract, Transform, Load) concepts.
• Strong OOP skills
• Experience working with relational and/or NoSQL databases.
• Proficiency in SQL for data validation, querying staging tables, and reconciliation.
• Excellent problem-solving skills and the ability to work effectively with complex datasets
• Effective leadership, interpersonal, and communication skills.
• Experience working with customer teams to understand business objectives and functional requirements, ability to lead and build consensus.
• Experience working in an Agile/Scrum development environment.
• Ability to work independently and within a team.

Nice To Haves

• Familiarity with AI Tools
• Familiarity with REST API
• Experience migrating into Guidewire InsuranceSuite from other core insurance platforms like Duck Creek, Majesco, WINS, Insurity etc
• Ability to leverage emerging technologies and AI in your role as well as use data-driven insights to foster innovation, boost productivity, and drive continuous improvement.
• Proficiency in Data Modeling, ETL, and cloud computing skills.
• Experience with ETL tools (e.g., Informatica PowerCenter, SSIS, Talend, AWS Glue, Azure Data Factory)
• Certification in any of Guidewire InsuranceSuite products.

Responsibilities

• Serve as the team lead for both onshore and offshore teams, working closely with business analysts, data analysts, legacy system SMEs, ETL developers, Guidewire configuration and Integration developers, and QA testers to translate data migration business requirements into technical solutions and deliver sprint goals.
• Define project scope, user stories, acceptance criteria and estimates.
• Analyze complex data structures in legacy source systems and help the business and data analysts to map them to the Guidewire InsuranceSuite data model.
• Install, configure, test, and run Guidewire migration tools - Policy Migration Tool (PMT), and/or Claim Migration Tool (CMT) and/or Billing Migration Tool (BMT), to perform data loads into the target Guidewire InsuranceSuite.
• Manage the end-to-end data loading process, including pre-load validation, execution of load jobs, and post-load verification.
• Optimize migration processes for performance, making configuration adjustments to improve speed and efficiency, particularly when dealing with large data volumes, to meet project SLAs.
• Identify, investigate, and resolve data quality issues, migration errors, and performance bottlenecks throughout the project lifecycle.
• Enable offshore teams to be successful in delivering agreed upon business requirements while conforming to Guidewire best practices & standards.
• Coordinate with the PMO to provide technical leadership when necessary.
• Be able to work in small teams and participate in a hands-on technical capacity when needed for meeting project goals.
• Work within the broader Guidewire data team to improve our internal processes and methodology.
• Participate in the creation of new tooling to support and streamline our project outcomes.
• Be a self-motivated problem-solver who takes initiative and always puts customer success first.
• Adapt and perform at a high level in a demanding fast-paced Agile environment.

Benefits

• All full-time positions or part-time roles working 30 hours or more a week at Guidewire are eligible for benefits that support their health and well-being including health, dental, and vision insurance, paid time off, and a company sponsored retirement plan.
• In addition, some roles may be eligible for the annual company bonus plan, commissions, and/or long term incentive awards which are contingent on a variety of factors including, but not limited to, company and employee performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees