Senior Analyst, Actuarial

CVS Health • Work At Home-Connecticut, CT

11d • $64,890 - $158,620

About The Position

The Senior Analyst, Actuarial works on CVS Health’s Actuarial Rating Systems Support team, with a focus on operational execution for the large group commercial rating engine, ERNIE. The role project-manages and supports system enhancements from start to finish, collaborating with business partners, planning and documenting technical project steps, and guiding improvements through testing, documentation, and rollout. It also coordinates and implements rating changes in the production environment.

The role supports the medical line of business and spends approximately 20% of its time serving as a backup resource for Dental Rating Systems Support. Dental support includes dental model updates and end-to-end management of ERNIE enhancements, including intake, requirements documentation, cross-functional collaboration, testing, implementation, training, and communication.

Actuarial work includes defining and documenting specifications for rating methodology changes; testing and signing off on ERNIE enhancements; creating exhibits for regulatory and underwriting inquiries; investigating historical pricing practices across national commercial large group business; and assessing claim impact from benefit relativity changes. Technical work includes implementing commercial actuarial rate reviews in ERNIE, providing Tier 2 support for underwriting and actuarial rating issues, and improving processes using SQL, Excel/VBA, and AI tools.

Requirements

• Pass at least two actuarial exams and be pursuing the ASA designation.
• Have at least two years of actuarial work experience.
• Demonstrate strong analytical and problem-solving skills, including experience working with complex data and technical systems.
• Be able to analyze data, investigate issues, and determine root causes in a business or systems environment.
• Bachelor's degree.

Nice To Haves

• Experience with SQL.
• Experience working with large datasets and performing data analysis.

Responsibilities

• Project-manage and support ERNIE system enhancements from beginning to end.
• Collaborate with business partners and plan and document technical project steps.
• Move system improvements through testing, documentation, and rollout.
• Coordinate and implement rating changes in the production environment.
• Provide backup support for Dental Rating Systems Support, including dental model updates.
• Manage dental ERNIE enhancement activities, including intake, requirements documentation, cross-functional collaboration, testing, implementation, training, and communication.
• Define specifications and document rating methodology changes.
• Test ERNIE system enhancements and provide sign-off.
• Create exhibits demonstrating rating method results for regulatory and underwriting inquiries.
• Investigate historical pricing practices across national commercial large group business.
• Assess claim impact of benefit relativity changes.
• Implement commercial actuarial rate reviews in ERNIE.
• Provide Tier 2 technical support for underwriting and actuarial rating issues.
• Improve processes using SQL, Excel/VBA, and AI tools.

Benefits

• Medical coverage.
• Dental coverage.
• Vision coverage.
• Paid time off.
• Retirement savings options.
• Wellness programs.
• Other resources, based on eligibility.
• Eligibility for a CVS Health bonus, commission, or short-term incentive program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior