Data Analytics Intern — Hybrid (Madison, Summer 2027)

American Family Insurance; Madison, Northern (WI, KY); Hybrid; USD 25,000 - 36,000; Full time

Job summary

American Family Insurance is seeking a Data Analyst Intern in Madison to transform data into insights for our Agency Performance, Insights and Operations Division. You will collect, analyze, and interpret data, develop reports and dashboards, and communicate findings to stakeholders to support strategic decisions.

You will work with business partners, apply predictive analytics, and help identify opportunities to improve operational performance.

Qualifications

• Student status at an accredited 4-year college or university, graduating August 2027 or later.
• Pursuing a Bachelor’s, Master’s, or PhD alignment with the internship role.
• Experience with Microsoft Office; familiarity with SQL and AI tools preferred.

Responsibilities

• Collect, analyze, and interpret data from multiple sources to generate actionable insights.
• Develop reports and dashboards to support decision making for Agency Performance, Insights and Operations.
• Identify trends, opportunities for improvement, and communicate findings to stakeholders.
• Present project results to management and department personnel.

Skills

SQL

Excel

Predictive analytics

Communication

Math basics

Education

Pursuing Bachelor's/Master's/PhD

Tools

Claude AI

Job description

American Family Insurance is seeking a Data Analyst Intern in Madison to transform data into insights for our Agency Performance, Insights and Operations Division. You will collect, analyze, and interpret data, develop reports and dashboards, and communicate findings to stakeholders to support strategic decisions.

You will work with business partners, apply predictive analytics, and help identify opportunities to improve operational performance.