Senior Software Engineer

About Chubb

Chubb is a world leader in insurance. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. The company is defined by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength and local operations globally. Parent company Chubb Limited is listed on the New York Stock Exchange (NYSE: CB) and is a component of the S&P 500 index. Chubb employs approximately 40,000 people worldwide. Additional information can be found at: www.chubb.com

About Chubb India

At Chubb India, we are on an exciting journey of digital transformation driven by a commitment to engineering excellence and analytics. We are proud to share that we have been officially certified as a Great Place to Work® for the third consecutive year, a reflection of the culture at Chubb where we believe in fostering an environment where everyone can thrive, innovate, and grow. With a team of over 2500 talented professionals, we encourage a start-up mindset that promotes collaboration, diverse perspectives, and a solution-driven attitude. We are dedicated to building expertise in engineering, analytics, and automation, empowering our teams to excel in a dynamic digital landscape. We offer an environment where you will be part of an organization that is dedicated to solving real-world challenges in the insurance industry. Together, we will work to shape the future through innovation and continuous learning.

Position Details

Job Title: Microsoft SSIS/SQL ETL Developer

Function/Department: Technology

Experience: 6-10 Years

Location: Hyderabad

Role Overview

Position Summary

We are looking for a Mid-Level, Microsoft MS SQL DB and SSIS cube developer to join our Finance Technology team supporting the Foresight financial forecasting platform. This role will include design, develop and maintain MS SQL and SSIS cubes based applications that drive financial forecasting and reporting for the Finance department. This also includes developing new and enhancing, maintaining existing stored procedures, developing new stored procedures etc. It also includes Working closely with business and tech stakeholders to perform system testing and provide support during user acceptance testing and provide production support.

Key Responsibilities

• Design, develop, and maintain MS SQL Server stored procedures, functions, jobs, and complex queries supporting and Financial forecasting
• Build and enhance SSIS packages and Analysis Services cubes for data integration and transformation
• Develop new ETL pipelines and optimize existing ones for performance and reliability
• Perform thorough system testing and provide support during user acceptance testing (UAT)
• Provide ongoing production support, troubleshoot issues, and ensure system stability
• Document current and new processes clearly and comprehensively
• Collaborate within an AI-assisted SDLC environment using tools such as Claude
• Work within DevOps processes using GitHub for version control and deployment
• Manage and track work items through ServiceNow

Technical Skills

• 6+ years of hands-on experience with MS SQL Server — stored procedures, functions, jobs, and complex query development
• 6+ years of experience with MS Analysis Services (SSIS)
• Strong technical analysis and investigative skills across SQL databases and stored procedures
• Experience with DevOps practices and GitHub
• Ability to work within an AI-assisted SDLC (Claude)
• Proficiency with ServiceNow for incident and task management
• Excellent written and verbal communication skills
• Strong time management and problem-solving abilities
• Experience with React JS, Express, or Node.js
• Familiarity with Snowflake and Azure cloud data platforms