Business Intelligence (Power BI) Intern - Summer 2027

Great American Insurance Group; Cincinnati (OH); Hybrid; USD 25,000 - 39,000; Full time

Benefits offered by this job

Medical, Dental, Vision coverage

Paid Time Off and Holidays

401(k) with company match

Employee stock purchase plan

Commuter benefits

Job summary

Great American Insurance Group is seeking a BI intern within its Data team in Cincinnati. The role focuses on creating Power BI reports/dashboards, transforming data, and collaborating with BI developers, data engineers, DBAs, and business stakeholders.

The position offers hands-on enterprise BI experience in a hybrid work setting. Ideal candidates are pursuing a degree in Computer Science or Business Analytics, with SQL and Power BI skills and the ability to work on-site at least three days per

Qualifications

• Pursuing a degree in Computer Science, Business Analytics, or related field.
• SQL skills on relational databases (Oracle, Snowflake).
• Ability to work in the office at minimum 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 QA/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.

Skills

SQL

Relational DB

Oracle

Snowflake

Education

Pursuing degree in Computer Science/Business Analytics

Tools

Power BI

Job description

Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group’s member companies are subsidiaries of American Financial Group. We combine a “small company” culture where your ideas will be heard with “big company” expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow.

At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.

P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors.

Great American’s culture is built on connection, shared learning, and strong relationships. This is a hybrid role that combines in-office and remote work. Employees are expected to maintain a meaningful on-site presence to support collaboration, relationship building, and business success.

The BI intern supports the Data team with the development, maintenance, and enhancement of BI solutions using Microsoft Power BI. The role provides hands‑on experience with enterprise data, interactive dashboards, reporting, visualization, and analytics. It also calls out collaboration with BI developers, data engineers, DBAs, and business stakeholders.

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 QA/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

Learning Opportunities

Power BI Desktop/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

The intern would develop and publish production‑ready Power BI reports/dashboards, demonstrate proficiency in visualization/report‑design practices, deliver a portfolio of reporting solutions, and gain practical enterprise BI experience.

Requirements

Ability to work in the office at minimum three days a week.

Education

• Pursuing a degree In Computer Science, Business Analytics, or related

Experience / Skills

• SQL Skills on relational DB, Oracle, Snowflake

Business Unit

Property & Casualty IT Services

Benefits

We offer competitive benefits packages for full‑time and part‑time employees*. Full‑time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full‑time and eligible part‑time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.

*Excludes seasonal employees and interns.

Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.