IT Business Analyst Intern - 2027 Summer Intern

Wilton Re; Norwalk (CT); Hybrid; USD 28,000 - 41,000; Full time

Benefits offered by this job

Meaningful project work

Competitive pay

Mentorship and leadership exposure

Job summary

Wilton Re in Norwalk, CT seeks an IT Business Analyst Intern for a 2027 summer internship. The role focuses on gathering requirements, writing user stories, and supporting analytics projects using Power BI and Microsoft Fabric.

This 10-12 week program offers mentorship, exposure to senior leaders, and hands-on project work. Ideal candidates are rising juniors or seniors pursuing business, analytics, data science, or information systems, with basic SQL and Excel skills.

Qualifications

• Introductory SQL knowledge and comfort using Excel/Word/PowerPoint.
• Pursuing a bachelor-level degree in Business, Analytics, or Information Systems.
• Ability to work full-time during early June to mid-August.

Responsibilities

• Assist with gathering and documenting business requirements, user stories, acceptance criteria, and data mappings.
• Support business process improvements and analysis using Microsoft Fabric, Power BI, and AI agents.
• Assist with build out and management of Microsoft Fabric tools, including testing.
• Help prepare and execute test cases, including regression and user acceptance testing; document defects and support retesting.

Skills

SQL knowledge

Communication skills

Adaptability

Collaboration

Education

Bachelor's degree in Business or related field

Tools

Microsoft Fabric

Power BI

Jira/Azure DevOps

Excel

Job description

IT Business Analyst Intern - 2027 Summer Intern

We are searching for an experienced IT Business Analyst Intern - 2027 Summer Intern at our Connecticut office.

ITBusiness Analyst Intern

Program Overview

Wilton Re's Norwalk based internship program is 10-12 weeks, fast-paced, and an exciting opportunity to gain professional experience within your field of study or career interest. Interns will be part of an accelerated learning experience, to challenge skills learned in the classroom and develop new skills while working on active Wilton Re projects. In addition, interns will connect to our company culture through community outreach projects and be able to develop their professional skills and business acumen through frequent exposure to senior leadership, unique projects, and a network of mentors and fellow interns.

Responsibilities

• Under guidance, 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 build out and management of Microsoft Fabric tools, including testing out 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 review by the team.

What We Look for in a Candidate

• Rising junior or senior
• Attending a 4-year university, pursuing a bachelor level degree in Business, Business Analytics, Data Analytics/Data Science, Information Systems, or a related field
• Ability to work full time beginning of June to mid-August
• Authorization to work in the U.S.
• Adaptable and positive attitude
• Strong communication skills
• Continuous growth mindset
• Collaborative and innovative
• Coursework or academic projects in business analysis, data analysis, databases, or information systems
• Introductory SQL knowledge and comfort using Excel, Word, and PowerPoint; attention to detail in documentation, data checks, and testing
• Exposure to Power BI or similar reporting tools, agile concepts, or Jira/Azure DevOps is helpful but not required
• Interest in learning how IT supports insurance or financial services; prior internship or industry experience is not required

What You Can Expect at Wilton Re

• Meaningful project-based work
• Community service opportunities
• Networking with senior leaders
• Working with an assigned mentor
• Competitive pay
• Professional development sessions

Location

Norwalk, CT

Hybrid - 3 days In Office and 2 days Work from Home

Base salary/hourly rate range for this position in Connecticut is between $20.00 and $30.00 an hour. Please note that specific compensation decisions are based upon a variety of job-related factors as permitted by law, including geographic location, credentials, skills, education, training, and experience.

Equal Opportunity

Wilton Re strives to attract, develop, and retain a diverse workforce.

We are committed to providing an inclusive and accessible work environment where all associates feel valued, respected, and supported.

Our commitment to inclusivity is reflected in the safeguards, policies and commitments we have in place to remove barriers and provide equal opportunities to prospective and current associates, without discrimination.

A Human Resources representative is available to consult with applicants who require accommodation in the application or recruitment process. Any information shared by the applicant about an accommodation will be treated as confidential.