BI & AI Intern: Data Enablement & Analytics

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

Benefits offered by this job

Housing cost assistance

Hiring bonus eligibility

Job summary

American Family Insurance seeks a Summer 2027 Intern in Business Intelligence Enablement to test new BI and AI capabilities, write SQL to analyze data, and explore AI use cases. You will collaborate with data engineers and BI teams to create training and documentation and help establish best practices for AI-enabled analytics.

The internship emphasizes hands-on learning, cross-functional collaboration, and real-world analytics applications at a Madison, WI headquarters with hybrid options.

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.

Responsibilities

• 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.

Skills

Problem-solving

Analytical skills

Curiosity

Initiative

Willingness to learn

Communication skills

SQL experience

AI tools familiarity

BI interest

Education

Pursuing degree in Analytics/IS/CS/Business

SQL coursework

Power BI / Tableau knowledge

Python familiarity

Tools

Power BI

Tableau

Python

SQL

Job description

American Family Insurance seeks a Summer 2027 Intern in Business Intelligence Enablement to test new BI and AI capabilities, write SQL to analyze data, and explore AI use cases. You will collaborate with data engineers and BI teams to create training and documentation and help establish best practices for AI-enabled analytics.

The internship emphasizes hands-on learning, cross-functional collaboration, and real-world analytics applications at a Madison, WI headquarters with hybrid options.