Senior Actuarial Analyst - ERNIE Rating Systems (SQL)

At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care. As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues - caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day. This position is with the Actuarial Rating Systems Support team and focuses on operational execution for our large group commercial rating engine (ERNIE) . As a Sr. Actuarial Analyst the ideal candidate will project manage and support system enhancements from beginning to end; collaborating with business partners, planning and documenting project technical steps, and moving the improvements through the testing, documentation, and rollout stages. They will also make use of their technical skills and attention to detail in the coordination and implementation of rating changes to our production environment. Actuarial Responsibilities Include: Defining specifications and documentation for rating methodology changes Testing and sign-off for ERNIE system enhancements Creating exhibits to demonstrate rating method results for regulatory/underwriting inquiries Investigating historical pricing practices across national commercial large group business Assessing claim impact of benefit relativity changes Technical Responsibilities Include: Implementation of commercial actuarial rate reviews in ERNIE Tier 2 technical support for underwriting/actuarial rating issues Process improvement via SQL and Excel/VBA Required Qualifications: 2 actuarial exams passed and pursuing ASA designation 2+ years actuarial work experience Preferred Qualifications: Experience with SQL Education: Bachelor's Degree Anticipated Weekly Hours 40 Time Type Full time Pay Range The typical pay range for this role is: $64,890.00 - $173,040.00 This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong. Great benefits for great people We take pride in our comprehensive and competitive mix of pay and benefits - investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include: Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan . No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching. Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility. For more information, visit We anticipate the application window for this opening will close on: 01/27/2026 Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws. #J-18808-Ljbffr CVSHealth