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

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

## Summer 2027 Data Analyst Intern - Agency Performance, Insights and OperationsApply: On-site: WI Madison: Full time: Posted Today: End Date: October 31, 2026 (18 days left to apply): R39513As 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. • Presents 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 managementThis 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.