About the role#
This internship offers hands-on experience within our P&C IT Services team. You will work alongside BI developers, data engineers, and business stakeholders to build and maintain reporting solutions. This role focuses on developing interactive dashboards and analytics using Microsoft Power BI.
What you'll do#
- Design, develop, and test Power BI reports, scorecards, and visualizations.
- Perform data cleansing, validation, and transformation tasks.
- Build Power Query transformations and write basic DAX expressions.
- Work with SQL-based sources, data warehouses, and enterprise reporting platforms.
- Gather business requirements and translate them into functional reporting solutions.
- Document report specifications, data definitions, and standards.
- Perform QA and testing to ensure report accuracy.
- Assist with deployment, workspace management, and user support.
- Improve existing reporting processes and data accessibility.
- Take part in Power BI training and various analytics projects.
What you'll need#
- Pursuing a degree in Computer Science, Business Analytics, or a related field.
- Proficiency with SQL on relational databases.
- Experience working with Oracle and Snowflake.
- Ability to work from our Cincinnati office at least three days per week.
Location & details#
- Location: Cincinnati, Ohio.
- Term: Summer 2027.
- Modality: Hybrid (requires on-site presence).
- Employment: Part-time internship.
About Great American Insurance Group
Great American Insurance Group provides property and casualty insurance products to various niche markets. The company operates through more than 35 specialty businesses that offer tailored coverage for sectors like agriculture, transportation, and construction. Based in Cincinnati, Ohio, the organization functions as a subsidiary of American Financial Group. It maintains a workforce of nearly 5,000 employees.
How to get in at Great American Insurance Group
Applying early to Great American Insurance Group gives you a distinct advantage because recruiters review applications as they arrive. Intern Insider sends an instant alert the moment a role matching your target is published, so you can submit your materials before the applicant pile grows. This helps you avoid the common frustration of your resume sitting at the bottom of a large stack. You can also use Intern Insider to surface the recruiters behind the company roles. Reaching out directly to ask a specific question about the internship or to request a referral often improves your response rate compared to sending a cold application. It is a more effective way to connect with the team than waiting for a system notification.
