Role Overview
Core Modernization is a transformative initiative designed to elevate client's foundational technology to meet today's business demands and prepare for the future. The centerpiece of this program is a major upgrade to our policy administration system an essential platform that manages the full spectrum of insurance policy transactions, including premium collection, loans, beneficiary management, claims processing, and policy renewals.
For nearly sixty years, this system has supported client and agent experiences while ensuring compliance with regulatory standards. This modernization effort replaces legacy infrastructure with stateoftheart technology, enabling faster innovation, reduced servicing friction, and improved client and agent experiences positioning client at the forefront of the industry.
As a Senior Associate, LIS Tool Developer, you will join the Life Insurance Solutions team (LIS) and play an essential role in the Core Modernization initiative. You will support the development, testing, and maintenance of Excelbased scenario testing tools used to validate product behavior in the new policy administration system. Your expertise in Universal Life and/or Whole Life products, strong Excel modeling skills, and clear communication will be vital to ensuring accurate policy lifecycle values and a successful system transition.
What You'll Do
As part of the Core Modernization program, client must configure retail life insurance products into the new policy administration system and validate that the system produces accurate values throughout the policy lifecycle. To accomplish this, scenario testing tools must be created for each product to compare results from the new system.
In this role, you will:
Core Responsibilities
- Design and update Excel-based scenario testing tools to support product configuration and lifecycle analysis for Retail Life products
- Build, test, and maintain accurate and reliable testing tools as we migrate to the new policy administration system
- Collaborate closely with the Automation Development team to integrate automation features and ensure seamless interaction with testing tools
- Monitor tool efficiency and reliability, making improvements to usability and performance
- Provide clear documentation and communicate findings across the team to support product development and modernization efforts
What You'll Bring
Required Skills
- Extensive knowledge of Life Insurance products and product functionality
- Strong Excel skills
- General understanding of IRC Sections 7702 and 7702A
- Strong communication skills
Preferred Skills
- Experience with Excel VBA
- Experience working in an Agile software development environment
- Working knowledge of QA review and testing processes, including designing test scenarios, understanding testing techniques and tools, and recognizing technology impacts
MUST HAVES
- Extensive, detailed knowledge of Life Insurance products and product functionality understand product components, how money/taxes come into play
- Strong Excel skills VLOOKUP, formulas
- General understanding of IRC Section 7702 and 7702A and the requirements within
- Strong communication skills ability to clearly explain tasks, report on calls with the SCRUM team