IT Finance Intern

Great American Insurance Group

. Support the P&C IT annual budget process, including data gathering, model updates, and reconciliation .

Posted 10/27/2026part-timeCincinnati • Ohio • United StatesEntry LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced financial analysis capabilities through proficiency in Excel modeling, Power BI reporting, and effective communication of insights. Capable of managing multiple priorities while ensuring data accuracy and timely reporting.

Highest-signal resume keywords

Advanced Microsoft Excel SkillsPower BI Reporting and Dashboard DevelopmentFinancial Analysis and BudgetingEffective Communication SkillsAnalytical and Problem-Solving Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Financial AnalysisBudgetingForecastingData CleansingModelingXLOOKUPVLOOKUPSUMIFSINDEX/MATCHPivotTables

Soft Skills

Attention to DetailEffective Written CommunicationEffective Verbal CommunicationCollaborationTime Management

Tools & Technologies

Microsoft ExcelMicrosoft PowerPointPower BIPower Query

Industry Keywords

FP&A SupportData AccuracyOperational MetricsExecutive PresentationsAd Hoc Reporting

About the role

Key responsibilities & impact

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
Prepare executive-ready PowerPoint presentations translating analysis into insights and recommendations
Partner with finance and IT colleagues to ensure data accuracy and timely delivery of recurring and ad hoc reporting

Requirements

What you’ll need

Ability to work in the office at minimum three days a week
Pursuing a degree in Finance or Accounting
Advanced Microsoft Excel skills, including XLOOKUP/VLOOKUP, SUMIFS, 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 measures (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
Preferred: prior coursework or experience in financial analysis, budgeting, or forecasting
2028 graduation year preferred
Preferred: Experience with Power Query or other data transformation tools

Benefits

Comp & perks

Competitive benefits packages for full-time and part-time employees
Medical, dental, and vision coverage for full-time employees
Wellness plans for full-time employees
Parental leave for full-time employees
Adoption assistance for full-time employees
Tuition reimbursement for full-time employees
Paid Time Off for full-time and eligible part-time employees
Paid holidays for full-time and eligible part-time employees
401(k) plan with company match for full-time and eligible part-time employees
Employee stock purchase plan for full-time and eligible part-time employees
Commuter benefits for full-time and eligible part-time employees