What are the responsibilities and job description for the Business Analyst Intern position at Great American Insurance Group?
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.
Our Strategic Sourcing department is looking for a Business Analyst intern to assist with Strategic Sourcing specializing in content updates and business data analytics. The position is hybrid and based out of our Cincinnati, OH headquarters.
Key Attributes
Data Maintenance and Analytics
AFG Procurement
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.
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.
Our Strategic Sourcing department is looking for a Business Analyst intern to assist with Strategic Sourcing specializing in content updates and business data analytics. The position is hybrid and based out of our Cincinnati, OH headquarters.
Key Attributes
- Strong attention to detail, particularly in validating data accuracy, maintaining data integrity, and performing periodic data and site updates
- Coachable and receptive to feedback, with the ability to actively listen and apply guidance
- Effective communication and knowledge-sharing skills, with the ability to translate data into clear narratives and actionable insights
- Demonstrated interest in responsible AI usage, with awareness of governance, data control, and appropriate business application
- Proficiency in Microsoft Excel, SharePoint, and Teams, including dashboard creation, data manipulation, SharePoint site content management, and collaboration tools
- Foundational understanding of data structures, data modeling, and data visualization concepts, with the ability to identify trends and articulate meaningful insights (data storytelling)
- Strong organizational skills, with the ability to manage multiple concurrent tasks and priorities effectively
- Self-motivated and capable of working independently with minimal supervision
Data Maintenance and Analytics
- Extract, consolidate, and reconcile datasets from multiple systems to ensure accuracy
- Maintain dashboards and visualizations
- Interpret data and communicate insights through clear narratives
- Maintain and update internal sites and shared repositories,
- Support workflow automation (e.g., Power Automate)
- Manage onboarding activities, including user access, permissions, and group management
- Maintain and update monthly spend reports and dashboards
- Import documents and apply metadata for organization and retrieval
- Maintain and document BU profiles and related processes
- Run reports for upcoming contract renewals
- Assist in cost trending analysis
- Explore AI-enabled tools (as applicable) to support agreement analysis and summary creation
- Currently enrolled in college and pursing a Bachelor's degree related to information technology with a desire to be technical Business Analyst or Data Science
- Ability to work 20-40 hours weekly
- Prior business analyst
- Prior experience with procurement related tasks not required
AFG Procurement
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.