Business Intelligence (Power BI) Intern - Summer 2027

Great American Insurance Group • Cincinnati, OH

5d • Hybrid

About The Position

The Business Intelligence (Power BI) Intern supports the Data team in developing, maintaining, and enhancing business intelligence solutions using Microsoft Power BI. The internship offers hands-on experience with enterprise data, interactive dashboards, reporting, visualization, and analytics, in collaboration with BI developers, data engineers, DBAs, and business stakeholders.

The role is hybrid, combining in-office and remote work, with an expectation of being on site at least three days per week. The intern will have opportunities to learn Power BI Desktop and Service, data modeling, Power Query, DAX, report-design 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 practices, delivering a portfolio of reporting solutions, and gaining practical enterprise BI experience.

Requirements

• Be pursuing a degree in Computer Science, Business Analytics, or a related field.
• Have SQL skills with relational databases, Oracle, and Snowflake.
• Be able to work in the office at least three days per 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 translate 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

• Competitive benefits packages are described for full-time and part-time employees; interns are excluded.
• Medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement are listed for full-time employees.
• Paid time off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits are available to full-time and eligible part-time employees.

What This Job Offers

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