Finance Intern

Regional offices in Madison and five other cities support agents and policyholders. We're looking for a Finance Intern. This is an Excel-heavy role. If you enjoy cleaning data and building models, apply. Remote, open to candidates across the US. Most of our work is async, and meetings are kept short. Please make sure you have a quiet place to work and a solid internet connection.

The work

Create charts and summary slides for monthly management and board meetings. Collect expense data from department heads and reconcile it with the books. Build and update financial models for revenue, costs and cash runway. Prepare monthly budget versus actual reports and explain major variances. Assist with investor data requests and keep the data room folder organised.

Requirements

Based in the US for the duration of the internship. Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028. Laptop with desktop MS Excel installed (not only the web version) and stable internet. Strong MS Excel: VLOOKUP or XLOOKUP, SUMIFS, pivot tables and basic charts. Understanding of the three financial statements and how they link.

6 months, starting Mar 2027. Stipend: $23.50 - $25.50/hr.

Perks: Home office setup stipend, Paid company holidays, Flexible hours, Company laptop, Final presentation to leadership.

Duration: 6 months. Start: Mar 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Chesapeake Insurance Group.