2025 Insurance, Winter Reporting Operations Analyst (4 Months)

RBC

Sep 12

Applications are closed

Internship
Full-time
Placement Program
Data
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

Responsible for the support and maintenance of existing production reporting within the Data, Analytics & Insights (DAI) team. Will work with a breadth of knowledge across data tables, reports, products, distribution channels and functional areas to perform existing report maintenance, adjustments and small-to-medium enhancements. Able to manage low-to-medium complexity reporting operation functions. Works with data engineers, report developers, analysts, intake partners and internal clients to fulfill requests. Enhances processes for efficiency, makes recommendations on data table changes, report changes and creates process documentation as needed to assist the Data, Analytics and Insight team members in understanding and for risk mitigation.
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 duration is 4 months.

Where is the workplace located for this position?

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

What are the primary responsibilities of this role?

The primary responsibilities include maintaining existing production reporting, making adjustments and small-to-medium enhancements, managing low-to-medium complexity reporting operations, and collaborating with stakeholders to fulfill requests.

What software skills are required for this position?

A strong knowledge of Tableau Desktop and MS Excel is required for this position.

Is insurance industry experience necessary for this role?

Insurance industry experience is considered a nice-to-have but is not mandatory.

What educational qualifications are preferred for applicants?

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

What is the paid type for this position?

The position offers a salaried pay type.

What are the employment type and working hours for this job?

The employment type is full-time, and the working hours are 37.5 hours per week.

When is the application deadline for this job?

The application deadline is September 30, 2024.

Are there opportunities for networking and development in this role?

Yes, there are opportunities to interact with leaders for coaching and to build lasting relationships with students from diverse backgrounds.

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.