Job Summary
Job Description
What is the opportunity?
The Client Data Services Team 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.
The US Cash Management Client Onboarding Analyst is responsible for the initial setup and enrichment of records in CDR, ensuring that all of the static reference data on new records is all accurate and complete.
What will you do?
- Managing new client setup tasks, and mapping and updating the appropriate reference data into CDR
- Reconciling client reference data against a variety of external sources, and ensuring that the data being added to CDR is accurate and verifiable
- Reviewing any exception reports for data supplied from internal systems to ensure that CDR is aligned with source systems and that the data is correct
- Supporting project initiatives through creating new client records or implementing new onboarding processes
- SQL queries to perform lookups and to filter data based on criteria
- Performing UAT and PIV testing during CDR release cycles
What you need to succeed?
- Post-secondary education with 1 - 2 years of relevant experience
- Experience with KYC/onboarding processes
- Investigation and research experience able to translate real-world entities and relationships into a data model
- Excellent communication skills written and oral
- Strong troubleshooting and problem solving skills
Nice-to-have
- SQL queries to perform lookups and to filter data based on criteria
- Awareness of trading and settlement processes, and the ways in which client data attributes are used
- Extracting data to present metrics and reports
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
Job Skills
Additional Job Details
Address
City
Country
Work hours/week
Employment Type
Platform
Job Type
Pay Type
Posted Date
Application Deadline
I
and Equal Opportunity Employment
nclusion
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
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