Summer Intern - Claims

rgare; Chesterfield (MO); On-site; USD 20,000 - 33,000; Full time

Job summary

RGA is seeking a motivated student for a Data Analytics Internship to learn the life-cycle of policies and support reporting across teams. You’ll develop SQL queries, work with Excel, and contribute to weekly and monthly metrics, data quality initiatives, and analytics projects within US Operations.

Under limited supervision, you’ll collaborate with Claims & OSC, gain exposure to cross-functional processes, and help identify improvements while building practical data analysis skills for a

Qualifications

• Currently pursuing a degree in Data Analytics, General Business, or related field.
• Ability to summarize and develop reports from large data sets using Excel and SQL.
• Willingness to learn, participate in meetings, and share new ideas.
• Strong analytical and communication skills.

Responsibilities

• Analyze moderately complex claim data to support reporting and compliance.
• Assist with weekly/monthly metrics reporting and data quality initiatives.
• Collaborate with Claims & OSC to provide technical data analysis.
• Prepare reports for management to monitor claims production and quality.

Skills

Data analytics

Microsoft Excel

SQL queries

Reporting

Education

Current student pursuing degree in Data Analytics or 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.

We're excited to get to know you and connect your unique skills with our global opportunities. To create a modern and seamless experience, we use artificial intelligence (AI) in parts of our preliminary screening process. This technology helps us personalize job recommendations, automate interview scheduling, evaluate candidates based solely on experience-without considering name, gender, or other personal details-and provide real-time answers through our chatbot. AI is used only during early screening and never makes hiring decisions. Your RGA recruiter will work closely with you every step of the way to ensure the process feels personal, thoughtful, and focused on you.