Product Analytics 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. Monday to Friday, regular working hours, flexible start and finish. We use Slack, Notion and Google Meet. Cameras on for team calls.

Responsibilities

• Join a weekly call with the analytics lead to review your work
• Track marketing campaign results using Google Analytics 4 data
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

What we're looking for

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Laptop with Excel or Google Sheets and a stable internet connection
• Comfort with numbers and strong attention to detail
• A sample dashboard or analysis project you can share
• Basic SQL, enough to write SELECT queries with joins and filters

Preferred

• Google Data Analytics or Microsoft PL-300 certification
• Python with pandas for data cleaning
• Knowledge of basic statistics such as medians, percentiles and correlation

Duration: 16 weeks

Start date: Jan 2027

Stipend: $30.50 - $34.50 an hour

Perks

• Paid sick time
• Return offer opportunities
• Final presentation to leadership
• Home office setup stipend

Duration: 16 weeks. Start: Jan 2027.

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