IT Finance Intern - Summer 2027
About The Position
Great American Insurance Group is seeking an FP&A Finance Intern for summer 2027 to support its Property & Casualty IT Finance team. The role provides hands-on exposure to financial planning and analysis within a P&C technology organization. The intern will build analytical and reporting skills while contributing deliverables used by IT Finance and business leaders. Advanced Excel, PowerPoint, and Power BI skills are central to success. This is a hybrid role combining in-office and remote work. Employees are expected to maintain a meaningful on-site presence; this role requires working in the office at least three days a week. The position is part of Property & Casualty IT Services.
Requirements
- Pursuing a degree in Finance or Accounting.
- Able to work in the office at least three days a week.
- Advanced Microsoft Excel skills, including XLOOKUP/VLOOKUP, SUMIFS, INDEX/MATCH, PivotTables, data cleansing, and modeling.
- Strong Microsoft PowerPoint skills, including the ability to create clear, professional presentations and data visualizations.
- Working knowledge of Power BI, including building reports and dashboards, connecting to data sources, and creating basic measures using DAX.
- 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.
- 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.
- Partner with finance and IT colleagues to ensure data accuracy and timely delivery of recurring and ad hoc reporting.
Benefits
- Competitive benefits packages are described as available for full-time and part-time employees, but the listed benefits exclude interns.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Intern
Education Level
No Education Listed
