Business Intelligence Intern, Summer 2027

Regional offices in Madison and five other cities support agents and policyholders. Licensing (property and casualty, life and health) is paid for, with study time during work hours.

Overview:

Remote internship for a student who likes spreadsheets and is not scared of messy data. You can work from home anywhere in the US. We have no office requirement. Monday to Friday, regular working hours, flexible start and finish.

Day to day:

Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables. Track marketing campaign results using Google Analytics 4 data. Answer ad hoc data requests from sales and support within a day or two. Prepare the weekly MIS report and send it to the team lead every Monday. Check numbers across sources and flag mismatches before reports go out.

Who can apply:

Available 40 hours a week for the full internship. Authorized to work in the US. CPT and OPT candidates are welcome to apply. Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028. Laptop with Excel or Google Sheets and a stable internet connection. Some familiarity with Power BI or Tableau, even from a course or certification. Basic SQL, enough to write SELECT queries with joins and filters. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $30.00-$36.00 an hour

Perks:

Mentorship from a dedicated buddy and manager. Final presentation to leadership. Learning and development stipend.

No agencies or third-party recruiters, please.

Duration: 10-12 weeks. Start: Summer 2027.

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