Summer 2027 Intern - Business Intelligence Enablement

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

Summer 2027 Intern - Business Intelligence Enablement### Summer 2027 Intern - Business Intelligence EnablementApply: On-site: WI Madison: Full time: Posted Today: End Date: November 21, 2026 (29 days left to apply): R39531Interested 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-HybridWe 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.### About UsAmerican Family Insurance is a mutual holding company and is the nation’s 12th-largest property/casualty insurance group, ranking No. 243 on the Fortune 500 list. The American Family Insurance Group also includes CONNECT, powered by American Family Insurance, Homesite and Main Street America Insurance. An internship with American Family is a great opportunity to build your skillset and explore your career interests. You’ll kick-start your career with an inclusive, purpose-driven company that embraces your ideas, your background and unique experiences to improve the lives of others.