Summary

At Guidewire, we transform how the world’s P&C insurers do business by combining digital, core, analytics, and AI through our cloud data platform. As a Software Engineer 2 (Data & BI), you will build trusted data products, reporting datasets, and business intelligence experiences that help teams make informed decisions. You will join PDO—an organization focused on operational excellence, transformative innovation, customer success, and accelerating AI, cloud, and data-platform adoption. Your work will help deliver secure, scalable solutions and measurable value for Guidewire customers.
Growth is shared and shaped by the people we work with and the experiences we create together. You will learn by doing, collaborate with colleagues and stakeholders, and contribute to an inclusive culture that welcomes different perspectives and values every voice. This is an opportunity to grow your technical and professional journey while helping advance Guidewire’s mission in a supportive, globally connected environment.

Job Description

What you will do:

• Architect, construct, and maintain business intelligence solutions that enable data-informed decision-making across the Guidewire Data Platform.

• Engage with stakeholders to understand business needs and translate requirements into clear technical specifications and deliverable analytics solutions.

• Design, implement, and tune analytical data models, including star and snowflake schemas, and develop optimized SQL for efficient extraction and transformation.

• Develop and support interactive dashboards and analytical reporting using modern BI platforms such as ThoughtSpot.

• Establish testing and validation standards that promote data integrity, accuracy, completeness, and reliability.

• Engineer reporting datasets and ETL/ELT transformation pipelines using AWS cloud technologies, with a focus on Amazon Redshift.

• Use Python or suitable programming languages to automate validation checks, data-quality processes, and repeatable analytical routines.

• Use AI-assisted developer tools, including Claude Code and Gemini, to support development, debugging, analysis, and technical documentation; review and validate all generated output before production use.

• Maintain clear documentation for data models, transformation logic, KPI definitions, dashboards, and operational procedures to support knowledge transfer and reuse.

What you need to succeed:

• 6+ years of experience in business intelligence development or a related engineering role, with a proven track record of successful projects.

• Experience developing data, analytics, business intelligence, or reporting solutions in a software engineering or data engineering environment.

• Strong SQL skills, including advanced querying (complex joins, window functions, CTEs, aggregations), query optimization, data transformation, and analytical problem-solving.

• Experience designing dimensional data models, including star and snowflake schemas.

• Experience with cloud-based data platforms and services, preferably AWS and Amazon Redshift.

• Experience building dashboards and reports with a modern BI platform; ThoughtSpot experience is a plus.

• Proficiency in Python or another programming language used for automation and data processing.

• Familiarity with ETL/ELT development, data-quality testing, validation, and deployment practices.

• Working knowledge of Git/GitHub, code reviews, and collaborative software development workflows.

• Ability to communicate clearly with technical and non-technical stakeholders and convert business requirements into maintainable solutions.

• Strong analytical judgment, attention to detail, and commitment to data integrity.

• Willingness to learn new technologies, including AI-assisted development tools, and apply appropriate technical review and quality controls.

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.