Summary

As an ETL Architect for the Data and Analytics team, at Guidewire you will participate in a leadership capacity collaborating with our customers and SI Partners who are adopting our Guidewire Data Platform as the centerpiece of their data foundation. You will work to drive consensus among all participants in projects to realize ETL Architecture goals of our customers adhering to Guidewire best practices and standards.

You will work with our customers, partners, and other Guidewire team members to deliver successful data transformation initiatives. You will utilize best practices for design, development and delivery of customer projects. You will share knowledge with the wider Guidewire Data and Analytics team to enable predictable project 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.

Job Description

Key Responsibilities:

Able to Design and propose high level design diagrams for overall system architecture
Lead Inception Sessions to build consensus on project scope, and generate user stories with acceptance criteria.
You will analyze complex data structures in legacy source systems and help the business and data analysts to map them to the Guidewire InsuranceSuite data model.
You will manage the end-to-end data loading process, including pre-load validation, execution of load jobs, and post-load verification.
You will optimize migration processes for performance, making configuration adjustments to improve speed and efficiency, particularly when dealing with large data volumes, to meet project SLAs.
Work with the PMO providing domain expertise to achieve successful project outcomes.
Lead efforts to harvest project collateral to build out collateral to enable repeatability.
Create new tooling to streamline data processing when called upon or when the opportunity presents itself
Systematic problem-solving approach, coupled with a sense of ownership and drive
Ability to work independently in a fast-paced Agile environment
At Guidewire, 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.

Qualifications

Bachelor's or Master's Degree in Computer Science, or equivalent level of demonstrable professional competency, and 10 years + in a technical capacity building out complex ETL Data Integration frameworks.
Deep understanding of the P&C insurance domain, including concepts like policies, claims, billing, and underwriting.
5 + years of Experience with data processing and ETL (Extract, Transform, Load) and ELT (Extract, Load, and Transform) concepts.
At least 3 years of experience leading design review sessions to build consensus among diverse groups of technical and business participants.
At least 3 years in a leadership capacity for delivering complex data transformation initiatives including mentoring and team building.
Experience working in Guidewire Data Migration/Data Platform projects.
Experience working with relational and/or NoSQL databases
Experience working with different cloud platforms (such as AWS, Azure, Snowflake, Google Cloud, etc.)
Experience working with customer teams to understand business objectives and functional requirements.
Familiarity in Change Data Capture (CDC) frameworks
Ability to work independently and within a team.
Demonstrated ability to embrace AI and apply it to your current role as well as data-driven insights to drive innovation, productivity, and continuous improvement.

Nice To Have

Insurance industry experience
Experience with AWS Glue
Experience with the Azure data factory
Experience with the Guidewire Data Platform
Previous large scale data migration experience of successfully migrating data from mainframe or other complex legacy systems.

About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 540+ insurers in 40 countries, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1600+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of applications that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software, Inc. is proud to be an equal opportunity and affirmative action employer. We are committed to an inclusive workplace, and believe that a diversity of perspectives, abilities, and cultures is a key to our success. Qualified applicants will receive consideration without regard to race, color, ancestry, religion, sex, national origin, citizenship, marital status, age, sexual orientation, gender identity, gender expression, veteran status, or disability. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.