Summer 2027 Data Analyst Intern - Agency Performance, Insights and Operations

American Family Insurance; Madison (WI); Hybrid; USD 18,000 - 23,000; Full time

Job summary

American Family Insurance invites you to join as a Data Analyst Intern in Madison, WI. You will work with the analytics team to transform data into actionable insights for decision-making, develop dashboards, and communicate findings to stakeholders.

You will support small projects, learn about business environments, and gain hands-on experience with SQL, predictive analytics, Claude AI tools, and Microsoft Office while contributing to operational improvements.

Qualifications

• Must be enrolled in a 4-year college/university and graduate August 2027 or later.
• Pursuing a Bachelors, Masters, or PhD in a relevant field.
• Experience with Microsoft Office; predictive analytics, SQL and Claude AI tools preferred.

Responsibilities

• Develop an understanding of the organization’s business environments and structure.
• Open to new ideas and document actions in response to changing situations.
• Support small projects with direction from management and present results to stakeholders.
• Perform analytical work within the assigned functional area.
• Collaborate with partners to collect, analyze, and interpret data and develop reports.
• Other duties as assigned.

Skills

SQL

Predictive analytics

AI tools (Claude)

Microsoft Office

Communication

Education

Bachelor's/Master's/PhD

Tools

Microsoft Office

Job description

As a Data Analyst Intern, you will join a collaborative analytics team focused on transforming data into actionable business insights that support strategic decision-making for our Agency Performance, Insights and Operations Division. Reporting to a Data Analytics leader, you will work with business partners to collect, analyze, and interpret data from a variety of sources, develop reports and dashboards, identify trends and opportunities for improvement, and communicate findings to stakeholders. Through hands-on projects, you will gain experience using data to solve business problems, improve operational performance, and support data-driven recommendations that help achieve organizational goals.

Primary Accountabilities

• Develop an understanding of the organization’s business environments, corporate culture and structure to support work initiatives.
• Open to and supports new ideas, systems and procedures. Generate creative ideas and actions in response to changing situations.
• Supports and plans work on small projects with direction from management.
• May assume the duties normally performed in the department, alongside professionals who perform these roles.
• Present project results to management and/or department personnel.
• Performs analytical work within the assigned functional area.
• Other duties as assigned.

Requirements

• Must be in student status at an accredited 4-year college or university during the internship, graduating August 2027 or later.
• Must be pursuing a Bachelors, Masters, or PhD.
• Major/program must align with internship role.
• Experience with Microsoft Office preferred
• Experience with predictive analytics, SQL, and AI tools such as Claude preferred.
• Position requires the ability to perform basic math calculations (addition, subtraction, multiplication, and division) and basic statistics.
• Position requires the ability to provide verbal and written communication regarding product development issues to various departments and levels of management

This role will work a Hybrid schedule based in Madison, WI.

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.

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.