FP&A Intern, IT Finance (Hybrid) – Summer 2027

Great American Insurance Group; Cincinnati (OH); Hybrid; USD 20,000 - 33,000; Part time

Job summary

Great American Insurance Group is seeking a FP&A Finance Intern for Summer 2027 in a hybrid role that combines in-office and remote work. The intern will gain hands-on exposure to financial planning and analysis within a Property & Casualty IT Services environment, building analytical and reporting skills while delivering real deliverables used by IT Finance and business leaders.

Strong Excel, PowerPoint, and Power BI are essential.

Qualifications

• Advanced Microsoft Excel skills, including formulas and functions (XLOOKUP/VLOOKUP, SUMIFS, INDEX/MATCH)
• Strong PowerPoint skills for clear presentations and data visuals
• Working knowledge of Power BI, building reports/dashboards and basic measures (DAX)
• Strong analytical, problem-solving, and attention to detail
• Excellent written and verbal communication
• Ability to manage multiple priorities and meet deadlines in a team setting
• Experience with Power Query or other data transformation tools (preferred)

Responsibilities

• Support the P&C IT annual budget process with 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 and forecasting
• Develop and refresh Power BI dashboards and reports for stakeholders
• Prepare executive-ready PowerPoint presentations translating analysis into insights
• Collaborate with finance and IT colleagues to ensure data accuracy and timely reporting

Skills

Excel

PowerPoint

Power BI

DAX

Attention to detail

Communication

Multitasking

Education

Pursuing a degree in Finance or Accounting

Tools

Power BI

Power Query

Job description

Great American Insurance Group is seeking a FP&A Finance Intern for Summer 2027 in a hybrid role that combines in-office and remote work. The intern will gain hands-on exposure to financial planning and analysis within a Property & Casualty IT Services environment, building analytical and reporting skills while delivering real deliverables used by IT Finance and business leaders.

Strong Excel, PowerPoint, and Power BI are essential.