IT Business Analyst Intern - 2027 Summer Intern

Wilton RE•Norwalk, CT

3d•$20 - $30•Hybrid

About The Position

Wilton Re’s Norwalk-based internship program is a fast-paced, 10–12-week opportunity for students to gain professional experience in their field of study or career interest. Interns apply and extend classroom learning while contributing to active Wilton Re projects, participating in community outreach, developing professional skills and business acumen, and connecting with senior leaders, mentors, and fellow interns. The IT Business Analyst Intern supports business requirements gathering and documentation, business process analysis and improvement, Microsoft Fabric and Power BI work, testing, and project delivery activities under guidance. The position is based in Norwalk, Connecticut, with a hybrid schedule of three days in the office and two days working from home. The internship runs from the beginning of June to mid-August, and candidates must be able to work full time during that period.

Requirements

Be a rising junior or senior.
Attend a four-year university and pursue a bachelor-level degree in Business, Business Analytics, Data Analytics/Data Science, Information Systems, or a related field.
Be able to work full time from the beginning of June to mid-August.
Be authorized to work in the United States.
Have an adaptable and positive attitude, strong communication skills, a continuous growth mindset, and a collaborative and innovative approach.
Have coursework or academic projects in business analysis, data analysis, databases, or information systems.
Have introductory SQL knowledge and comfort using Excel, Word, and PowerPoint.
Show attention to detail in documentation, data checks, and testing.

Nice To Haves

Exposure to Power BI or similar reporting tools, agile concepts, or Jira/Azure DevOps; helpful but not required.
Interest in learning how IT supports insurance or financial services.
Prior internship or industry experience is not required.

Responsibilities

Assist with gathering and documenting business requirements, user stories, acceptance criteria, process flows, and data mappings for data, reporting, and analytics enhancements.
Support business process improvements and analysis using Microsoft Fabric, Power BI, and AI agents.
Assist with building out and managing Microsoft Fabric tools, including testing the latest functionality.
Help prepare and execute test cases, including regression and user acceptance testing; document defects, support retesting, and compare results with requirements under guidance.
Support project milestones and dependency tracking, status updates, and delivery documentation; suggest process improvements for team review.