Business Intelligence (Power BI) Intern - Summer 2027

Great American Insurance Company • Cincinnati, OH

4d • Hybrid

About The Position

The Business Intelligence (Power BI) Intern supports the Data team with developing, maintaining, and enhancing business intelligence solutions using Microsoft Power BI. The role provides hands-on experience with enterprise data, interactive dashboards, reporting, visualization, and analytics, while collaborating with BI developers, data engineers, database administrators, and business stakeholders. It is part of Property & Casualty IT Services, which provides technology services and solutions to business units and corporate functions.

This is a hybrid role combining in-office and remote work, with a meaningful on-site presence expected. The intern is expected to work in the office at least three days per week. Learning opportunities include Power BI Desktop and Service, data modeling, Power Query, DAX, report-design best practices, enterprise data governance, SQL Server, Oracle, cloud data sources, Agile delivery, and stakeholder engagement. Expected outcomes include developing and publishing production-ready Power BI reports and dashboards, demonstrating proficiency in visualization and report design, delivering a portfolio of reporting solutions, and gaining practical enterprise BI experience.

Requirements

• Pursuing a degree in Computer Science, Business Analytics, or a related field.
• SQL skills with relational databases, Oracle, and Snowflake.
• Ability to work in the office at least three days a week.

Responsibilities

• Design, develop, and test Power BI reports and dashboards.
• Create KPIs, scorecards, visualizations, and operational reports.
• Perform data cleansing, transformation, and validation.
• Develop Power Query transformations and basic DAX.
• Work with SQL-based sources, warehouses, and enterprise reporting platforms.
• Gather business requirements and turn them into reporting solutions.
• Document report specifications, data definitions, and standards.
• Perform quality assurance and testing for accuracy and consistency.
• Assist with deployment, workspace management, and user support.
• Improve reporting processes and data accessibility.
• Participate in Power BI training and analytics projects.

Benefits

• The posting describes benefits available to full-time employees, but explicitly excludes interns from these benefits.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed