Data Analyst (RBC CM Halifax)

Job Description

What is the opportunity?

Do you strive to seek out efficiencies in processes? Do you enjoy working collaboratively with various departments and business partners to achieve a common goal? As the Senior Book Data Analyst will play a key role in developing and executing upon the data management strategy and goals for RBC Capital Markets. As part of an evolving and maturing data management function, the Book Data Management team is accountable for the implementation and maintenance of the reference data used in our operational processes, supporting our data governance and quality controls, as well as participating actively in business and regulatory initiatives that have a significant data impact.

What will you do?

• Support the global management of Book reference data for Capital Markets
• Ensure data content is fit for purpose and meets the data quality requirements of business consumers
• Provide robust data analysis, reporting, and subject matter expertise that supports daily operations and enterprise initiatives
• Interface with internal business groups and external vendors as they relate to Book data management
• Manage and support Book Data Management daily operational processes
• Support project initiatives as a team lead for the Client Data Management team
• Create, mature, and automate operational processes to reduce processing time, reduce manual effort and improve data quality
• Capture, measure, and report metrics on the dimensions of data quality that support business defined objectives
• Demonstrate strong initiative to produce insightful analysis of business issues and suggest potential solutions/options based on analysis

What do you need to succeed?

Must-have

• Completion of an applicable university degree and/or relevant professional designation is required
• Solid understanding of data management practices
• 2+ years of data management experience in a similar role within the investment industry
• Intermediate Excel Skills
• Analyze data sets using pivot tables and VLOOKUP
• Ability to write and create formulas, functions and macros
• Ability to structure and format data for reporting using conditional formatting, tables and charting
• Intermediate SQL skills
  • Understanding and usage of SQL keywords, data types, logical and comparison operators, joins (inner, left, right) and indexes
  • Understanding and usage of update and insertion statements, and syntax for altering and creating structures
  • Understanding and usage of temp tables
  • Understands SQL concepts of foreign keys, transactions, and constraints

What’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.

• Interaction with a wide variety of departments within Capital Markets
• The opportunity to work on projects relating to bank wide data initiatives
• Gain extensive knowledge of systems and end to end process flows across all assets classes.
• Coach and mentor junior members of the team
• Act as a team ambassador and represent the Book Data Management team with internal and external partners and clients

RBC is committed to supporting flexible work arrangements when and where available. Details to be discussed with Hiring Manager.

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 jobs.rbc.com.
JOB SUMMARY
City: Toronto
Address: 155 Wellington Street West
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Full Time
Career Level: Experienced Hire/Professional
Application Deadline: 12/10/2021
Platform: Capital Markets
Req ID: 428537
Ad Code(s):