Business Intelligence Intern

Every account manager handles a full book, from quotes to renewals to claims questions. We're looking for a Business Intelligence Intern. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote within the US. The team meets in Toledo once a quarter, travel covered.

The work:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Check numbers across sources and flag mismatches before reports go out.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Track marketing campaign results using Google Analytics 4 data.
• Analyse funnel drop-offs and summarise findings in a one-page note.

Requirements:

• Based in the US for the duration of the internship.
• Available 40 hours a week for the full internship.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Some familiarity with Power BI or Tableau, even from a course or certification.

6 months, starting Jan 2027. Stipend: $28.50-$32.50 per hour.

Perks: Mentorship from a dedicated buddy and manager, Paid sick time, Return offer opportunities.

Most hires start within two to three weeks of an offer.

Duration: 6 months. Start: Jan 2027.

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