Actuarial Analyst

  • 38545
  • Non-Life - Actuarial
  • |
  • Texas, United States
  • |
  • Nov 9, 2020
Insurance
RESPONSIBILITIES
  • Rate reviews and rate change proposals.
  • Assist senior level actuarial team on pricing projects.
  • Perform actuarial review of rates and produce rate indication data.
  • Participate in rate change product meetings.
  • Calculate rate change proposal impacts on book of business.
  • Produce rate change impact frequency histogram exhibits.
  • Run data queries off AS-400 system; use SAS to manipulate data into useable pricing template formats.
  • Work with IT to deliver production rates timely and accurately.
  • Load and test rates in conjunction with Product and IT staff to ensure accurate rates in production.
  • Business monitoring reports.
  • Design and maintain monitoring reports.
  • Detect data problems and communicate issues.
  • Answer questions from report users.
  • Provide improvement ideas on streamlining and automating processes.
  • Assist senior level actuarial team on reserving projects.
  • Produce loss triangle data and premium-exposure data.
  • Cross check data with internal files and with accounting financial files.
  • Produce required exhibits for quarterly financial reporting and audit support.
  • Prepare IBNR information for accounting allocation split files; prepare audit book triangle files; assist auditor testing.
  • Produce catastrophe reinsurance model exposure data for reinsurance broker.
  • Collaborate with accounting and claims staff on collecting and evaluating catastrophe claims history information.
  • Run data queries off AS-400 system; use SAS to manipulate data into usable pricing template formats.
  • Maintain monitoring reports.
  • Detect data problems and communicate issues; Answer questions from report users.
  • Provide improvement ideas on streamlining information and processes.
QUALIFICATIONS
  • Bachelor’s degree, with preference in a quantitative analytical field such as Actuarial Science, Math, Statistics, Data Science, Programming, Finance and Economics; preference is also given to those who are actively pursuing CAS actuarial designations through continuing coursework and examinations.
  • Completion of at least one actuarial exam.
  • 1 or more years of Property/Casualty Insurance actuarial pricing/reserving work experience with working knowledge or actuarial pricing/reserving methods is preferred.
  • Prefer insurance or other relevant work experience.
  • Require advanced skills in and mastery of Microsoft Excel.
  • Strongly prefer experience in or exposure to VBA, R, AS400, Microsoft Power BI, and other MS Office products.
  • Excellent organizational skills; keen attention to detail.
  • Advanced skills in performing mathematical calculation.
  • Excellent verbal and written communications skills.
  • The ability to gather information and express ideas effectively to individuals and groups at all levels of the organization.
  • Understanding of non-standard auto insurance is preferred.