Logo of Huzzle

Internship

Actuarial Intern

🚀 Off-cycle Internship

Buffalo

AI generated summary

  • You must be a current student in Math/Stats/Computer Science with 3.5+ GPA, Excel skills, strong communication, technical programming abilities, and be based in the Buffalo area for a paid actuarial internship.
  • You will assist in creating KPI dashboards, integrating maps into reports, reviewing competitor assumptions, and refining pricing strategies.

Off-cycle Internship

Banking & FinanceBuffalo

Description

  • Merchants Insurance Group, a leading Property and Casualty Insurer in the Northeast, is looking for is looking for a highly motivated Actuarial Intern interested in learning and applying their skills in a corporate capacity. You will be working within our actuarial department to support several key company initiatives. These include development of high-level key performance indicator dashboards using the Microsoft PowerBI reporting tool, as well as a review of competitor assumptions such as inflation and loss development trends made in competitor rate filings and financial statements. 
  • Merchants Insurance Group is proud to be named one of Buffalo Business First’s Best Places to Work in Western New York for a 2nd consecutive year and to be named both a “Fast Track” company and Top Private Company for the 5th year in a row by Buffalo’s Business First.   Merchants has been named as one of Ward's top 50 performing insurance companies in the United States for the last three years. 

Requirements

  • Full-time, paid internship at $17.00 hourly starting May 2024 through August 2024 based on school schedule. A minimum commitment of 2-3 months is required.
  • Current student or spring 2024 graduate of an undergraduate or graduate program in Mathematics, Statistics, Computer Science, Data Science, Actuarial Science, or similar area of study with a minimum G.P.A. of 3.5+
  • Skilled in Microsoft Excel including use of pivot tables and lookup formulas
  • Strong written and verbal communication skills as demonstrated through samples of course work and summer projects / internships
  • Technical skills in SQL, R, and/or Python programming a plus
  • Previous experience with business intelligence tools such as PowerBI, Tableau and mapping tools such as ARCGIS is strongly preferred
  • Skills with other Microsoft Office tools such as PowerPoint and Word a plus
  • Strong organizational skills and attention to detail
  • Ability to work both independently and as a team in a hybrid work environment
  • Position open to candidates residing in the Buffalo area during the course of the internship
  • Preferred:
  • Current student or spring 2024 graduate of an undergraduate or graduate program in Mathematics, Statistics, Computer Science, Data Science, Actuarial Science, or similar area of study with a minimum G.P.A. of 3.5+

Education requirements

Currently Studying
Undergraduate

Area of Responsibilities

Banking & Finance

Responsibilities

  • Assist in building high-level key performance indicator (KPI) dashboards using the PowerBI reporting tool. Review of system generated and internally created Excel reports for prioritization and transition to Power BI. Assistance in integration of maps into Power BI reports using ESRI ArcGIS software.
  • Review of insurance competitor assumptions for inflationary trend and loss development patterns made in competitor rate filings and in competitor financial statements. This review will be used to refine Merchants insurance pricing assumptions and to benchmark Merchants performance to those of key competitors.

Details

Work type

Full time

Work mode

hybrid

Location

Buffalo