14d ago

IT Finance Intern - Summer 2027

Other

1 views0 saves0 applied

Quick Summary

Key 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,

Requirements Summary

Ability to work in the office at minimum three days a week. Education: Pursuing a degree in Finance or Accounting Preferred: prior coursework or experience in financial analysis, budgeting,

Technical Tools

Other

What We Offer

~1 min read

We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits.

Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers.

Responsibilities

~1 min read

→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 to support budgeting, forecasting, and analysis
→Develop and refresh Power BI dashboards and reports that present financial and operational metrics clearly to stakeholders
→Prepare polished, 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

Requirements

~1 min read

Ability to work in the office at minimum three days a week.

Education:

Pursuing a degree in Finance or Accounting

Preferred: prior coursework or experience in financial analysis, budgeting, or forecasting

2028 graduation year preferred

Experience/skills:

Advanced Microsoft Excel skills, including formulas and functions such as XLOOKUP/VLOOKUP, SUMIFS, and INDEX/MATCH; PivotTables; and data cleansing and modeling
Strong Microsoft PowerPoint skills, with 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 (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: Experience with Power Query or other data transformation tools

Property & Casualty IT Services