Reconciliation Data Analyst

2 weeks 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 a strong focus on data analysis coupled with effective written and verbal communication skills.

**What will you do?**
- Investigate incoming reconciliation requests and issues from end users
- Work with various stakeholder teams to understand how each reconciliation is being used to support the refinement of controls and remediation of data issues
- Utilize metrics to identify key trends impacting reconciliations and analyze underlying root cause
- Suggest solution design of systemic issues impacting reconciliations and associated data flows
- Report and track issues to closure
- Build and maintain strong relationships with business users and IT partners at both senior and junior levels
- Facilitate stakeholder forums to ensure metrics are reviewed and progress against systemic issues is transparent

**What do you need to succeed?**

**Must-have**
- Strong communication skills
- Strong data analysis skills, including experience with SQL for analysis and leveraging Excel to analyze disparate data sets
- Post-secondary education in Finance, Economics, Computer Science, Engineering, Math or a related field

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

Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements Analysis

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

**Application Deadline**:
2024-04-29

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



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


  • Bedford, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of


  • Bedford, Quebec, Canada Randstad Canada Full time

    Do you have experience in an operations/middle office role? Are you looking to gain experience within a top 5 bank? Do you have strong organizational and time management skills? If so, this is a great opportunity for youOur client, a top 5 bank, is looking for an OTC Dispute and Reconciliation Analyst for a 12 month contract in Bedford. This position is...


  • Bedford, Canada Randstad Canada Full time

    Do you have experience in an operations/middle office role? Are you looking to gain experience within a top 5 bank? Do you have strong organizational and time management skills? If so, this is a great opportunity for you!Our client, a top 5 bank, is looking for an OTC Dispute and Reconciliation Analyst for a 12 month contract in Bedford. This position is...


  • Bedford, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


  • Bedford, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


  • Bedford, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


  • Bedford, Canada Randstad Canada Remote Work Freelance Full time

    Do you have experience in an operations/middle office role? Are you looking to gain experience within a top 5 bank? Do you have strong organizational and time management skills? If so, this is a great opportunity for you!Our client, a top 5 bank, is looking for an OTC Dispute and Reconciliation Analyst for a 12 month contract in Bedford. This position is...


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


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


  • Bedford, NS, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


  • Bedford, NS, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


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


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


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


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


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


  • Bedford, Nova Scotia, Halifax region, Canada Collabera Full time

    What is the opportunity? The Utilities Analyst will be responsible for assisting in resolving margin disputes as a result of exposure differences on OTC uncleared Derivative trades. The incumbent will create daily reconciliation reports and be responsible for monitoring, reporting and escalation of trade and portfolio level exposure differences keeping in...


  • Bedford, NS, 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...


  • Bedford, NS, 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...