Hybrid FP&A & Data Analytics Intern

Hartford Steam Boiler Inspection and Insurance Company; Hartford (CT); Hybrid; USD 28,000 - 41,000; Full time

Benefits offered by this job

Hybrid work schedule

Team Capstone Project

Networking opportunities

Job summary

Hartford Steam Boiler Inspection and Insurance Company (HSB), a Munich Re company, offers an 11-week Summer Internship in Finance, located in Hartford, CT. The program blends on-site and home-based work, with exposure to FP&A, financial reporting, market analysis, and data visualization projects.

Interns contribute to budgeting support, dashboard development, and data automation, while learning from senior leaders and exploring potential full-time opportunities after graduation.

Qualifications

• Completed Junior year or higher.
• GPA 3.5+ Degree in Finance, Economics, or a related business field.
• Strong Excel and data-analysis skills, with an interest in working with financial and business data.
• Comfortable using AI tools to support research, analysis, and everyday work, while checking results for accuracy.
• Experience with or interest in using tools such as Power BI and Power Automate.
• Strong attention to detail, with the ability to identify inconsistencies, ask thoughtful questions, and follow through on issues requiring further review.
• Diligent and organized, with the ability to plan work, and manage multiple assignments and deadlines.
• Able to communicate clearly, prepare presentations and discuss findings with others, listen to different perspectives, receive feedback, and work effectively with others.
• Curious, proactive, self-aware, and willing to learn new tools and ways of working.
• The ability to work full-time for 11 weeks.

Responsibilities

• Provide analytical support for planning, forecasting, and strategic business decisions.
• Support FP&A activities, including consolidating and validating monthly actuals, maintaining client-level subscription, consulting, and data-buy expense tracking, preparing forecast updates, and performing reconciliations.
• Support third-party insurance market research and analysis, including data analysis, market mapping, and preparation of analytical exhibits.
• Assist with recurring spreadsheet and Power BI reporting and dashboard, including report refreshes, data-quality testing, validation of results, and maintenance of supporting datasets.
• Document and improve recurring finance processes, including planning, forecasting, expense management, reporting procedures, and related controls.
• Support process-improvement initiatives, including helping build and test simple Power Automate workflows to reduce manual tasks and documenting the improved processes.

Skills

Excel

Data analysis

Power BI

Power Automate

Financial data

Presentations

Communication

Teamwork

AI tools

Education

Junior year or higher

GPA 3.5+ in Finance/Economics or related

Tools

Power BI

Power Automate

Job description

Hartford Steam Boiler Inspection and Insurance Company (HSB), a Munich Re company, offers an 11-week Summer Internship in Finance, located in Hartford, CT. The program blends on-site and home-based work, with exposure to FP&A, financial reporting, market analysis, and data visualization projects.

Interns contribute to budgeting support, dashboard development, and data automation, while learning from senior leaders and exploring potential full-time opportunities after graduation.