Summer 2027 Intern: Data Support Analyst

Assurant, Inc.; Illinois; On-site; USD 28,000 - 40,000; Full time

Benefits offered by this job

Mentorship

Networking opportunities

Job summary

Assurant, Inc. invites applicants to join its 12-week Data Support Internship in the Chicago area. The role emphasizes production analysis, data extraction, and system enhancements to improve efficiency and compliance.

Interns collaborate on testing, documentation, and training while gaining real-world experience in a Fortune 500 company. The program offers mentorship, networking, and development opportunities, with a focus on building foundational technical and business skills for students

Qualifications

• Currently pursuing a bachelor’s degree in a related field.
• Experience extracting and analyzing data from multiple sources.
• Familiar with SQL, Excel, and Power BI for data analysis.

Responsibilities

• Support production applications and monitor data and processes.
• Analyze data, generate reports, and deliver metrics to stakeholders.
• Assist in requirements definition, testing, and documentation.
• Contribute to training and user documentation.

Skills

Data analysis

Communication

Problem solving

Attention to detail

Education

Bachelor’s degree in Risk/Insurance, Finance, Business Administration, Mathematics, Data Analytics, Economics, or related field

Tools

SQL Server

Power BI

Excel

Job description

The Assurant Internship Program is a 12-week immersive experience where interns do not sit on the sidelines. You will gain real-world experience by tackling business challenges and helping drive meaningful outcomes. The program combines hands-on work with learning and development opportunities, mentorship, networking and engagement opportunities, and resources designed to support your professional growth. This program offers students meaningful, real-world experience while building foundational technical and business skills in a Fortune 500 organization.

The Data Support interns primary role is to support the department’s systems and staff by recommending and implementing system enhancements that promote efficiency, compliance, and growth. The position requires a well-rounded individual that supports operations staff and systems by maintaining and monitoring production applications, processes, and data. Regularly analyzing, maintaining, and supporting system files, tables, and configurations used to drive the base functionality of corporate applications. Contributes to support activities and project assignments of low to medium risk and complexity. This includes activities such as requirement definition, research, analysis, coordination, testing, training, and documentation.

PRODUCTION ANALYSIS AND SUPPORT:

• Provides general support for various business applications, databases, and integrations.
• Analyze systems, processes, and data issues of low to medium complexity and provide options to for remediation to more experienced team members.
  • Enter low to medium complex routine user-maintained table changes and configurations.
  • Troubleshoot low complexity system issues with limited direction.
• Ability to identify priority issues and determine which issues can be handled within the authority of an analyst and being able to discern those issues requiring direction from a higher authority.
• Contributes to training efforts by writing documentation and manuals, preparing presentations, delivering training, and providing follow-up.

DATA ANALYSIS:

• Ability to extract data from a variety of internal and external data sources.
• Support both scheduled and ad hoc report requests.
• Analyze data to deliver reporting and metrics to clients and internal stakeholders.
• Document new and existing data sources, processes, tables, and fields.
• Validate the integrity of the data shown in reports by performing regular data analysis.

REQUIREMENTS DEFINITION:

• Participate in analysis and definition of business and functional requirements, including client sessions and interviews.
• Analyze requirements for new projects and processes.
• Acts as the business and technical liaison during analysis, requirements definition, and design activities.

TESTING, DEBUGGING, TEST MANAGEMENT, QUALITY ASSURANCE:

• Participates in definition of testing scope and scenarios, and estimates of effort, and duration on low to medium scale projects based on the business requirements.
• Prepares test plans and scripts for low to medium scale projects.
  • Research, document, report, and communicate any defects with functionality, flow and/or program changes.
• Performs user acceptance testing and deliver results for peer, team, and management review.

PROJECT MANAGEMENT:

• Display knowledge of project management principles and apply Company approved methodology.
• Prioritize and coordinate activities of project team members for low impact projects.
• Participate as a project team member for low to medium complex projects.
• Identify project issues and communicate progress and obstacles to sponsors and/or management.
• Handles multiple tasks and small projects, concurrently.
• Participate in cost/benefit analysis.

IMPLEMENTATION:

• Coordinate production implementation efforts with User community and IT for low to medium complex support activities and project assignments.
• Communicate implementation timelines and tasks.
• Develop the User Documentation and Training material.
• Train the trainers and/or impacted associates.
• Post-implementation audits/reviews.

PROFESSIONAL DEVELOPMENT, RELATIONSHIP BUILDING, AND COMMUNICATIONS:

• Apply new knowledge rapidly.
• Continuously seek opportunities for professional development.
• Demonstrate quality, attentiveness, and attention to detail in all work activities.
• Build relationships with internal and external customers and business partners.
• Ability to manage stakeholder expectations using effective verbal and written communication skills.

Basic Qualifications

• Currently pursuing a bachelor’s degree in Risk/Insurance, Finance, Business Administration, Mathematics, Data Analytics, Economics, or a related field.
• Requires experience extracting and analyzing data from a variety of sources such as Excel, delimited files, fixed width files, APIs, and SQL Server databases.
• Requires skills of extracting and analyzing data using a variety of methods including SQL, Excel, and Power BI.

Other Requirements

• Requires ability to continuously learn a variety of applications and skills.
• Requires ability to process time sensitive data, make decisions and communicate actions.
• Requires good organization, self-motivation skills, and manage multiple assignments and priorities.
• Requires ability to communicate effectively both verbally and in writing to management, team members, business, and technology professionals.
• Requires ability to adapt to a variety of project team roles, such as analyst, tester, documentation writer, or trainer.

Remote: Chicago Area

Paid Internship: $25/hour

Start Date: 5/17/2027
End Date: 8/7/2027

Note: You must be work authorized in the United States on a full-time basis without the need for employer sponsorship now or in the future. The Company cannot offer employment to F-1 (student) visa holders who require employer sponsorship in the future or cannot work now on a full time basis.