Summer 2027 Intern - Data Analyst

American Family Insurance; Madison (WI); Hybrid; USD 34,000 - 54,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Pension plan

Paid holidays

Paid time off

Student loan repayment

Job summary

American Family Insurance is offering a Data Analyst Intern position in Madison, WI. The 10–14 week summer internship begins mid-May and ends in August, with hybrid work options and opportunities for coaching and networking.

You will transform data into insights to improve contact centers, underwriting, and policy servicing, and develop dashboards while gaining exposure to multiple business areas for hands-on learning.

Qualifications

• Must be pursuing a degree (Bachelors, Masters, or PhD) during internship.
• Must have completed 24 semester hours before start.
• Ability to transform data into actionable insights for business partners.

Responsibilities

• Develop dashboards and reports to support data-driven decisions.
• Analyze and transform data into meaningful insights across operations.
• Collaborate with teams using Tableau, SQL, Python and GCP.

Skills

Tableau

SQL

Python

GCP

Education

Bachelors / Masters / PhD

Tools

Tableau

SQL

Python

GCP

Job description

An internship with American Family Insurance is a great opportunity to build your skillset and explore your career interests. Our summer student internship is a 10 - 14 week program that starts in mid-May and ends in August. During your internship, you’ll work on impactful projects that make a difference at our company, with our customers, and in our communities. You’ll also gain exposure to different areas of our business and have numerous opportunities for networking and coaching.

As a Data Analyst Intern you will report to the Data Analytics Senior Manager.
You will support American Family’s Operational Shared Services teams by transforming data into meaningful insights that help improve performance across contact centers, underwriting, and customer and policy servicing operations. In this role, you’ll work with a variety of data sources to gather, extract, analyze, and visualize information that supports business decisions, uncovers trends, and drives operational improvements.

You’ll gain hands‑on experience preparing and validating data, building dashboards and reports, and translating complex findings into clear, actionable recommendations for business partners. You’ll also have opportunities to support data cleansing, manipulation, and basic modeling efforts that help improve workflow efficiency, service outcomes, and overall business performance.

This internship is ideal for a curious, analytical problem‑solver who is excited about using data to enhance customer and employee experiences in a fast‑paced, collaborative environment. You’ll work alongside experienced professionals, gain exposure to real‑world business challenges, and develop skills that will support a future career in data analytics.

Compensation Minimum: $25.00
Compensation Maximum: $39.00

Responsibilities

• Develop an understanding of our business, corporate culture and structure to support your work.
• Contribute creative ideas and strategic approaches in response to changing situations.
• Analyze and transform data into meaningful dashboards, performance reports, and actionable insights that support using tools such as Tableau, SQL, Python, and GCP.

Requirements

• Must have achieved 24 semester hours of academic credit before beginning the first work term.
• Must be in student status at an accredited 4‑year college or university during the internship, graduating August 2028 or later.
• Must be pursuing a Bachelors, Masters, or PhD.
• Major/program must align with internship role.

Travel Requirements

• Up to 10%.

Physical Requirements

• Work that primarily involves sitting/standing.

This is a hybrid role based out of the Madison, WI Corporate office.

Additional Information

• To ensure a strong start, all employees participate in our New Employee Orientation during their first week. This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth. At times, sessions may be delivered virtually based on scheduling and availability.
• Offer to selected candidate will be made contingent on the results of applicable background checks
• Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions
• Sponsorship will not be considered for this position unless specified in the posting

Due to the nature of this role, we are unable to consider candidates who may require visa sponsorship.

Work Location: Madison, WI

This role may be considered for a Full-Time in Office or Hybrid work arrangement based on the selected candidate’s location. Work locations for this role include Madison, WI.

#LI-Hybrid

We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email [e-mail] to request a reasonable accommodation.

#LI-SK1