What are the responsibilities and job description for the Actuarial Analyst I, II or III position at Utah Retirement Systems?
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.
Job Description
ACTUARIAL ANALYST I
FLSA Exempt
POSITION SUMMARY
The Actuarial Analyst I position 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
ACTUARIAL ANALYST II
FLSA Exempt
POSITION SUMMARY
The Actuarial Analyst II position supports PEHP’s mission through preparing models and analysis for internal and external customers, innovating with the team, and maintaining standards of work quality and customer trust. This position works with PEHP’s actuarial staff on healthcare analytics, underwriting, and actuarial tasks. Successful performance in this position will require mastery of technical work in Excel and SQL, ownership of an internal customer’s needs, and the ability to work independently at a high level. This position may be eligible for the Actuarial Student Program.
ESSENTIAL JOB FUNCTIONS AND DUTIES
ACTUARIAL ANALYST III
FLSA Exempt
POSITION SUMMARY
Provide routine and ad hoc actuarial and analytical management support for decision making processes. Serve as the subject matter expert for prospective reinsurance. This position may be eligible for the Actuarial Student Program.
ESSENTIAL JOB FUNCTIONS AND DUTIES
Required Experience
ACTUARIAL ANALYST I
Education and Experience
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.
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.
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.
ACTUARIAL ANALYST II
Education and Experience
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.
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.
- Apply advanced mathematical concepts 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.
- Prepare reports.
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.
ACTUARIAL ANALYST III
Education and Experience
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.
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.
- Knowledge of different data type structures that enhance data mining capabilities. Familiarity with data mining and database structure with particular emphasis on medical, pharmacy and dental claims.
Required excellent mathematical skills such as:
- Mathematical concepts such as probability, probability distributions, statistical regressions, statistical inference, and predictive modeling.
- Apply advanced mathematical concepts 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.
- Prepare reports.
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.
- Work as a project lead.
The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of URS.