Analyst, Data Services

What is the opportunity?

The Data Services group within Capital Markets is responsible for ensuring data quality and accuracy to support critical business operations. We are looking for an experienced and well-rounded Analyst to join our high-performing Reconciliation Data Services team. As an Analyst in this space, you will be expected to serve as the bridge between technical data analysts and operational stakeholders within downstream teams, enabling data-led decisions and operational efficiencies.

This role requires a candidate who can strike the right balance between technical proficiency, business acumen, and stakeholder management. You will help drive meaningful discussions with stakeholders, turning data-driven metrics into actionable insights, and fostering a collaborative problem-solving environment. If you are passionate about financial markets, data-driven decision-making, and process improvement, this role offers a chance to make a significant impact and contribute to our team's success.

What will you do?

• Monitor and analyze metrics to detect key trends and identify systemic issues, and work to implement strategic plans for resolution
• Facilitate stakeholder forums with upstream and downstream teams to review metrics, address queries, and foster accountability
• Present findings and provide updates in a way that is accessible and meaningful to non-technical stakeholders and drive discussions on remediation plans
• Build and maintain strong relationships with business users and IT partners at both senior and junior levels
• Support team's growth by improving the quality of reporting and deepening the team's understanding of reconciliation operations
• Prepare and maintain clear, well-structured documentation covering processes and action plans, and regularly share updates with team leadership and stakeholders to ensure transparency

What do you need to succeed?

Must-have:

• Excellent communication skills with demonstrated experience presenting data and insights clearly to diverse stakeholders
• Strong knowledge of financial markets and capital markets, particularly with associated operational workflows
• Strong problem-solving ability to identify patterns and trends using metrics and data
• Proficiency in SQL with intermediate skills for data querying and reporting
• Advanced Excel skills, including experience generating pivot tables and formulas
• Post-secondary education in Finance, Economics, Computer Science, Engineering, Math or a related field

Nice-to-have:

• Familiarity with visualization platforms like Tableau
• Knowledge of reconciliation platforms or financial systems
• Knowledge of different reconciliation types, such as cash, position, trade, and data reference
• Understanding of accounting principles and financial reporting
• 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 our 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

Additional Job Details

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 believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.