Business Analyst Intern

About us

Every account manager handles a full book, from quotes to renewals to claims questions. Clients drop by to pay premiums, ask about a claim or just say hello. We started in 1986 and have grown to about 37 people.

About the role

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote, open to candidates across the US. You can set your own hours around a daily morning check-in. We ship you a laptop and accessories before your first day.

Day to day

Maintain the data dictionary and keep dashboard filters up to date. Create charts and short slide decks for the monthly review call. Analyse funnel drop-offs and summarise findings in a one-page note. Build and update dashboards in Power BI, Tableau or Looker Studio. Track marketing campaign results using Google Analytics 4 data.

What we're looking for

Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028. Based in the US for the duration of the internship. A sample dashboard or analysis project you can share. Laptop with Excel or Google Sheets and a stable internet connection. Available 20 to 40 hours a week, Monday to Friday. Some familiarity with Power BI or Tableau, even from a course or certification. Basic SQL, enough to write SELECT queries with joins and filters.

Bonus points

Python with pandas for data cleaning. Familiarity with DAX in Power BI. Knowledge of basic statistics such as medians, percentiles and correlation.

What you get out of it

Writing SQL against a real production warehouse. Top interns are considered for a junior analyst opening. You will build at least one dashboard that managers use every week. Certificate, letter of recommendation and flexible hours.

Duration: 10 weeks

Start date: May 2027

Stipend: $32.50 - $34.00 per hour

Perks

Learning and development stipend. Home office setup stipend. Company laptop. Paid company holidays. Mentorship from a dedicated buddy and manager. Paid sick time.

We are unable to sponsor visas for this position.

Duration: 10 weeks. Start: May 2027.

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