2024 Insurance, Fall Reporting Operations Analyst (4 Months)

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 DAI team members in understanding and for risk mitigation

What will you do?

• 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

What do you need to succeed?

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 tobe eligible for these student positions, you must either:

• Bereturning backto 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

Whats in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual. At RBC, you will have opportunities to:

• Interact with leaders who support your development through coaching and managing
• Network and build lasting relationships with students from diverse backgrounds from across Canada
• Make a difference and lasting impact through meaningful work
• Work in a dynamic, collaborative, progressive, and high-performing team

Communication, Computer Literacy, Critical Thinking, Customer Experience (CX), Detail-Oriented, Insurance Industry, Interpersonal Relationships, Listening Effectively, Microsoft Excel, Personal Development, Problem Solving, Process Improvements, Structured Query Language (SQL), Tableau Desktop, Taking Initiative, Team Collaboration, Written Communication

Additional Job Details

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGAMISSISSAUGACanada37.5Full timeINSURANCEStudent/Coop (Fixed Term)Salaried2024-06-282024-07-12

Inclusion and Equal Opportunity Employment