Associate, Reconciliation Data Services

**Job Summary**

The Data Services group within Capital Markets is responsible for ensuring data is fit for purpose and accurate. As an Associate in the reconciliation space, you will be responsible for reconciliation data quality control implementation and issue management. This is a unique opportunity to assist the execution of key components of our first line reconciliation 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 brings 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.
- Investigate incoming reconciliation requests from end users. Holistically review reconciliations to identify opportunities for consolidation and scalable future-ready requirements.
- Work with various stakeholder teams to understand how each reconciliation is being used to support the refinement of controls and remediation of data issues. Translate business needs into key elements to be implemented into solution design.
- Analyze data elements for strategic sourcing opportunities. Continually seek out ways to optimize the use of data in the most efficient way possible.
- Develop requirements based on standard reconciliation models. Assess models on an ongoing basis for potential improvements that reduce future requests or intervention.
- Build and maintain strong relationships with business users and IT partners at both senior and junior levels

**Must-have**
- Strong communication skills, to capture requirements and answer questions from stakeholders.
- Excellent data analysis skills, including strong experience with SQL 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, Engineering, Math or a related field or 5+ years of experience in the financial services industry.

**Nice to Have**:

- Knowledge of different reconciliation types, such as cash, position, trade, and data reference
- Experience using intelliMatch, Xceptor, or other reconciliation platforms
- Knowledge of global markets business processes and/or experience working with Market/Reference data.
- Strong understanding of data lifecycles, including focus on data governance
- Experience with data science methodologies, including machine learning and advanced pattern recognition.

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

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

**Application Deadline**:
2024-12-10

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