Data Modeling Analyst, Sr. jobs in Cedar Rapids, IA

UFG has an exciting opportunity for a Senior Catastrophe Modeling Analyst to work with our growing team where this individual will be analyzing property data to determine UFG’s view of the catastrophe risk. The major responsibilities will include preparing catastrophe modeling data from various data sources, modeling the data by utilizing catastrophe model/(s), communicating the outcomes and providing recommendations to the senior management team to quantify the risk. The candidate will collaborate with internal customers (direct and assumed businesses) to develop adequate pricing, ratemaking, and exposure management strategies that drive towards profitable growth of the company.

Responsibilities: 

• Collaborate with data engineers and underwriters in gathering the data needed for catastrophe modeling as well as improving data accuracy and completeness; organize, scrub and prepare the data for model ready import files using valuation tools including SQL/Excel.
• Analyze the risks for data quality, accuracy, and completeness; provide recommendations to management to enhance decision-making.
• Run analyses using proprietary catastrophe model such as RMS, generate outputs to analyze the loss results and help determine the degree of risks of various perils.
• Support the underwriting and actuarial teams by interpreting the modeling outputs for growth and rate-making.
• Prepare analytical reports to understand the portfolio as well as concentration of risks.
• Assess catastrophe risk arising from direct and assumed business.
• Perform scenario modeling to analyze the impact of growth or reduction within the existing book.
• Support improvements efforts to increase consistency, efficiency, and compliance with internal standards.
• Stay well versed with the continuously changing catastrophe modeling industry and the models.
• Respond to real-time catastrophic events, prioritizing over all else by computing potential losses as soon as the data is received, and inform the outcome to senior management once computed.
• Effectively communicate information and results to a variety of technical and non-technical audiences across the organization.

Qualifications:

Education: 

• Bachelor’s degree.
• Bachelor of Science degree in Mathematics, Data Science, Statistics, Computer Science, or related field preferred.
• Either a minor concentration or additional degree in Meteorology preferred.

Certifications/Designations: 

• Employees are expected to participate in continuing education throughout their careers.
• Possess, or working towards, an CCRA, CEEM, and/or ARe certification preferred.

Experience:

• 6 years of catastrophe modeling experience.

Working Conditions:

• General Office Environment.
• Up to 10% travel for quarterly office visit and occasional conferences.

Skills & Knowledge:

Skills: 

• Advanced proficiency with Excel, Power Point, SQL, Tableau.
• Advanced analytical, technical, problem solving, time management, critical thinking, and project execution skills
• Strong verbal and written communication skills including the ability to effectively collaborate with multi-disciplinary groups and all organizational levels.
• Able to work independently and in a team environment

Knowledge: 

• Strong Knowledge of catastrophe modeling software such as RMS and AIR.