Hybrid IT Finance Intern: FP&A, Excel & Power BI

New Grad; Cincinnati (OH); Hybrid; USD 28,000 - 39,000; Full time

Benefits offered by this job

Tuition reimbursement

Paid Time Off

401(k) plan with company match

Commuter benefits

Job summary

Great American Insurance Group's IT Finance team is seeking an FP&A Finance Intern for summer 2027. This role offers hands‑on exposure to financial planning and analysis within a P&C technology organization, building analytical and reporting skills while delivering real deliverables used by IT Finance and business leaders.

Strong command of Excel, PowerPoint, and Power BI will be central, with opportunities to develop dashboards, budgets, and ad hoc reports.

Qualifications

• Pursuing a degree in Finance or Accounting.
• Advanced Microsoft Excel skills (XLOOKUP, VLOOKUP, SUMIFS, INDEX/MATCH).
• Proficiency in PowerPoint for executive presentations.
• Experience with Power BI for reporting and dashboards.

Responsibilities

• Support the FP&A budget and forecasting processes with data gathering and model updates.
• 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 and analysis.
• Develop and refresh Power BI dashboards and executive‑level reports.

Skills

Analytical skills

Attention to detail

Communication

Multitasking

Data modeling

Education

Finance or Accounting degree (pursuing)

Tools

Excel

PowerPoint

Power BI

Power Query

Job description

Great American Insurance Group's IT Finance team is seeking an FP&A Finance Intern for summer 2027. This role offers hands‑on exposure to financial planning and analysis within a P&C technology organization, building analytical and reporting skills while delivering real deliverables used by IT Finance and business leaders.

Strong command of Excel, PowerPoint, and Power BI will be central, with opportunities to develop dashboards, budgets, and ad hoc reports.