Summer Intern - Claims

Reinsurance Group of America, Incorporated; Chesterfield (MO); On-site; USD 25,000 - 39,000; Full time

Job summary

Reinsurance Group of America, Incorporated is seeking a data analytics intern to gain base knowledge of the reinsurance lifecycle and help create weekly/monthly reports. You will work with Excel and SQL, support data quality initiatives, and collaborate with Claims & OSC to perform moderately complex analyses.

The role emphasizes data analytics, reporting, and cross-functional teamwork across US Operations.

Qualifications

• Current student pursuing a degree in Data Analytics or General Business
• Ability to summarize and develop reports from large data sets using Excel and SQL
• Willingness to learn by participating in meetings and asking questions
• Advanced Excel skills preferred
• Strong analytical and critical thinking skills to gather information and draw conclusions
• Excellent interpersonal, written, and verbal communication skills

Responsibilities

• Analyze moderately complex claim data for reporting and compliance
• Collaborate with multiple departments to identify needs and analyze solutions
• Prepare reports to monitor production and quality results, including SQL-based reporting
• Participate in internal audits and client claim audits as needed
• Monitor data for accurate accruals under supervision
• Support cross-functional teams to improve processes and documentation
• Complete assigned projects according to instructions

Skills

Analytical thinking

Communication skills

Excel skills

Education

Data Analytics

General Business

Tools

SQL

Excel

Job description

You desire impactful work.

You’re RGA ready

RGA is a purpose-driven organization working to solve today’s challenges through innovation and collaboration. A Fortune 200 Company and listed among its World's Most Admired Companies, we’re the only global reinsurance company to focus primarily on life- and health-related solutions. Join our multinational team of intelligent, motivated, and collaborative people, and help us make financial protection accessible to all.

The intern will begin by getting a base knowledge of the reinsurance world and understanding the life cycle of a policy from the day the policy is issued through the day the policy ends. In addition, throughout the program, they will aid with creating weekly/monthly metric reporting, data quality initiatives, and exposure to Microsoft Excel and SQL Queries. There will be a heavy focus on data analytics and reporting. Under limited supervision, collaborates with the Claims & OSC to provide technical expertise and perform moderately complex analysis for reinsurance and retro claims. Works independently, with claim management, and with various departments across the organization and US Operations, to identify and resolve complex reinsurance claim issues. Collaborates with key resources for procedural process improvements and documentation.

Responsibilities:

• Essential Function Analyzes moderately complex claim data for compliance with treaty terms and systemic reporting


• Works with all departments in the USMM Operations division and other RGA departments to identify needs and analyze possible solutions using technical experience and established procedures.


• Contributes to the maintenance of claims standards, procedures and Prepares reports that allow management to monitor claims production and quality results against stated This may include creating and running SQLs to assist in reporting.


• Participates in internal claim-related audits and other audits (i.e. client claim audits) as needed.


• Under supervision, monitors system data for accurate claim accruals.


• Ability to meticulously oversee substantial amounts of data while being able to stay detail oriented.


• Ability to work cross functionally to support the team by collaborating with both Claim Examiners and OSC Processors


• Projects assigned with completion according to instructions

Requirements :

• Current student pursuing degree in Data Analytics, General Business or related degree


• Ability to summarize and develop reports from large data sets using both excel and SQL


• Willingness and desire to learn and ask questions by participating in meetings and voicing new ideas.


• Basic knowledge of Microsoft Office Applications (Advanced Excel Skills preferred)


• Effective analytical and critical thinking skills to gather information, analyze facts, and draw conclusions


• Strong interpersonal, written, and verbal communication skills

Candidates must be authorized to work ongoing in the United States without current or future employer-sponsored work authorization.

What you can expect from RGA:

• Gain valuable knowledge from and experience with diverse, caring colleagues around the world.


• Enjoy a respectful, welcoming environment that fosters individuality and encourages pioneering thought.


• Join the bright and creative minds of RGA, and experience vast, endless career potential.