Senior Life Insurance Product Analyst

Our Client, a Global Insurance Firm, is seeking a Senior Life Insurance Product Analyst in their New York, NY location. Role Overview Join a transformative Core Modernization initiative focused on upgrading a legacy policy administration platform that has supported insurance operations for nearly sixty years. This program is replacing legacy infrastructure with modern technology to improve product configuration, policy lifecycle accuracy, compliance alignment, and client and agent experience. As a Senior Associate within Life Insurance Solutions, you will play a key role in supporting the configuration and validation of retail life insurance products within a new policy administration system. This position blends deep product expertise with technical Excel modeling and cross-functional collaboration to ensure accurate policy lifecycle outputs throughout system migration. What You Will Do Product Configuration & Scenario Testing • Design and enhance Excel-based scenario testing tools to validate retail life insurance product behavior • Model full policy lifecycle scenarios including premium collection, loans, beneficiary changes, claims, renewals, and tax impacts • Compare outputs between legacy and modernized systems to ensure accuracy and compliance Tool Development & Automation • Build, test, and maintain reliable Excel modeling tools to support system migration • Partner with Automation Development teams to integrate automated features into testing tools • Monitor tool efficiency and continuously improve usability and performance Documentation & Communication • Clearly document assumptions, findings, and product behaviors • Communicate updates and testing results effectively across SCRUM and cross-functional teams • Provide detailed reporting to support product development and modernization objectives Required Qualifications • Extensive knowledge of Life Insurance products including Universal Life and Whole Life • Strong understanding of product components, policy mechanics, and tax implications • Working knowledge of IRC Sections 7702 and 7702A • Advanced Excel skills including VLOOKUP and complex formulas • Strong communication skills with the ability to explain technical findings clearly Preferred Qualifications • Experience with Excel VBA • Exposure to Agile development environments • Working knowledge of QA testing processes including test scenario design and validation techniques