Data Analyst Intern

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.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. This role is fully remote within the US. Most of our work is async, and meetings are kept short.

Day to day

• 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.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Maintain the data dictionary and keep dashboard filters up to date.
• Join a weekly call with the analytics lead to review your work.
• Create charts and short slide decks for the monthly review call.
• Build and update dashboards in Power BI, Tableau or Looker Studio.

Requirements

• Available 40 hours a week for the full internship.
• Based in the US for the duration of the internship.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.
• A sample dashboard or analysis project you can share.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Laptop with Excel or Google Sheets and a stable internet connection.

Preferred

• Google Data Analytics or Microsoft PL-300 certification.
• Knowledge of basic statistics such as medians, percentiles and correlation.

What you get out of it

• How business metrics like CAC, churn and retention are actually calculated.
• You will build at least one dashboard that managers use every week.
• Presenting numbers in a way non-technical people can act on.

Duration: 10-12 weeks

Start date: May 2027

Stipend: $29.00-$37.50 per hour

What we offer

• Company laptop.
• Intern events and speaker sessions (virtual)
• Paid sick time.
• Paid company holidays.
• Mentorship from a dedicated buddy and manager.
• Learning and development stipend.

No agencies or third-party recruiters, please.

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

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