Associate, Reconciliation Data Services

3 weeks ago


BEDFORD, Canada Royal Bank of Canada Full time

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

What will you do?

  • Investigate incoming reconciliation requests from end users. Holistically review reconciliations to identify opportunities for consolidated root cause analysis and solution development.
  • 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
  • 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 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
  • 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

Analytical Thinking, Communication, Critical Thinking, Data Administration, Database Structures, Data Flows, Data Modeling, Data Movement, Data Quality, 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-03-25

Application Deadline:

2024-04-08

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.



  • Bedford, Quebec, Canada Royal Bank of Canada 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 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...


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


  • BEDFORD, Canada Royal Bank of Canada 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,...


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


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

  • Finance Associate

    7 days ago


    Bedford, Canada igility Health Association Nova Scotia Full time

    Health Association Nova Scotia (HANS) is a not-for-profit, non-government, membership-based association with 60 years experience in delivering shared services for a wide range of health and health-related organizations. Our core services include Clinical Engineering Services, Group Benefits Solutions, and Labour Relations and Compensation Analysis....


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


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


  • Bedford, Canada My East Coast Experience Media Group INC Full time

    Responsibilities: - Perform account reconciliations and analysis to ensure accuracy and completeness of financial data - Assist in the preparation of financial statements and reports - Support the budgeting process by providing financial data and analysis - Conduct bank reconciliations and monitor cash flow - Process payroll and ensure compliance with...

  • Data Scientist

    7 days ago


    Bedford, Canada Translab Technologies Private Limited Full time

    Education: Bachelor's degree - Experience: 7 months to less than 1 year **Tasks**: - Collect and document user's requirements and develop logical and physical specifications - Research, evaluate and synthesize technical information to design, develop and test computer-based systems - Design, construct, modify, implement and test data models and database...

  • Manager - Finance

    5 days ago


    Bedford, Canada igility Full time

    Health Association Nova Scotia is a not-for-profit, non-government, membership-based association with 60 years’ experience in delivering shared services, policy support and expertise our customers can count on. Serving over 130 organizations from across the province of Nova Scotia, our core fee-for-service/cost recovery services are Clinical Engineering...

  • Manager - Finance

    5 days ago


    Bedford, Canada igility Full time

    Health Association Nova Scotia is a not-for-profit, non-government, membership-based association with 60 years’ experience in delivering shared services, policy support and expertise our customers can count on. Serving over 130 organizations from across the province of Nova Scotia, our core fee-for-service/cost recovery services are Clinical Engineering...

  • Manager - Finance

    3 days ago


    Bedford, Canada igility Full time

    Health Association Nova Scotia is a not-for-profit, non-government, membership-based association with 60 years’ experience in delivering shared services, policy support and expertise our customers can count on. Serving over 130 organizations from across the province of Nova Scotia, our core fee-for-service/cost recovery services are Clinical Engineering...


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


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


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


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


  • 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

    23 hours ago


    Bedford, Canada Raise Full time

    Bedford, Nova Scotia, Canada; HybridDuration: 5 month duration What is the Opportunity? As a member of Data Services, you will play a role in supporting 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,...


  • Bedford, Canada Raise Full time

    Bedford, Nova Scotia, Canada; Hybrid Duration: 5 month duration What is the Opportunity? As a member of Data Services, you will play a role in supporting 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...