Summer 2027 Intern - Business Intelligence Enablement

Location: WI Madison, United States of America

Interested in data, analytics, and AI? As a Business Intelligence Enablement Intern, you'll partner with data engineers and BI professionals to test emerging analytics tools, explore AI use cases, and help create resources that make new technologies easier to understand and adopt.

Interns may be eligible for a one-time hiring bonus to assist with housing costs depending upon proximity to our company office location.

Compensation Minimum: $25.00 Compensation Maximum: $39.00

What You'll Do

Test and evaluate new business intelligence and AI capabilities.

Write SQL queries to extract, validate, and analyze data.

Explore how AI and large language models can enhance analytics workflows.

Partner with technical teams to understand data and reporting solutions.

Create documentation, training materials, and job aids.

Present findings, recommendations, and demonstrations to stakeholders.

Help establish best practices for AI-enabled analytics tools.

What You'll Learn

Business intelligence and analytics platforms

Data modeling, reporting, and visualization

Real-world applications of AI and generative AI

User enablement and change management

Cross-functional collaboration with business and technology teams

What We're Looking For

Strong problem-solving and analytical skills

Curiosity, initiative, and a willingness to learn

Experience with SQL and data analysis

Strong written, verbal, and presentation skills

Interest in analytics, business intelligence, and emerging technologies

Experience using AI tools such as Microsoft Copilot, Claude, Gemini, or similar platforms

Preferred Qualifications

Pursuing a degree in Analytics, Information Systems, Computer Science, Business, or a related field

Coursework or projects involving SQL, reporting, analytics, or AI

Experience with Power BI, Tableau, or similar tools

Familiarity with Python or other data-related technologies

Why This Internship?

This role goes beyond traditional analytics work. You'll help shape how teams use data and AI, influence adoption of emerging technologies, and gain hands-on experience at the forefront of business intelligence innovation.

Specialized Knowledge & Skills Requirements

Demonstrated experience providing customer-driven solutions, support, or service.

Must be currently seeking a baccalaureate, masters, or doctoral degree and be enrolled in an accredited college or university on a full-time basis or as required by the university's co-op program.

Must have achieved 24 semester hours of academic credit before beginning the first work term.

Experience with Tableau, Google Data Studio, or other Business Insights Dashboarding tools.

Experience using Claude, Gemini or other LLM to explore data, write queries, or develop applications.

Proficiency in SQL.

Travel Requirements • Up to 10%.

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: 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; Boston, MA.

#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 [email protected] to request a reasonable accommodation.