Data Quality Analyst

Found in: beBee S CA - 3 weeks ago

BEDFORD, Canada Royal Bank of Canada Full time

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:

2024-04-05

Application Deadline:

2024-04-19

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 jobs.rbc.com.

  • Data Quality Analyst

    Found in: Whatjobs CA C2 - 3 days ago

    Bedford, Canada Procom Full time

    Data Quality Analyst - Data Strategy/Quality Controls On behalf of our client in the Banking Sector, PROCOM is looking for a Data Quality Analyst - Data Strategy/Quality Controls. Data Quality Analyst - Data Strategy/Quality Controls - Job DescriptionAs a member of Data Services, you will play a role in supporting the bank's Capital Markets' first line data...

  • Data Quality Analyst

    Found in: beBee S CA - 2 days ago

    Bedford, Canada Procom Full time

    Data Quality Analyst - Data Strategy/Quality Controls On behalf of our client in the Banking Sector, PROCOM is looking for a Data Quality Analyst - Data Strategy/Quality Controls. Data Quality Analyst - Data Strategy/Quality Controls - Job DescriptionAs a member of Data Services, you will play a role in supporting the bank's Capital Markets' first line data...

  • Data Quality Analyst

    12 hours ago

    Bedford, Canada Infotek Consulting Inc. Full time

    We are looking for a Data Quality Analyst for a 5 months contract with high possibility of extension. Role is hybrid in Bedford, NS.The Data Services group is responsible for ensuring data is fit for purpose and accurate. As an Analyst, you will be responsible for data quality control implementation, centralized exception handling and data quality issue...

  • Data Quality Analyst

    Found in: Appcast CA C2 Glassdoor - 1 day ago

    Bedford, Canada Infotek Consulting Inc. Full time

    We are looking for a Data Quality Analyst for a 5 months contract with high possibility of extension. Role is hybrid in Bedford, NS.The Data Services group is responsible for ensuring data is fit for purpose and accurate. As an Analyst, you will be responsible for data quality control implementation, centralized exception handling and data quality issue...

  • Data Quality Analyst

    Found in: Whatjobs CA C2 - 1 day ago

    Bedford, Canada Infotek Consulting Inc. Full time

    We are looking for a Data Quality Analyst for a 5 months contract with high possibility of extension. Role is hybrid in Bedford, NS. The Data Services group is responsible for ensuring data is fit for purpose and accurate. As an Analyst, you will be responsible for data quality control implementation, centralized exception handling and data quality issue...

  • Data Quality Analyst

    Found in: Appcast CA A2 P - 4 hours ago

    Bedford, Canada Infotek Consulting Inc. Full time

    We are looking for a Data Quality Analyst for a 5 months contract with high possibility of extension. Role is hybrid in Bedford, NS.The Data Services group is responsible for ensuring data is fit for purpose and accurate. As an Analyst, you will be responsible for data quality control implementation, centralized exception handling and data quality issue...

  • Data Quality Analyst

    Found in: Whatjobs CA C2 - 3 days ago

    Bedford, Canada Procom Full time

    Data Quality Analyst - MS Excel/SQL On behalf of our client in the Banking Sector, PROCOM is looking for a Data Quality Analyst - MS Excel/SQL. Data Quality Analyst - MS Excel/SQL - Job DescriptionThe Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurateAs an Analyst, you will be responsible for data...

  • Data Quality Analyst

    Found in: beBee S CA - 2 days ago

    Bedford, Canada Procom Full time

    Data Quality Analyst - MS Excel/SQL On behalf of our client in the Banking Sector, PROCOM is looking for a Data Quality Analyst - MS Excel/SQL. Data Quality Analyst - MS Excel/SQL - Job DescriptionThe Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurateAs an Analyst, you will be responsible for data...

  • Data Quality Analyst

    Found in: Appcast CA C2 Glassdoor - 1 day ago

    Bedford, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality control...

  • Data Quality Analyst

    Found in: Whatjobs CA C2 - 1 day ago

    Bedford, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality...

  • Data Quality Analyst

    Found in: Appcast CA A2 P - 3 days ago

    Bedford, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality control...

  • Data Quality Analyst

    1 day ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Data profilingDQ Rule designUATProgram MeetingsLiaise with technology teamsTroubleshoot issuesPartner with Regulatory data consumers• Understand data flows and transformations that are relevant to data usage. Perform analysis to find the cause of issues and facilitate the remediation of these issues.• Responsible for large scale...

  • Data Quality Analyst

    1 day ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Data profilingDQ Rule designUATProgram MeetingsLiaise with technology teamsTroubleshoot issuesPartner with Regulatory data consumers• Understand data flows and transformations that are relevant to data usage. Perform analysis to find the cause of issues and facilitate the remediation of these issues.• Responsible for large scale...

  • Data Quality Analyst

    Found in: Appcast CA C2 Glassdoor - 1 day ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Data profilingDQ Rule designUATProgram MeetingsLiaise with technology teamsTroubleshoot issuesPartner with Regulatory data consumers• Understand data flows and transformations that are relevant to data usage. Perform analysis to find the cause of issues and facilitate the remediation of these issues.• Responsible for large scale...

  • Data Quality Analyst

    Found in: Whatjobs CA C2 - 1 day ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities: Data profiling DQ Rule design UAT Program Meetings Liaise with technology teams Troubleshoot issues Partner with Regulatory data consumers • Understand data flows and transformations that are relevant to data usage. Perform analysis to find the cause of issues and facilitate the remediation of these issues. • Responsible for...

  • Data Quality Analyst

    Found in: Appcast CA A2 P - 3 days ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Data profilingDQ Rule designUATProgram MeetingsLiaise with technology teamsTroubleshoot issuesPartner with Regulatory data consumers• Understand data flows and transformations that are relevant to data usage. Perform analysis to find the cause of issues and facilitate the remediation of these issues.• Responsible for large scale...

  • Data Quality Analyst

    Found in: beBee jobs CA - 2 weeks ago

    Bedford, Quebec, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat 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...

  • Data Quality Analyst

    Found in: Jooble CA C2 - 2 days ago

    Bedford, NS, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality control...

  • Data Quality Analyst

    Found in: Jooble CA O C2 - 3 days ago

    Bedford, NS, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality control...

  • Data Quality Analyst

    1 day ago

    Halifax Bedford Basin, Canada Collabera Full time

    What is the Opportunity? As a member of Data Services, you will play a role in supporting RBC Capital Markets’ first line data solutions and delivery. This is a unique opportunity to assist the execution of key components of our first line data strategy including: centralized exception handling, data quality issue management, and data quality control...