2025 Insurance, Winter Reporting Operations Analyst (4 Months)

RBC

Sep 11

Applications are closed

Internship
Full-time
Placement Program
Data
Business, Operations & Strategy
Mississauga

Requirements

Must-have
Strong knowledge of Tableau Desktop and MS Excel
Basic data table manipulation skills (e.g. running queries, creating joins & unions)
Strong written and oral communication skills
High attention to detail
Nice-to-have
Basic programming skills
Insurance industry experience
Working towards an undergraduate degree that develops capability in critical thinking, data and reporting
Please note:
In order to be eligible for these student positions, you must either:
Be returning back to school after the work term end-date; or
If you are not returning back to school (i.e. are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully

Responsibilities

- Assesses incoming support requests and gather & recommend requirements for reporting changes
- Accesses data from many sources and adjust or make small-to-medium enhancements to existing reporting then re-publishes dashboards
- Maintains business-as-usual reports
- Investigates and resolves problems with existing reports and underlying data
- Collaborates with stakeholders, data engineers, intake partners, report developers and analysts to support reporting requests
- Coordinates the communication and coordination of fixing reporting outages
- Reconciles and addresses ESS (eligible subsequent sales) requests
- Recommends and pursues process streamlining opportunities and changes to data tables and workbooks
- Builds a breadth of business knowledge across many areas including products, distribution channels and functional areas
- Follows established team standard operating procedures (e.g. quality control measures)
- Creates process and user documentation
- Conducts report consolidation
- Able to identify for the intake team (and others) as to whether an existing report will fulfill an end users needs. i.e. have a strong working knowledge of our existing library of reports
- Facilitate report decommissioning

FAQs

What is the duration of the internship for the Insurance, Winter Reporting Operations Analyst position?

The internship is for a duration of 4 months.

What are the main responsibilities of this position?

The main responsibilities include maintaining existing production reporting, managing reporting operation functions, collaborating with various stakeholders, and enhancing processes for efficiency.

What are the required technical skills for this role?

Strong knowledge of Tableau Desktop and MS Excel, along with basic data table manipulation skills such as running queries and creating joins & unions, are required for this role.

Is insurance industry experience necessary for this position?

While insurance industry experience is a nice-to-have, it is not a mandatory requirement.

What type of educational background is preferred for applicants?

Applicants should be working towards an undergraduate degree that develops capabilities in critical thinking, data, and reporting.

What are the work hours for this position?

The work hours are 37.5 hours per week.

Is this position eligible for students who are graduating immediately after the work term?

Yes, students who are graduating must require the full work term as a mandatory component to graduate successfully.

What opportunities for professional development does this position offer?

The position offers opportunities to interact with leaders for coaching, network with diverse students, and make a lasting impact through meaningful work in a dynamic team environment.

Where is the job location?

The job is located at Meadowvale Business Park, 6880 Financial Dr, Mississauga, Canada.

When can applicants expect to apply for the position?

The application deadline is September 30, 2024.

RBC

Ideas Happen Here.

Finance

Industry

10,001+

Employees

1864

Founded Year

Mission & Purpose

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 88,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at rbc.com/community-social-impact.