Job Summary

Job Description

What is the opportunity?

The Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurate. As an Associate, you will be responsible for data quality control implementation, centralized exception handling and data quality issue management. This is a unique opportunity to assist the execution of key components of our first line data strategy. You will be called on to find solutions to complicated data issues and will face off directly with members of various regulatory operations teams, stakeholders from Capital Markets desks, and stakeholders within Business and Client Services (BCS).

As a member of a dynamic, fast paced team, this role requires strong data analysis skills, effective written and verbal communication skills, a strong work ethic, and a demonstrated capability to multi-task effectively. This role requires strong interpersonal, organizational and problem-solving skills as well as a demonstrated sense of urgency to respond to changing priorities at times.

What will you do?

Monitor data quality controls and investigate data exceptions.  Trend exceptions in order to identify the root cause of issues, and to develop solutions to address problems.  Reduce exception volumes over time.Work with various stakeholder teams to understand how data is being used and to identify the data issues and gaps they encounter.  Map out 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. Develop new data quality rules and controls, and work with implementation teams to ensure that controls align to business needs.  Support the refinement of controls as requirements evolve.Prioritize issues and data quality exceptions through measuring their material impact on business and regulatory processes.  Escalate critical issues as needed.Produce metrics and reporting to demonstrate the effectiveness of controls and process amendments.Build and maintain strong relationships with business users at both senior and junior levels.Ensure that new process and control solutions address immediate business needs, while ensuring system alignment with global technology strategy and application roadmaps.Conduct data analysis in support of applications and projects, including identifying and documenting business rules, data needs and data specifications.

What do you need to succeed?

Must-have:

Strong communication skills, to capture requirements and answer questions from stakeholders.Excellent data analysis skills, including strong experience with SQL and Python to generate custom queries and analysis, and leveraging Excel to link disparate data sets and trend data.Post-secondary education in Finance, Economics, Computer Science, Data Science, Statistics, Engineering, Math or a related field or 5+ years of experience in the financial services industry.

Nice to Have:

Experience with various Capital Market products and trading products lifecycle.Experience writing executable Data Quality rules and/or working with a portfolio of production Data Quality controls across multiple source applications and stakeholders.Strong understanding of data lifecycles, including focus on data governance and knowledge of Data Quality classification.Experience working with Python and leveraging python for the analysis of disparate data sets.Knowledge of IBM Information Analyzer/Stewardship Centre, metadata management, and/or Collibra to build and manage Data Quality rules and reporting.Experience with data science methodologies, including machine learning and advanced pattern recognition.Knowledge of global markets business processes and/or experience working with Market/Reference data.

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.

Interaction with a wide variety of departments within Capital MarketsThe opportunity to work on projects relating to bank wide data initiatives.Work collaboratively with business partners, IT and Data Management in order to deliver new capabilities effectively.Stay close to industry best practices in account, client data and KYC management.Apply interpersonal and influencing skills to develop strong relationships with the Data Management team, Data Management IT, stakeholders across RBC CM, and individuals participating in the various data project streams.Communicate effectively with RBC CM professionals at varying levels of seniority, including applying insight to determine the business impact of data issues that may arise in the availability, integrity or completeness of data which can be supported through better governance.

Job Skills

Accountability, Business Data Analysis, Business Needs, Communication, Critical Thinking, Data Administration, Data Analysis, Database Structures, Data Governance, Data Management, Data Mining, Data Modeling, Data Quality, Data Quality Control, Data Solutions, Data Strategies, Detail-Oriented, Information Security Management, Interpersonal Communication, Oral Communications, Prioritization, Problem Solving, Professional Ethics, Quality Management, Quantitative Research

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:

2025-01-30

Application Deadline:

2025-02-13

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

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.