IT Finance Intern - Summer 2027

Great American Insurance Company • Cincinnati, OH

11d • Hybrid

About The Position

The IT Finance Intern will support financial planning and analysis for Great American Insurance Group’s Property & Casualty technology organization during summer 2027. The role provides hands-on experience with budgeting, forecasting, financial analysis, reporting, and communicating insights to IT Finance and business leaders. The intern will use Excel, PowerPoint, and Power BI to contribute to recurring and ad hoc deliverables. This is a hybrid role, with a required in-office presence of at least three days per week.

Requirements

• Pursuing a degree in Finance or Accounting.
• Able to work in the office at least three days per week.
• Advanced Microsoft Excel skills, including formulas and functions such as XLOOKUP/VLOOKUP, SUMIFS, and INDEX/MATCH; PivotTables; data cleansing; and modeling.
• Strong Microsoft PowerPoint skills, including creating clear, professional presentations and data visualizations.
• Working knowledge of Power BI, including building reports and dashboards, 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 in a collaborative environment.

Nice To Haves

• Prior coursework or experience in financial analysis, budgeting, or forecasting.
• 2028 graduation year preferred.
• Experience with Power Query or other data transformation tools.

Responsibilities

• Support the P&C IT annual budget process, including data gathering, model updates, and reconciliation.
• Provide day-to-day FP&A support to the IT Finance team.
• Analyze headcount and expense trends and identify variances to plan and forecast.
• Build and maintain advanced Excel models and workbooks for budgeting, forecasting, and analysis.
• Develop and refresh Power BI dashboards and reports presenting financial and operational metrics to stakeholders.
• Prepare executive-ready PowerPoint presentations that translate analysis into concise insights and recommendations.
• Work with finance and IT colleagues to ensure data accuracy and timely delivery of recurring and ad hoc reporting.

Benefits

• The posting describes competitive benefits packages for full-time and part-time employees, but excludes interns and seasonal employees; therefore, the listed benefits are not stated as available to this internship.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed