Business Intelligence (Power BI) Intern

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.

The Business Intelligence (BI) Intern will support the Data team in the development, maintenance, and enhancement of business intelligence solutions using Microsoft Power BI. This role provides hands-on experience working with enterprise data, creating interactive dashboards, developing reports, and helping business users gain insights through data visualization and analytics. The intern will collaborate with BI developers, data engineers, database administrators, and business stakeholders to deliver reporting solutions that support data-driven decision-making.

Key Responsibilities

• Assist in the design, development, and testing of Power BI reports and dashboards.

• Create and maintain visualizations, KPIs, scorecards, and operational reports.
• Support data preparation activities, including data cleansing, transformation, and validation.
• Develop and modify Power Query transformations and basic DAX calculations.
• Work with SQL-based data sources, data warehouses, and enterprise reporting platforms.
• Participate in gathering business requirements and translating them into reporting solutions.
• Help document report specifications, data definitions, and development standards.
• Perform report testing and quality assurance to ensure accuracy and Assist with report deployment, workspace management, and user support consistency.
• activities.
• Collaborate with team members to identify opportunities to improve reporting processes and data accessibility.
• Participate in Power BI training, knowledge-sharing sessions, and analytics team projects.

Learning Opportunities

During the internship, the candidate will gain experience with:

• Power BI Desktop and Power BI Service
• Data modeling and relationships
• Power Query and DAX
• Dashboard and report design best practices
• Enterprise data governance and reporting standards
• Working with SQL Server, Oracle, and cloud-based data sources
• Agile project delivery and stakeholder engagement

Expected Outcomes

By the conclusion of the internship, the intern will:

• Develop and publish production-ready Power BI reports and dashboards.
• Demonstrate proficiency with data visualization and report design best practices.
• Deliver a portfolio of reporting solutions that provide measurable business value.

Gain practical experience working within an enterprise analytics and business intelligence environment

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.