Actuarial Analyst I, 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.

Job Description

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: $104,311.88/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.

Required Experience 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 possess excellent communication skills:

• Read and interpret technical studies, papers, and textbooks.
• Draft routine correspondence.

Must have the ability to:

• Follow written and verbal instructions.
• Prioritize work.
• Perform within deadlines.
• Work well in a team environment as well as independently.
• Multi-task by handling a variety of duties in a timely and efficient manner.
• Follow through with assignments.
• Deal effectively with stress caused by workload and time deadlines.

The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of URS.

Work Environment

Incumbent performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities which do not generally involve muscular strain, but do require activities related to walking, standing, stooping, sitting, reaching, talking, hearing and seeing. Common eye, hand, finger dexterity required to perform essential functions. Apply tot his job Apply To this Job