Internship Opportunity


Data Analyst

Number of Positions:
Application Deadline:
Oct 11, 2019
Start Date:
Oct 21, 2019
End Date:
Oct 16, 2020

Job Description:

**Please follow the instructions after submitting an application to Career Edge portal. You will receive an email with a link to RBC Career Website to submit an application again in order to be considered for this role.  

Please keep your name consistent on both application tracking systems. Thank you



  • As a member of the Capital Markets HR Team, supports the achievement of business objectives and people priorities through the development, production and assessment of ad hoc and regularly scheduled reports for the Global team (including regional reporting requirements). 
  • Acts as subject matter expert for SAP, and people analytics system. 
  • Ensures organizational hierarchies for CM reflect current structures.



  • Develops customized ad hoc and standard/scheduled reports and data extracts in support of CM HR people priorities and business requirements using SAP, and HR reporting & analytic tools
  • Assesses and determines information report requirements and metrics in consultation with HR Business Partners and/or Initiatives Managers, recommends report solutions and analyzes findings/results.
  • Proactively assesses ongoing report requirements and makes / implements recommendations to streamline, enhance, and automate processes and reports for improved efficiency and effectiveness.
  • Works collaboratively with HR partners across the platform (including CM HR, HR Service Centre and the Centres of Expertise).
  • Manages BUFUGU organizational structure change requirements in SAP in partnership with the HR Technology team to ensure CM organizational hierarchies are current and allow for accurate reporting and data access
  • Manages CM HR team’s access requirements to HR systems and acts as subject matter expert relative to SAP, SuccessFactors, HR reporting and analytic tools.
  • Provides the Global HR team with bi-weekly hires, terms and employee listings for global Capital Markets
  • Responsible for refreshing existing routine CM HR reports, including: OC MD reports and Capital Markets people report.
  • Responsible for data management within SAP including reporting structure changes, creation of SAP cost centers, and maintenance of HR Class data
  • Conduct audits of data input through SAP/HRIS to ensure data integrity is maintained and HRIS information provided to managers is accurate
  • Partner with HR Business Partners and COEs and provide reporting recommendations that support the Capital Markets businesses
  • Assists in the development and implementation of CM HR initiatives (including but not limited to Talent Management, Performance Management and Year-end Processes including Employee Communications and Promotions)
  • Contribute to the effectiveness of the HR function and its processes, deliverables, metrics, and benchmarking




  • Initiatives and reports vary in scope and complexity and may impact a broad group of employees and managers across all groups within CM globally
  • Manage multiple tasks simultaneously



  • Reports to Senior Director, Initiatives – CM HR
  • HR Business Partners
  • Initiatives team members in own and other platforms/functions
  • HR Professional Centres; HR Services; HR Technology




Behavioural Competencies:

  • Achievement motivation
  • Attention to detail
  • Information seeking
  • Teamwork and cooperation
  • Adaptability
  • Demonstrated outstanding planning, organizational and execution skills


Technical / Systems Knowledge:

  • Advanced MS Excel skills including pivot tables, vlookups, index/match, and VBA macros
  • Experience with programming languages and visualization tools, such as Python, Alteryx and Tableau would be good to have
  • Strong story-telling, analytical and problem-solving skills
  • Comfortable with extracting and manipulating data, with the ability to synthesize meaningful insights from disparate sources of data
  • Time Management with ability to work under pressure and with limited timelines
  • Knowledge of SAP, SuccessFactors & HR reporting and analytic tools
  • Business knowledge of CM businesses



  • Comfortable physical premises in a professional office environment
  • Working environment reflects respectful and collaborative relationships amongst immediate team
  • Moderate stress due to timelines for project-based work




  • Report Development / Production           40%
  • Data Management / Maintenance           40%
  • Initiatives Support                                  20%



About RBC
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 84,000+ employees who 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 more than 16 million clients in Canada, the U.S. and 34 other countries. Learn more at

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at

Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at

Inclusion and Equal Opportunity Employment
RBC is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans status, Aboriginal/Native American status or any other legally-protected factors. Disability-related accommodations during the application process are available upon request.

Employer Question 1:

Are you legally eligible to work in Canada for the entire duration of this internship?

Employer Question 2:

Do you require any accommodations for the interviewing and recruitment process?

Employer Question 3:

No question - Applicants, please type N/A in the text box below when submitting your application.