Business Analytics Intern

Customers get quotes from several carriers at once, and we handle renewals and policy changes. Most of our book is personal lines, with a growing share of small commercial accounts.

OVERVIEW

Coleman Insurance Services needs a data analytics intern to build reports and dashboards for the Business Intelligence team. You will intern remotely with our team in Elgin. We have hosted remote interns from several countries before. You will need at least 4 hours of overlap with US Central time.

RESPONSIBILITIES

Prepare the weekly MIS report and send it to the team lead every Monday. Document metric definitions so everyone calculates churn and conversion the same way. Build and update dashboards in Power BI, Tableau or Looker Studio. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query. Check numbers across sources and flag mismatches before reports go out. Maintain the data dictionary and keep dashboard filters up to date. Analyse funnel drop-offs and summarise findings in a one-page note. Create charts and short slide decks for the monthly review call.

WHO CAN APPLY

Are able to join within 15 days. Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026 or 2027 batch). Available for a full-time (work from home) internship for the full duration. Women returning to work after a career break are welcome to apply. A sample dashboard or analysis project you can share. Must be able to follow up on data requests without constant reminders. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts. Available 20 to 40 hours a week, Monday to Friday. Some familiarity with Power BI or Tableau, even from a course or certification.

WHAT YOU GET OUT OF IT

Presenting numbers in a way non-technical people can act on. Top interns are considered for a junior analyst opening. How business metrics like CAC, churn and retention are actually calculated. Certificate, letter of recommendation and flexible hours.

Duration: 6 months

Start date: Immediately

Stipend: $400 - $450/month

PERKS

Certificate. Letter of recommendation. 5 days a week. Laptop provided for the internship.

We look at every application, usually within a week.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Coleman Insurance Services LLC.