spaceactuary

In my (admittedly limited) experience, you'll probably run into some of the same issues with QlikView being "expensive, ugly, and completely lacking in statistical tools".

"Actuarial tables" are really only used to price life insurance.

Property/Casualty insurance (auto, home, work comp, etc.) are priced by analyzing recent loss experience, then trending loss costs forward (as medical costs & replacement costs go up over time).

Hazards that are infrequent and spatially-correlated (hurricane, tornado/hail, fire) are often priced by using simulations, which take into account the nature of the event, engineering simulations, and insurance policy terms.

Flood insurance is incredibly politicized, as it's handled at the federal level. Floods are typically considered an "uninsurable event" given that if you live in a flood plan, there's a high likelihood that you'll have a loss due to flood--less of an "if" than a "when".

Flood insurance is sold & claims are handled by insurance companies, but it is effectively reinsured 100% by the federal government. Actuarial studies have show the premiums to be highly inadequate, but there has been legislation that aims to reduce that inadequacy.