What is the opportunity?

The Client Data Services team (CDS) is responsible for ensuring the accuracy and completeness of the static reference data for Capital Markets clients, counterparties, and other entities of interest.  This data includes names, addresses, identifiers, classifications, hierarchies, and other attributes that are required for business and operational processes, regulatory monitoring and reporting, revenue reporting and client analytics, and Risk and Finance purposes.  CDS maintains this information in the Client Data Repository (CDR) system, which acts as a central repository for master client records that are linked to accounts in trading and settlement systems, eliminating the operational overhead of needing multiple teams manage this information across multiple systems, ensuring consistency of this information across all consuming areas, and enabling the aggregation of client activity across different lines of business.

As a Senior Analyst, you will be responsible for ensuring the accuracy and completeness of the data in CDR by leveraging advanced analytics techniques, and for providing insight into CDR client data through reporting and analytics.

What will you do?

Support complex data query requests to provide insight into the coverage and nature of client reference data

Be responsible for large scale multi-way comparisons of CDR data against various internal and external sources to identify trends and to measure overall data quality

Develop and implement reporting and data visualization dashboards to articulate trends and data quality measurements

Develop monitoring to proactively identify data quality gaps

Assess data requirements of new consumers and project initiatives to determine where CDR’s data is fit for purpose, and where gaps exist

Support the root cause analysis of data issues relating to client data, and perform complex remediation requiring advanced pattern recognition and machine learning

Identify and coordinate system and process enhancements and improvements

What you need to succeed?

Completion of an applicable university degree and/or relevant professional designation.

A minimum of two years of experience in Python, R and or other programming languages.

Advanced Excel Skills

Analyze large data sets using pivot tables and pivot reporting

Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit

Build macros using VBA (Visual Basic for Applications)

Ability to structure and present data for reporting using conditional formatting, tables and charting

Intermediate SQL skills

Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions

Understanding and usage of update and insertion statements and syntax for altering and creating structures

Can generate complex data reports using GROUP BY and aggregate functions

Understands SQL concepts of foreign keys, transactions, triggers, and stored procedures

Excellent communication skills – written and oral

Strong troubleshooting and problem solving skills

Nice-to-have

Degree in Computer Science

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.

A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation

Leaders who support your development through coaching and managing opportunities  

Work in a dynamic, collaborative, progressive, and high-performing team 

Opportunities to do challenging work

Flexible work/life balance options

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.