You must have strong Tableau and Excel skills, data manipulation abilities, communication proficiency, attention to detail, and ideally basic programming knowledge or insurance industry experience. Working towards a degree focused on critical thinking and data analysis is preferred.

You will analyze and enhance reports, address data issues, collaborate with stakeholders, and streamline processes at RBC's Insurance Reporting Operations for 4 months.

Data

Canada

Mississauga

Large

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.

Finance

Banking

Job Summary:<ul><li>Responsible for the support and maintenance of existing production reporting within the Data, Analytics &amp; 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</li><li>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.</li><li>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</li></ul>Job Description:What will you do?<ul><li>Assesses incoming support requests and gather &amp; recommend requirements for reporting changes</li><li>Accesses data from many sources and adjust or make small-to-medium enhancements to existing reporting then re-publishes dashboards</li><li>Maintains business-as-usual reports</li><li>Investigates and resolves problems with existing reports and underlying data</li><li>Collaborates with stakeholders, data engineers, intake partners, report developers and analysts to support reporting requests</li><li>Coordinates the communication and coordination of fixing reporting outages</li><li>Reconciles and addresses ESS (eligible subsequent sales) requests</li><li>Recommends and pursues process streamlining opportunities and changes to data tables and workbooks</li><li>Builds a breadth of business knowledge across many areas including products, distribution channels and functional areas</li><li>Follows established team standard operating procedures (e.g. quality control measures)</li><li>Creates process and user documentation</li><li>Conducts report consolidation</li><li>Able to identify for the intake team (and others) as to whether an existing report will fulfill an end users needs. &nbsp;i.e. have a strong working knowledge of our existing library of reports</li><li>Facilitate report decommissioning</li></ul>What do you need to succeed?Must-have:<ul><li>Strong knowledge of Tableau Desktop and MS Excel</li><li>Basic data table manipulation skills (e.g. running queries, creating joins &amp; unions)</li><li>Strong written and oral communication skills</li><li>High attention to detail</li></ul>Nice-to-have:<ul><li>Basic programming skills</li><li>Insurance industry experience</li><li>Working towards an undergraduate degree that develops capability in critical thinking, data and reporting</li></ul>Please note:&nbsp;In order to&nbsp;be eligible for these student positions, you must either:&nbsp;<ul><li>Be&nbsp;returning back&nbsp;to school after the work term end-date; or&nbsp;</li><li>If you are not returning back to school (i.e.&nbsp;are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully</li></ul>What’s in it for you?<ul><li>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:</li><li>Interact with leaders who support your development through coaching and managing</li><li>Network and build lasting relationships with students from diverse backgrounds from across Canada</li><li>Make a difference and lasting impact through meaningful work</li><li>Work in a dynamic, collaborative, progressive, and high-performing team</li></ul>Job Skills:<ul><li>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</li></ul>

Job Summary: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 enhancementsAble 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 mitigationJob Description:What will you do?Assesses incoming support requests and gather & recommend requirements for reporting changesAccesses data from many sources and adjust or make small-to-medium enhancements to existing reporting then re-publishes dashboardsMaintains business-as-usual reportsInvestigates and resolves problems with existing reports and underlying dataCollaborates with stakeholders, data engineers, intake partners, report developers and analysts to support reporting requestsCoordinates the communication and coordination of fixing reporting outagesReconciles and addresses ESS (eligible subsequent sales) requestsRecommends and pursues process streamlining opportunities and changes to data tables and workbooksBuilds a breadth of business knowledge across many areas including products, distribution channels and functional areasFollows established team standard operating procedures (e.g. quality control measures)Creates process and user documentationConducts report consolidationAble 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 reportsFacilitate report decommissioningWhat do you need to succeed?Must-have:Strong knowledge of Tableau Desktop and MS ExcelBasic data table manipulation skills (e.g. running queries, creating joins & unions)Strong written and oral communication skillsHigh attention to detailNice-to-have:Basic programming skillsInsurance industry experienceWorking towards an undergraduate degree that develops capability in critical thinking, data and reportingPlease 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 successfullyWhat’s 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 managingNetwork and build lasting relationships with students from diverse backgrounds from across CanadaMake a difference and lasting impact through meaningful workWork in a dynamic, collaborative, progressive, and high-performing teamJob Skills: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

2024 Insurance, Fall Reporting Operations Analyst (4 Months)

Requirements

Responsibilities

FAQs

What are the main responsibilities of a Fall Reporting Operations Analyst in the insurance industry?

RBC

Mission & Purpose