IT Finance Intern - Summer 2027

Great American Insurance Group; United States; Hybrid; USD 20,000 - 33,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Paid time off & holidays

401(k) with company match

Job summary

Great American Insurance Group is seeking an FP&A Finance Intern for summer 2027 within the P&C IT Services. The role offers hands-on exposure to financial planning and analysis in a technology-focused IT Finance team.

Strong Excel, PowerPoint, and Power BI skills are essential as you support budgeting, forecasting, and reporting to business leaders. You will analyze headcount and expenses, build advanced Excel models, and create executive-ready presentations while collaborating with finance and

Qualifications

• Pursuing a Finance or Accounting degree with 2028 graduation preferred.
• Ability to work in the office at least three days a week.
• Experience in financial analysis, budgeting, or forecasting is a plus.

Responsibilities

• Support the P&C IT annual budget process with data gathering and reconciliation.
• Develop and refresh Power BI dashboards and executive PowerPoint presentations.
• Analyze headcount and expenses to identify variances and forecast.
• Provide day-to-day FP&A support to IT Finance team.

Skills

Analytical thinking

Attention to detail

Written and verbal communication

Multitasking

Education

Pursuing a degree in Finance or Accounting

Tools

Excel

PowerPoint

Power BI

DAX

PivotTables

Job description

Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group's member companies are subsidiaries of American Financial Group. We combine a \"small company\" culture where your ideas will be heard with \"big company\" expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow. At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best.

P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors.

Great American's culture is built on connection, shared learning, and strong relationships.

This is a hybrid role that combines in-office and remote work. Employees are expected to maintain a meaningful on-site presence to support collaboration, relationship building, and business success.

The 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 Property & Casualty (P&C) technology organization. The intern will build analytical and reporting skills while contributing to real deliverables used by IT Finance and business leaders. Strong command of Excel, PowerPoint, and Power BI will be central to success in this role.

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

• 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

Business Unit

• Property & Casualty IT Services

Benefits

• 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
• *Excludes seasonal employees and interns

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.

Great American Insurance Group understands the importance of choosing a financially strong company. We are an organization built for the long term and are committed to giving you that strength. Why can you trust Great American Insurance Group? For nearly 150 years, Americans have trusted us to protect them. Our innovative insurance solutions and specialization serves niche marketplaces that we know well. This expertise gives us a successful foundation that spans generations. You never know where a career in insurance will take you. Whether you are starting your career or are looking for a company to grow your experience, at Great American Insurance Group, you can join our more than 8,500 employees to “Be Here. Be GREAT!”

To learn more, visit our Career Page