Back to jobs

Business Intelligence (Power BI) Intern - Summer 2027

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Hybrid — work setting source
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.
Read the full posting
Employment
Part-time — employment source
Employment type in the employer’s posting: Part time
From the employer’s posting

What you’ll work on

Full posting
  • Design, develop, and test Power BI reports and dashboards

  • Perform data cleansing, transformation, and validation

  • Develop Power Query transformations and basic DAX

  • Gather business requirements and turn them into reporting solutions

  • Perform QA/testing for accuracy and consistency

From the employer’s posting
Design, develop, and test Power BI reports and dashboards
Perform data cleansing, transformation, and validation
Develop Power Query transformations and basic DAX
Gather business requirements and turn them into reporting solutions
Perform QA/testing for accuracy and consistency

Before you apply

New graduates
For current studentsPursuing a degree In Computer Science, Business Analytics, or related

What you’ll bring

All qualifications

Core experience

  • Pursuing a degree in Computer Science, Business Analytics, or related
  • SQL skills on relational databases, Oracle, Snowflake
  • Able to work in the office at minimum three days a week
Qualification wording
Pursuing a degree In Computer Science, Business Analytics, or related
SQL Skills on relational DB, Oracle, Snowflake
Ability to work in the office at minimum three days a week.

Benefits in the posting

Full benefits wording
  • 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.
  • 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.
  • *Excludes seasonal employees and interns.

From the employer’s posting.

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 4, 202614 days ago
Recorded sightings
12
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,265 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 14

Similar jobs usually come down between day 5 and day 43.

At American Financial Group, jobs usually come down by about day 38.

From 15,167 similar postings that came down, and 22 of American Financial Group’s. Coming down is not always a hire.

American Financial Group is hiring

10 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring is picking up
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Oracle
  • Power BI
  • Power Query
  • Snowflake
  • SQL Server
Where the posting names them
- 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
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:
Experience/skills: - SQL Skills on relational DB, Oracle, Snowflake -
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:
Responsibilities: - Design, develop, and test Power BI reports and dashboards - Create KPIs, scorecards, visualizations, and operational reports
- Improve reporting processes and data accessibility - Participate in Power BI training and analytics projects Learning Opportunities:
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:
- Perform data cleansing, transformation, and validation - Develop Power Query transformations and basic DAX - Work with SQL-based sources, warehouses, and enterprise reporting platforms

Your next step

Complete your application on gaig.wd1.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

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.

 

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.

 

*Excludes seasonal employees and interns.

About American Financial Group

People
About 8,500 in 2025, down 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as AFG.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 25% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 990, the most 1,513, and the latest week had 1,366.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Cincinnati, OH (USA)

This passage needs a closer read in the full description.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.