DXC Technology · 1 day ago
Life Insurance Excel VBA Illustration Analyst
East Hartford, CT
Full-time
Hybrid
Mid Level
$93K/yr - $172K/yr
3+ years expDXC Technology is seeking a highly skilled Illustration Analyst with deep experience in life insurance product modeling and calculations. This role focuses on developing, testing, and maintaining accurate illustration models while ensuring compliance with regulatory requirements and business objectives.
AnalyticsConsultingInformation TechnologyInsurTechOutsourcingSecuritySoftware Engineering
No H1B
Responsibilities
Design, develop, and maintain VPMS-based illustration models, including rate testing and product logic validation
Support Assure Product Engine implementation by mapping complex product structures into the illustration platform
Collaborate with actuarial, product, and development teams to ensure illustration calculations are accurate, consistent, and compliant
Build and validate life and annuity product illustrations in Excel, including robust testing frameworks and calculation audits
Script calculation logic using Excel VBA and other scripting tools (e.g., JavaScript) to prototype or troubleshoot illustration outputs
Apply in-depth knowledge of insurance product structure and regulatory rules (e.g., CVAT, guideline premium tests) to support compliant model development
Support quality assurance for new product launches, updates, and system conversions by performing regression and compliance testing
Document model assumptions, test results, and illustration rules to support audit and business review processes
Collaborate with cross-functional teams (actuarial, IT, product) on end-to-end illustration development lifecycle
Ensure alignment with industry data standards such as ACORD, where applicable
Use GIT or similar tools for version control of illustration models and testing assets
Qualification
Required
3+ years of experience working with life insurance illustrations, preferably in a modeling, testing, or business analyst capacity
Strong working knowledge of VPMS (modeling, testing, and rate logic) and Assure Product Engine
Solid actuarial foundation or experience in life/annuity calculations; ASA/FSA designation or actuarial exam progress preferred
Expertise in Excel-based calculations, including testing life and annuity product illustrations and building prototypes
Proficiency with Excel VBA, and scripting familiarity with JavaScript or similar languages
Deep understanding of insurance product structures, including Term, UL, IUL, SUL, and associated riders
Familiarity with regulatory compliance (CVAT, guideline premiums, etc.) in the context of illustration logic
Must have a VALID USA INDEFINIT WORK PERMIT
Preferred
Bachelor's degree in Actuarial Science, Mathematics, Finance, or related technical discipline
Exposure to ACORD standards, web-based deployment environments, and GIT/version control tools
Experience working in illustration development or testing teams at a life insurance company or vendor
Strong problem-solving and analytical skills with excellent attention to detail
Ability to clearly communicate technical concepts to both actuarial and technical stakeholders
Comfortable working independently and managing multiple illustration projects in parallel
Benefits
Health, dental, and vision insurance coverage
Employee wellness
Life and disability insurance
A retirement savings plan
Paid holidays
Paid time off
Company
DXC Technology
DXC Technology is an IT and consulting services company that offers insurance software, security, and application development services.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
$755.01M2025-12-02Post Ipo Debt· $755.01M
2017-04-03IPO
Leadership Team
Raul Fernandez
President and Chief Executive Officer
Kaveri Camire
SVP and Chief Marketing Officer
Recent News
2026-01-08
2026-01-07
Company data provided by crunchbase