Actuarial Analyst , II or III

About The Company

PEHP Health & Benefits is a division of the Utah Retirement Systems that proudly serves Utah’s public employees through high quality and competitively priced medical, dental, life, and long-term disability insurance plans on a self-funded basis. As a government entity, we embrace both a public mission and a commitment to creating customer value, excelling in the market, and improving healthcare. We offer a competitive salary with generous benefits, personal development in a positive team environment, and excellent work-life balance.

For most jobs, remote work is available for 9 out of every 10 workdays.

This job may be filled at any of the levels listed below.

Actuarial Analyt I- Min: $70,423.90/yr. Max: $80,987.48/yr.

Actuarial Analyt II
- Min: $78,874.76/yr. Max: $90,705.98/yr.

Actuarial Analyt III- Min: $88,776.06/yr. Max: $/yr.

POSITION SUMMARY

The Actuarial Analyst supports PEHP’s mission through preparing internal and external reports and analysis, participating in innovation within the team, and maintaining standards of work quality and customer trust. The position works with PEHP’s actuarial staff on healthcare analytics, underwriting, and actuarial tasks. Successful performance in this position will require rapid progress in technical work using Excel and SQL, attention to detail, and proficiency in established processes.

This position may be eligible for the Actuarial Student Program.

ESSENTIAL JOB FUNCTIONS AND DUTIES

• Checks reports for accuracy and reasonableness and uses the established data disclosure protocol.
• Creates reports using Excel, SQL, and Tableau. Reports may require statistical or risk adjusted procedures. Interprets and defends analysis.
• Responds to underwriting requests for proposals.
• Prices basic benefits using benefit pricing template or benefit adjuster model.
• Analyzes Incurred But Not Reported (IBNR) model for large agencies.
• Performs recurring reconciliation of department databases to the authoritative data source.
• Documents work processes.
• Maintains regular and reliable attendance.
• Maintains strict confidentiality.
• Performs other related duties as required, which may include assisting with underwriting and data analytics job duties.

ACTUARIAL ANALYST I

Bachelor’s degree with a strong emphasis in mathematics, economics, actuarial science, or some other quantitative field and passed at least one (1) Society of Actuaries exams; or a Master’s in Statistics, or a related field; or an equivalent combination of education and experience.

Relevant internship is preferred.

Experience in Tableau and VBA is preferred.

ACTUARIAL ANALYST II

Bachelor’s degree with a strong emphasis in mathematics, economics, actuarial science or some other quantitative field, passed at least three (3) Society of Actuaries exams, and at least one (1) year of actuarial experience; or an equivalent combination of education and experience.

Experience in Tableau and VBA is preferred.

ACTUARIAL ANALYST III

Bachelor’s degree with a strong emphasis in mathematics, economics, actuarial science, or some other quantitative field; passed at least five (5) Society of Actuaries exams; at least two (2) years of actuarial experience; or equivalent combination of education and experience.

Experience in Tableau and Visual Basics for Applications (VBA) are preferred.

Knowledge, Skills, and Abilities

This list contains knowledge, skills, and abilities that are typically associated with the job. It is not all-inclusive and may vary from position to position:

Required technical skills include the working knowledge of:

• Microsoft Excel, must have ability to trace flow of data and calculations in complex Excel models.
• Microsoft Office Suite.
• SQL.

Required excellent mathematical skills such as:

• Mathematical concepts such as probability, probability distributions, statistical regressions, statistical inference, and predictive modeling.
• Applying concepts of fractions, percentages, ratios, and proportions to practical situations.

Required actuarial skills include academic understanding of:

• Risk scores including how and when to apply them in actuarial analysis.
• Actuarial principles and methodologies.

Must…