Summer 2027 Intern: Data Support Analyst

Assurant•Illinois Virtual, IL

2d•Remote

About The Position

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.

Requirements

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.
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.
Must be work authorized in the United States on a full-time basis without the need for employer sponsorship now or in the future.
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.

Responsibilities

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