Actuarial Data Analyst

  • 36550
  • Non-Life - Data Science
  • |
  • Texas, United States
  • |
  • Jan 9, 2020
Insurance
RESPONSIBILITIES
  • Assist with mining and analyzing data from company database to drive optimization and improvement of product development and business strategies.
  • Work with manager to understand new data sources, and adapt current processes, or develop new ones, to utilize new data systems for pricing, reserving, and reporting tasks, and to integrate data from new system with data from old system.
  • Gather information, and develop and test new processes to support corporate data strategy.
  • Detect data problems and communicate issues with manager and data owners.
  • 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.
  • 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 useable pricing template formats.
  • Pursue actuarial designations through CAS actuarial exam system.
  • On the job depth should be gained in insurance, applying actuarial knowledge and learning new skills and techniques.
  • Participate in mutually agreed to internal and external training classes.
  • Continue to develop knowledge and skills relevant to department’s data 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 expert on-the-job database experience required, preferably experience with SQL.
  • 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.
  • Minimum 1-2 years of full-time, daily SQL programming experience; ideally working with Microsoft SQL Server and relational database experience
  • Advanced computer skills and master of Microsoft Excel.
  • Prefer Minimum 1 year of full-time, daily SAS programming.
  • Strongly prefer experience in or exposure to SAS, 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.
  • Communicate with co-workers, management, customers, vendors, and others in a courteous and professional manner.
  • Conform with and abide by all Company codes, regulations, policies, values, work procedures and instructions.