About the role#
The IT Finance team is hiring an intern for Summer 2027. This role provides hands-on experience with financial planning and analysis inside a Property & Casualty technology organization. You will build analytical and reporting skills while contributing to real deliverables used by finance and business leaders.
What you'll do#
- Support the P&C IT annual budget process through data gathering, model updates, and reconciliation.
- Provide daily FP&A support to the IT Finance team.
- Analyze headcount and expense trends to identify variances against plans and forecasts.
- Build and maintain advanced Excel models to support budgeting and analysis.
- Develop and refresh Power BI dashboards to present financial and operational metrics to stakeholders.
- Prepare executive-ready PowerPoint presentations that translate analysis into clear insights and recommendations.
- Partner with finance and IT colleagues to ensure data accuracy and deliver recurring and ad hoc reporting.
What you'll need#
- Current pursuit of a degree in Finance or Accounting.
- Advanced Microsoft Excel skills, including formulas like XLOOKUP, VLOOKUP, SUMIFS, and INDEX/MATCH, along with PivotTables and data modeling.
- Strong Microsoft PowerPoint skills for creating professional presentations and data visualizations.
- Working knowledge of Power BI, including building reports, connecting to data sources, and creating basic DAX measures.
- Strong analytical, problem-solving, and attention-to-detail skills.
- Effective written and verbal communication skills.
- Ability to manage multiple priorities and meet deadlines.
- Preferred: Prior coursework or experience in financial analysis, budgeting, or forecasting.
- Preferred: 2028 graduation year.
- Preferred: Experience with Power Query or other data transformation tools.
Location & details#
- Location: Cincinnati, Ohio.
- Term: Summer 2027.
- Modality: Hybrid, with a requirement to work in the office at least three days a week.
- Employment: Part-time, paid 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.
