Life Insurance Excel VBA Illustration Analyst

Job description

**Job Description:**

We are seeking a highly skilled Illustration

**Analyst** with deep experience in **life insurance produ** ct modeling and calculations.

This role focuses on developing, testing, and maintaining accurate illustration models using **VPMS, Excel, and Assure Product Engine,** ensuring alignment with regulatory requirements and business objectives.

The ideal candidate has a strong understanding of life and annuity products, actuarial concepts, and illustration logic, and is capable of bridging the gap between actuarial modeling and illustration system implementation.

**Key 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.

**Required Qualifications:**

+ 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.

**Preferred Qualifications:**

+ 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.

Must have a VALID USA INDEFINIT WORK PERMIT

Compensation at DXC is influenced by an array of factors, including but not limited to the experience, job-related knowledge, skills, competencies, as well as contract-specific affordability and organizational requirements.

A reasonable estimate of the current compensation range for this position is $84,100 - $156,100.

Full-time hires are eligible to participate in the DXC benefit program.

DXC offers a comprehensive, flexible, and competitive benefits program which includes, but is not limited to, health, dental, and vision insurance coverage; employee wellness; life and disability insurance; a retirement savings plan, paid holidays, paid time off.

At DXC Technology, we believe strong connections and community are key to our success.

Our work model prioritizes in-person collaboration while offering flexibility to support wellbeing, productivity, individual work styles, and life circumstances.

We’re committed to fostering an inclusive environment where everyone can thrive.

**If you are an applicant from the United States, Guam, or Puerto Rico**

DXC Technology Company (DXC) is an Equal Opportunity employer.

All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, pregnancy, veteran status, genetic information, citizenship status, or any other basis prohibited by law.

View postings below.

We participate in E-Verify.

In addition to the posters already identified, DXC provides access to prospective employees for the **Federal Minimum Wage Poster, Federal Polygraph Protection Act Poster as well as any state or locality specific applicant posters** .

To access the postings in the link below, select your state to view all applicable federal, state and locality postings.

Postings are available in English, and in Spanish, where required.

View postings below.

Postings Link (https://mandatoryview.com/?LicenceId=c38a7700-5aa2-48a3-b95a-22e6e1fb0721&ProductType=OnlineApplicant)

**Disability Accommodations**

If you are an individual with a disability, a disabled veteran, or a wounded warrior and you are unable or limited in your ability to access or use this site as a result of your disability, you may request a reasonable accommodation by contacting us via email (GSS-HR-ER@dxc.com) .

Please note: DXC will respond only to requests for accommodations due to a disability.

Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company.

These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process.

DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf.

More information on employment scams is available here _._

Required Skill Profession

Other General