Actuarial Job Postings

Health Data Analyst - PEHP

Organization:

PEHP

Position Title:

Health Data Analyst

Post date:

Wed, 06/13/2018 - 13:14

HEALTH DATA ANALYST I

POSITION SUMMARY

Performs data analysis on healthcare data using database queries, spreadsheets, and data visualization software. Responsible for highlighting insights, key takeaways and summarizing results from large datasets in a manner that is easy to understand.  Plays an important role in supporting the reporting function for recurring external group reports.

ESSENTIAL JOB FUNCTIONS AND DUTIES

  1. Writes SQL queries to pull data (medical, pharmacy and dental claims; eligibility; premium; lab results & biometrics; predictive model outputs like risk scores and risk of hospitalization measures). Optimizes queries for speed and ensures the accuracy of the data.
  2. Defines the scope of the data analytic requests by clarifying and documenting what questions the end-user is trying to answer and how the results of the analysis will be used after it is delivered. After completion of analysis, performs necessary follow-up to ensure analysis meets expectations and that end-user understands how to interpret it.
  3. Builds visually intuitive Tableau dashboards that are easy to use to answer likely questions from the end-user. Optimizes visualization speed with common filter interactions. Sets up automatic data refreshes, trains end-user in any functionality of dashboard, and schedules regular follow-ups with end-users to see if there are questions or feedback.
  4. Uses Excel to perform advanced ad hoc analytical projects that involve text parsing, lookups, pivot tables, and graphs in a timely manner.
  5. Assists in updating recurring reports. Investigates and takes action to correct any discrepancy in the data to ensure the integrity of the reports.  
  6. Presents data and conclusions to department and manager for peer review.
  7. Finds meaningful insights from large data sets and assigned analytical assignments and succinctly summarizes and presents conclusions and key takeaways to others.
  8. Finds ways to automate and streamline projects and reports that are commonly recurring.
  9. Maintains strict confidentiality.
  10. Performs other related duties as required.

Organization website:

Description and Application

Actuarial Analyst - Milliman

Organization:

Milliman

Position Title:

Actuarial Analyst

Post date:

Wed, 06/13/2018 - 13:27

Milliman is looking for an Actuarial Analyst for their Boise, ID office. The position is full-time.

Primary Responsibilities:

  • Process and organize data for actuarial valuation of pension and retiree health plans
  • Assist with setup and programming of actuarial valuations
  • Update / develop new and existing Excel workbooks
  • Assist with electronic file management and documentation
  • Assist with government filing preparation
  • Prepare benefit calculations
  • Draft plan amendments and member communications
  • Draft Summary Plan Descriptions and plan documents
  • Prepare budget projections
  • Calculate employer/employee contribution rates, retiree rates, COBRA rates, imputed income rates, and IBNR estimates
  • Prepare cost estimates for various benefit options
  • Analyze vendor renewals
  • Review vendor contracts
  • Prepare ad hoc reporting as needed 

Qualification:

  • Bachelors in Mathematics, Statistics, Economics, or related field
  • Up to three years of experience
  • Experience with Proval valuation software is preferred
  • Completion of one or more Society of Actuaries exams is a plus
  • GPA 3.5+ 

Organization website:

Description and Application