Life Insurance Excel VBA Illustration Analyst
HybridIndividual Life ProtectionIndividual AnnuitiesLife Annuity OtherProduct Development & Plan Design
Role Summary
Loading...HIGHLIGHTS
Life actuarial illustration analyst focused on life and annuity product illustrations and system implementation. You will develop and test VPMS models, map products into Assure Product Engine, and build VBA-based Excel illustration prototypes. Associate-level role based in East Hartford, CT supporting regulatory-compliant illustrations and product launches.
JOB DESCRIPTION SUMMARY
- Develop and maintain VPMS-based life and annuity illustration models
- Map complex product logic into Assure Product Engine
- Build and script Excel-based illustrations using VBA and JavaScript
- Perform regression, compliance (CVAT/guideline premium) and QA testing
- Hybrid work model prioritizing in-person collaboration with flexibility
DOMAIN EXPERTISE
- life insurance illustrations
- VPMS modeling and testing
- Assure Product Engine implementation
- Excel VBA scripting for illustrations
- regulatory compliance (CVAT, guideline premium tests)
KEY REQUIREMENTS
- 3+ years' experience with life insurance illustrations
- Strong working knowledge of VPMS and Assure Product Engine
- Proficiency with Excel-based calculations and VBA scripting
- Familiarity with regulatory tests (CVAT, guideline premium)
- Valid US indefinite work permit required (no sponsorship)
TECH STACK
- Excel
- Git_GitHub
