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?
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.
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