Business Intelligence Enablement Intern

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

Benefits offered by this job

Housing bonus

Benefits package

Job summary

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

You may qualify for a one-time housing bonus based on proximity to the Madison, WI office, and intern housing support is described. The role includes exposure to Power BI, Tableau, and other BI tools.

Qualifications

• Pursuing a degree in analytics, information systems, CS, business, or related field.
• Experience with SQL and data analysis.
• Experience with BI tools or dashboards is preferred.

Responsibilities

• Test and evaluate new BI and AI capabilities.
• Write SQL queries to extract, validate, and analyze data.
• Explore how AI can enhance analytics workflows.
• Partner with technical teams to understand data and reporting solutions.
• Create documentation, training materials, and job aids.
• Present findings and recommendations to stakeholders.
• Help establish best practices for AI-enabled analytics tools.

Skills

SQL

Data analysis

Presentation skills

Problem solving

Curiosity

Willingness to learn

Education

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

Tools

Tableau

Power BI

Google Data Studio

Claude

Gemini

Copilot

Job description

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.