Actuarial - Predictive Modeler II

  • 33960
  • Non-Life - Actuarial
  • |
  • Ohio, United States
  • |
  • Jul 24, 2018
Insurance
RESPONSIBILITIES
  • Support reporting and predictive analytics efforts in commercial lines, personal lines, loss control, premium audit and claims.
  • Produce actuarial/modeling analyses related to premium adequacy, rate adequacy, competitive market position, model bias, residual lift, etc.
  • Gain high-level knowledge of actuarial techniques for ratemaking and insurance modeling.
  • Gain expertise in all data systems available to Predictive Analytics and understand the contents and limitations of each.
  • Explore new data systems as they become available and document the contents and limitations of each.
  • Design and implement data cleansing processes.
  • understand the data needs of predictive modelers and work with them to determine appropriate data sources; and to construct appropriate queries, code, and/or databases to obtain, scrub, aggregate and deliver the relevant data.
  • Establish and maintain periodically updated datasets from a variety of internal and external sources.
  • Develop, maintain, improve, and document code, macros, and databases used within the Predictive Analytics unit.
  • Establish and maintain libraries of optimized code for common tasks.
  • Re-engineer low-efficiency processes through the practice of continuous improvement.
  • Develop prototype reports to meet the needs of various departments for modeling output, and work with Business Intelligence to transition reports to production.
  • Assist with the evaluation of external data sources.
  • Serve as an advisory resource for modelers to learn about data sources.
  • Plan and facilitate working sessions with cross-functional teams to accomplish goals.
  • Contribute to discussions with IT regarding architectural design of data systems, representing the needs of Predictive Analytics.
  • Support modelers’ use of modern modeling tools such as R and Python, and modern data storage and acquisition systems such as Hadoop and Spark.
QUALIFICATIONS
  • Advanced degree in statistics, mathematics, economics, actuarial science or other related fields.
  • Graduate degree or Ph.D. is highly preferred.
  • At least three years of highly technical experience at a property/casualty insurance company.
  • Desire to learn about the business of insurance, actuarial science and predictive analytics.
  • Proficiency with Microsoft® Excel.
  • Experience with VBA, SQL, writing SAS code, R and/or Python and Hadoop file system.
  • Experience with other programming languages, such as Java or C#.
  • Experience with data sources, such as Reporting Systems, eCLAS, Diamond, AMPS, CMS, BW, PAD.
  • Ability to quickly understand and assess data structures.
  • Ability to work both independently and as part of a team.
  • Ability to solve problems systematically and creatively.
  • Ability to research data contents, evaluate data quality, scrub data and validate results.
  • Ability to write business requirements and to relate business and actuarial needs to data construction and coding requirements.
  • Ability to articulate complex technical concepts to non-technical client.
  • Thorough understanding of insurance concepts and P/C insurance products.
  • Excellent documentation standards and communication skills.