Data Quality Analyst

2 weeks ago

Bedford, Canada Royal Bank of Canada Full time

**Job Summary**

**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

**I**nclusion** 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.

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

  • Data Quality Analyst

    1 week ago

    Bedford, Quebec, 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

    1 week ago

    Bedford, Quebec, 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...

  • Business Data Analyst

    6 days ago

    Bedford, Canada Nova Scotia College of Nursing (NSCN) Full time

    **Business Data Analyst** **Full-time, 35 Hours/Week** **Nova Scotia College of Nursing** **About NSCN** The Nova Scotia College of Nursing (NSCN) is the safeguard that ensures the public that all nurses in Nova Scotia have the education and skills they need to care for people safely, competently, ethically, and compassionately. The public trusts us to...

  • Reconciliation Data Analyst

    6 days ago

    Bedford, Canada Royal Bank of Canada Full time

    **Job Summary** **What is the opportunity?** The Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurate. As an Analyst in the reconciliation space, you will be responsible for reconciliation data quality control implementation and issue management. You will be a member of a dynamic, fast paced team, with...

  • Reconciliation Data Analyst

    3 weeks ago

    Bedford, Quebec, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat is the opportunity?The Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurate. As an Analyst in the reconciliation space, you will be responsible for reconciliation data quality control implementation and issue management. You will be a member of a dynamic, fast paced team,...

  • Data Analyst

    6 days ago

    Bedford, Canada Royal Bank of Canada Full time

    **Job Summary** **What is the opportunity?** Reporting to the VP of Account Management North America, this position plays a key role in developing and executing upon the Client Management Group’s overall strategy and goals within Capital Markets. Supporting our data governance and quality controls, as well as actively participating in business and...

  • Business Analyst, Group Benefit Solutions

    1 week ago

    Bedford, Canada igility Health Association Nova Scotia Full time

    Health Association Nova Scotia is a not-for-profit, non-government, membership-based association with 60 years’ experience in providing exceptional human resource shared services, innovative clinical engineering solutions, policy support and expertise our customers can count on. Serving multiple organizations from across the province of Nova Scotia, our...

  • Financial Analyst

    4 weeks ago

    Bedford, Canada Municipal Group of Companies Full time

    The Municipal Group of Companies, based in Bedford Nova Scotia, is a large, diversified organization engaged in all major aspects of the heavy civil construction, mining, transportation, and environmental services within the Atlantic Provinces. We are currently seeking the expertise of a Financial Analyst based out of Halifax Regional Municipality,...

  • Risk & Control Analyst

    7 days ago

    Bedford, Canada Royal Bank of Canada Full time

    **Come Work with Us!** At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work...

  • Risk & Control Analyst

    4 days ago

    Bedford, Canada Royal Bank of Canada Full time

    **Come Work with Us!** At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work...

  • Systems Business Analyst

    7 days ago

    Bedford, Quebec, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the opportunity ?Join the Reconciliations Technology team in Capital Markets as we continuously deliver new capabilities to modernize operational business processes by delivering enterprise grade solutions. We are seeking a talented and adaptable Business Systems Analyst to maintain an existing portfolio of applications and...

  • Business Consultant Associate

    4 days ago

    Bedford, Canada IBM Full time

    **Introduction** At IBM, we know that transformation drives change, and it is in our DNA to continuously transform. Our Business Transformation Consultants help drive large scale change that spans IBM business units and geographies. As a part of this team, you will have the unique opportunity to be a part of driving IBM’s ongoing transformation as a...

  • Business Consultant Associate

    4 weeks ago

    Bedford, Canada IBM Canada Full time

    Introduction At IBM, we know that transformation drives change, and it is in our DNA to continuously transform. Our Business Transformation Consultants help drive large scale change that spans IBM business units and geographies. As a part of this team, you will have the unique opportunity to be a part of driving IBM’s ongoing transformation as a company...

  • OTC Dispute and Reconciliation Analyst

    5 days ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Running trade and collateral data extracts from vendor systems.Running macros to identify breaksAnalysis of breaksCommunication with relevant internal stakeholders to help research breaks.Daily communication with counterparties.Daily monitoring of disputes as neededEscalation as required of open issues/disputes.Daily EOD dispute...

  • OTC Dispute and Reconciliation Analyst

    4 days ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities: Running trade and collateral data extracts from vendor systems. Running macros to identify breaks Analysis of breaks Communication with relevant internal stakeholders to help research breaks. Daily communication with counterparties. Daily monitoring of disputes as needed Escalation as required of open issues/disputes. Daily EOD...

  • OTC Dispute and Reconciliation Analyst

    6 days ago

    Bedford, Canada Finance Professionals Inc. Full time

    Daily Responsibilities:Running trade and collateral data extracts from vendor systems.Running macros to identify breaksAnalysis of breaksCommunication with relevant internal stakeholders to help research breaks.Daily communication with counterparties.Daily monitoring of disputes as neededEscalation as required of open issues/disputes.Daily EOD dispute...

  • Executive Administrative Assistant

    6 days ago

    Bedford, Canada Canadian College of Acupuncture & TCM Full time

    Key Responsibilities: - Manage the Executive's calendar, schedule appointments, and coordinate meetings - Coordinate travel arrangements and prepare itineraries - Conduct research, compile data, and prepare reports as requested - Handle sensitive and confidential information with discretion and professionalism - Manage and update the Directors contacts,...

  • Client Services Project Manager 1

    3 weeks ago

    Bedford, Canada Bureau Veritas Group Full time

    Do you believe in the power of teamwork and sharing ideas? Do you take pride in delivering exceptional quality and service with everything you do? Do you seek out ideas for improving the status quo? If you want to make a difference and love being surrounded by the best and the brightest, Bureau Veritas Laboratories might be the place for you! Imagine...

  • Sponsor Site Specialist

    4 weeks ago

    Bedford, Canada Chalice Full time

    **Job Location**:Bedford, Nova Scotia*** **Job Title**:Sponsor Site Specialist*** **Reports to**:International Department Program Manager*** **Chalice (Canada)** is a** **Catholic, Nova Scotia based organization with a vision for "A world where all children and families live in communities of life and love." Through the generosity of our Canadian...

  • Production Worker

    4 weeks ago

    Bedford, Canada Copia HR - Copia Professional Services Limited Full time

    We are looking for a hardworking, reliable, and enthusiastic production worker who enjoys working in a fast-paced environment, keeps moving, and accomplish his daily tasks. To be successful, you must be able to comprehend and follow directives, have sound attention to details, and be flexible to working in a team. **Responsibilities & Duties**: - Inspect,...