Actuarial Analyst IV

Lifetime Workforce Solutions, LLC

City of Rochester (NY)

On-site

USD 88,000 - 158,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote work possibility

Job summary

Lifetime Healthcare Companies seeks an Actuarial Analyst to perform actuarial services in support of Health Plan operations and monitoring solvency through data modeling and future projections.

The role progresses from Level I to IV, emphasizing rate setting, data quality, and collaboration across departments to improve risk assessment and forecasting accuracy. Proficiency in SQL/SAS and strong communication are essential.

Qualifications

  • Bachelor’s Degree in a related field with SOA exam progress required.
  • Prior actuarial or related insurance industry experience preferred.
  • Strong analytical, verbal and written communication skills.
  • Proficiency in SQL, SAS, VBA or similar programming languages.

Responsibilities

  • Establishes insurance rates, rating structures and systems for groups and business.
  • Develops financial projections and risk score analysis for the health plan.
  • Maintains reserve programs, pricing files and documentation; supports data quality.
  • Collaborates with other departments and leads process improvement initiatives.
  • Complies with actuarial standards and Code of Professional Conduct.

Skills

SQL
SAS
VBA
Analytical skills
Verbal & written communication
Teamwork

Education

Bachelor's Degree in a related field
SOA exams passed

Job description

Job Description: Summary: The Actuarial Analyst performs actuarial services in support of Health Plan operations and monitors and maintains financial solvency through the understanding of current data & environment and modeling of future events. This role is amongst the group that is responsible for providing a range of experience working to establishing rates, rating structures and systems and reserves. The Actuarial Analyst has accountability to providing in depth analysis on the overall risk management and financial solvency for the health plan operation.

Essential Accountabilities:

Level I

Establishes insurance rates, rating structures, and rating systems for groups and categories of business. Maintains reserve programs, pricing files, risk score models, benefit relativity tables and appropriate documentation for work. Develops financial projections, risk score analysis, unpaid claim liability estimates and conducts actuarial analysis for well-defined projects as directed. Compiles and analyzes data to draw conclusions and make recommendations. Proposes and assists in the development of process improvements utilizing system and software applications to full potential and participates in activities and projects as directed. Continued professional growth in Actuarial field as evidenced by participation in the Actuarial Study Program, attainment of credentials, and maintaining applicable annual continuing education requirements. Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies’ mission and values, adhering to the Corporate Code of Conduct, and leading with the Lifetime Way values and beliefs. Consistently adheres to the Actuarial Standards of Practice and the Code of Professional Conduct as promulgated by the Actuarial Standards Board Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures. Regular and reliable attendance is expected and required. Performs other functions as assigned by management.

Level II (in addition to Level I Accountabilities)

Conducts analyses for and communicates with other departments on various initiatives. Assists the development of actuarial analyses concerning complex issues & trends, coordinates with staff. Reconciles Data Warehouse data with corporate financials or encounter submissions and identifies and develops corrective action with regards to Data Warehouse integrity issues. Initiates and leads efforts to continually improve data capabilities and quality of department analysis and reporting. Proactively and independently ideates process improvements, researches, and recommends changes to actuarial processes. Draws together facts and input from a variety of sources.

Level III (in addition to Level II Accountabilities)

Reviews and ensures pricings are consistent with established profitability targets for business segments priced in Actuarial. Develops actuarial analyses concerning complex issues and trends, coordinating with several different disciplines and staff. Provides effective technical advice and support to assist management in meeting corporate goals and identifying strategy. Involves other departmental areas. Leads departmental projects and initiatives with other actuarial staff. Prepares actuarial statements of opinion.

Level IV (in addition to Level III Accountabilities)

Represents the Actuarial Department on special projects involving other areas of the company or external constituents. Performs data exploration using a combination of statistical programming languages and deploys advanced statistical techniques to improve risk prediction, improve reserve, trend and financial forecasting in a manner that is actuarially sound, and enable real-time results and operational efficiencies. Leads organizational projects with internal and external partners. Interprets how regulatory changes affect Health Plan and develops impact analyses, processes and guidelines. Collaborates with senior leadership in meeting corporate goals and strategic planning and decision making. Recommends departmental annual performance goals.

Minimum Qualifications:

NOTE: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities. All Levels Bachelor’s Degree in a related field with at least one (1) Society of Actuary (SOA) exam passed required. Prior actuarial or related insurance industry experience preferred. Strong analytical skills, verbal and written communication skills. Strong interpersonal skills with demonstrated ability and willingness to collaborate with other team members. Ability to prioritize, multitask, and maintain multiple simultaneous projects. Intermediate technical skills including proficiency in Microsoft Office Suite Strong programming skills in SQL, SAS, VBA, or similar programming language is preferred.

Level II (in addition to Level I Qualifications)

Two (2) years of actuarial or related experience with at least three (3) passed SOA exams. An understanding of health insurance & health insurance products, managed care, accounting principles, the competitive market, the legislative environment, and any regulatory issue affecting the Health Plan. Self-starter with the ability to work independently. Intermediate proficient programming skills in SQL, SAS, VBA, or similar programming language. Ability to assess and implement efficiency enhancing processes. High level understanding of non-Actuarial functions such as Rating & Underwriting, Finance, Provider Contracting, Analytics & Data Technology, Population Health Engagement, Marketing & Sales, etc., and how they impact Health Plan operations and financials.

Level III (in addition to Level II Qualifications)

Four (4) years of actuarial or related experience with at least four (4) passed SOA exams. Ability to perform complex modeling independently. Understanding of financial and economic trends, financial regulations and complex financial modules. Strong ability to recognize and automate repetitive tasks. Ability to communicate analytical findings at the appropriate level of detail for receiving audience. Ability to write and communicate statements of actuarial opinion.

Level IV (in addition to Level III Qualifications)

Six (6) years of actuarial or related experience with at least six (6) passed SOA exams. Advanced understanding of non-Actuarial functions such as Rating, Underwriting, Accounting, Provider Contracting, Network Management, Product Development, Medical Management, etc., and how they impact Health Plan operations and financials. Advanced ability to independently communicate analytical findings at the appropriate level of detail for receiving audience. Ability to independently write, communicate, and present statements of actuarial opinion to both actuarial and non-actuarial audiences.

Physical Requirements:

Ability to work while sitting and/or standing at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time. Ability to travel across the Health Plan service region for meetings and/or trainings as needed.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position. Equal Opportunity Employer Compensation Range(s): Level IV: Grade E7: Minimum $87,766 - Maximum $157,978 The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. One Mission. One Vision. One I.D.E.A. One you. Together we can create a better I.D.E.A for our communities. At Excellus BCBS, we’re on a mission to make our communities healthier and we can't do it without you. We know diversity helps fuel our mission and that's why we approach our work from an I.D.E.A Mindset (Inclusion, Diversity, Equity & Access). By activating the experiences, skills, and perspectives of our employees, we take action toward greater health equity. We aspire to reflect the communities we live in and serve, and strongly encourage people of color, LGBTQ+ people, people with disabilities, veterans, and other underrepresented groups to apply.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Actuarial Analyst IV
Actuarial Analyst IV

Excellus BlueCross BlueShield • City of Utica (NY)

On-site
USD 88,000 - 158,000
Remote work option
Actuarial Analyst IV
Actuarial Analyst IV

Excellus BCBS • DeWitt (AR)

On-site
USD 88,000 - 158,000
Actuarial Analyst IV
Actuarial Analyst IV

Excellus BCBS • City of Binghamton (NY)

On-site
USD 88,000 - 158,000
Actuarial Analyst IV
Actuarial Analyst IV

Excellus BCBS • Town of De Witt (NY)

On-site
USD 88,000 - 158,000
Remote work possible on a case-by-case
Case-by-case remote options
Business System Analyst II/III/IV
Business System Analyst II/III/IV

Lifetime Workforce Solutions, LLC • City of Rochester (NY)

Remote
USD 65,000 - 158,000
Software Engineer - ETL
Software Engineer - ETL

Lifetime Workforce Solutions, LLC • City of Rochester (NY)

On-site
USD 60,000 - 107,000
Group health and/or dental insurance
Retirement plan
Wellness program
+2
Long Term Care Benefits Planner I/II (Rochester Region)
Long Term Care Benefits Planner I/II (Rochester Region)

Lifetime Workforce Solutions, LLC • City of Rochester (NY)

On-site
USD 62,000 - 107,000
Remote work possibility
Medicare Segment Manager
Medicare Segment Manager

Lifetime Workforce Solutions, LLC • City of Rochester (NY)

Hybrid
USD 79,000 - 142,000
Actuarial Analyst IV
Actuarial Analyst IV

Capital District Physicians Health Plan Inc • Town of De Witt (NY)

On-site
USD 88,000 - 158,000
Remote work option
Professional development support
Customer Care Advocate (Customer Care Representative)
Customer Care Advocate (Customer Care Representative)

Capital District Physicians Health Plan, Inc. • United States

On-site
USD 23,000 - 32,000
Remote work on case-by-case basis