Job Purpose:

AEGIS Insurance Services, Inc. has an immediate opening for a Catastrophe Modeling Analyst to perform duties that support the catastrophe management, underwriting and reinsurance information needs for AEGIS’s energy and utility business in New Jersey.

The position includes obtaining and preparing data for upload into a data aggregation system, running catastrophe modeling analyses, and analyzing results. Properly interpreting location level data is critical in determining location level exposure, ensuring optimal geocoding, and correctly assessing the catastrophe risk for an account. High quality data is needed to generate exposure management and risk aggregation reports for underwriters, senior management and reinsurance intermediaries.

Essential Job Functions

• For larger accounts, upload submission information and prior year’s bound file to vendor website for data preparation; when account is available, download the file and verify the quality, validity and completeness of the account prior to modeling
• For smaller accounts or accounts where a quick turnaround is needed, prepare and format location data for import into data aggregation software (currently OpenXposure); this usually involves reformatting data in a spreadsheet; it could also involve conversion of data from pdf or manual data entry
• Verify quality, validity and completeness of the property location data prior to geocoding and catastrophe modeling
• Where location information is incomplete, use internal and external sources to enhance it; where appropriate, use assumptions to distribute the values over selected geographic areas
• Use information from the engineering reports to supplement submission information for occupancy type, year built, coordinates, building elevation, and flood defenses
• Document the enhancements or changes made to each account to ensure data integrity
• Build an effective working relationship with AEGIS underwriting and loss control staff
• Prioritize CAT pricing requests based on Underwriters’ needs and quoting deadline; prepare CAT pricing reports including details on year-to-year account changes
• On a monthly basis, use finalized policy wording to update location data in OpenXposure with participation, limit, peril sublimits, and peril specific deductibles
• Add endorsement information to the policy when there is a cancellation, extension, a change in location values, or an addition or removal of locations
• Answer questions from manager and colleagues regarding data discrepancies and make necessary corrections in the data aggregation system
• Special projects as assigned