Data Quality Analyst - Bedford, Canada - RBC - Royal Bank

Description

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

Critical Thinking, Data Administration, Database Structures, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Information Capture, Standard Operating Procedure (SOP), Teamwork

Additional Job Details

Address:

90 WESTERN PKY:BEDFORD

City:

BEDFORD

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

Capital Markets

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

Inclusion and Equal Opportunity Employment

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.
​​​​​​​
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

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