Logo of Huzzle

2024 Insurance, Fall Reporting Operations Analyst (4 Months)



18d ago

Applications are closed

  • Internship
    Off-cycle Internship
  • Data
  • Mississauga


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


  • 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 are the main responsibilities of a Fall Reporting Operations Analyst in the insurance industry?

The main responsibilities of a Fall Reporting Operations Analyst in the insurance industry include assessing support requests, making adjustments and enhancements to existing reporting, maintaining business-as-usual reports, resolving problems with existing reports and data, collaborating with stakeholders and team members, streamlining processes, creating documentation, and facilitating report decommissioning.

Ideas Happen Here.

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.