Summer 2027 Intern - Business Intelligence Enablement

American Family Insurance; Madison (WI); Hybrid; USD 34.000 - 54.000; Teilzeit

Benefits dieser Stelle

Housing assistance bonus

Zusammenfassung

American Family Insurance is seeking a Business Intelligence Enablement Intern to test BI and AI capabilities, write SQL queries, and explore AI use cases. You will collaborate with data engineers and BI professionals to create resources that simplify adoption of new analytics tools.

The role offers hybrid work in Madison, WI, with a housing-related signing bonus possible for proximity to the office. Travel up to 10% is required.

Qualifikationen

• Must be enrolled full-time in a degree program (bachelor's to doctoral).
• Must have completed 24-semester hours before starting the first term.
• Experience with SQL and data analysis.
• Experience with Tableau, Google Data Studio, or similar BI dashboards.
• Experience using Claude, Gemini or other LLMs.
• Travel up to 10%.

Aufgaben

• Test and evaluate new BI and AI capabilities.
• Write SQL queries to extract, validate, and analyze data.
• Explore how AI and LLMs 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.

Kenntnisse

SQL & data analysis

Problem solving

Curiosity & learning

Communication

Presentation skills

Interest in analytics/AI

Ausbildung

Bachelors/Master/PhD in Analytics / IS / CS / Business

Tools

Power BI

Tableau

Google Data Studio

Python

Claude/Gemini/Copilot (LLMs)

Jobbeschreibung

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 [e-mail] to request a reasonable accommodation.