Life Insurance Excel VBA Illustration Analyst at DXC Technology

East Hartford, Connecticut, United States

Apply Now

Not SpecifiedCompensation

Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level

Full TimeJob Type

UnknownVisa

InsuranceIndustries

Requirements

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
Bachelor's degree in Actuarial Science, Mathematics, Finance, or related technical discipline (preferred)
Exposure to ACORD standards, web-based deployment environments, and GIT/version control tools (preferred)
Experience working in illustration development or testing teams at a life insurance company or vendor (preferred)
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
Must have a VALID USA INDEFINIT WORK PERMIT

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

Skills

Excel

VBA

VPMS

Assure Product Engine

Life Insurance Modeling

Annuity Products

Actuarial Concepts

Illustration Systems

JavaScript

GIT

ACORD

Rate Testing

Regression Testing

DXC Technology

IT services for enterprise modernization and management

About DXC Technology

DXC Technology provides IT services to large enterprises, focusing on modernizing their critical systems and operations. The company uses the Enterprise Technology Stack to enhance IT infrastructure, optimize data architectures, and ensure security across various cloud environments, including public, private, and hybrid. DXC operates on a contractual basis, offering consulting, system integration, and managed services to help clients improve their IT operations. What sets DXC apart from competitors is its strong commitment to innovation, sustainability, and corporate responsibility, which has earned it recognition as one of the Most Responsible Companies. The goal of DXC Technology is to be a trusted partner for enterprises, helping them achieve scalable and secure IT solutions while promoting inclusion and diversity within its workforce.

McLean, VirginiaHeadquarters

2017Year Founded

$14.6MTotal Funding

IPOCompany Stage

Consulting, Enterprise SoftwareIndustries

10,001+Employees

Risks

Emerging IT service providers offer cost-effective solutions, threatening DXC's market share.

Rapid technological changes may outpace DXC's innovation, risking service obsolescence.

Economic downturns could reduce IT spending, impacting DXC's long-term contract revenue.

Differentiation

DXC Technology is a Fortune 500 global IT services leader.

The company specializes in modernizing mission-critical systems for large enterprises.

DXC's Enterprise Technology Stack ensures security and scalability across cloud environments.

Upsides

DXC is recognized as a leader in the 2024 Magic Quadrant for Outsourced Digital Workplace Services.

The Quercus AI platform collaboration with Ferrovial and Microsoft enhances DXC's innovation capabilities.

DXC's role in transforming Italy's healthcare sector showcases its expertise in digital transformation.

Land your dream remote job 3x faster with AI

Try Jobo Free