Software Engineer - Data and Business Intelligence

Guidewire Software Solutions India Private Limited; Bengaluru; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Guidewire is seeking a Senior Software Engineer II/III for Data & BI in Bengaluru, India. You will architect and maintain BI solutions on the Guidewire Data Platform, enabling data-informed decisions across the organization.

You will design analytical data models (star/snowflake), develop optimized SQL, and build dashboards using ThoughtSpot or similar tools, while leveraging AWS and Redshift for data pipelines.

Qualifications

• 6+ years of BI or data engineering experience.
• Strong SQL with complex joins, window functions, or CTEs.
• Experience with AWS and Amazon Redshift.
• Experience building dashboards and reporting.
• Familiarity with ETL/ELT development and data quality.

Responsibilities

• Architect and maintain BI solutions on the Guidewire Data Platform.
• Translate business needs into technical specifications and analytics.
• Design and optimize analytical data models (star/snowflake).
• Develop dashboards and analytical reporting using BI tools.

Skills

SQL

Dimensional modeling

ThoughtSpot

Python

Git/GitHub

Analytical thinking

Tools

AWS

Amazon Redshift

Job description

Software Engineer II / Software Engineer III (Data & BI) 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.

Experience Level Senior Level