Senior Data Analyst - Pricing and Reference Data

Royal Bank of Canada London, United Kingdom

Job Description

What is the opportunity?

You will be supporting the creation and maintenance of security, fund, broker, benchmark, and other reference data in systems such as IVP Security Master, Simcorp Dimension, Charles River, and Wall Street Office. Working to improve data quality though implementation of process improvements. Supporting the daily pricing of bonds, derivatives, equities, loans and managing exceptions within IVP Price Master and verifying values using Bloomberg, Pricing Direct, ICE Data Services, Refinitiv, and S&P.

This position is full time and will require you to work a minimum of 4 days in the office per week with the option to work one day from home.

What will you do?

• Actively resolving any pricing and reference data issues raised and investigating to identify the cause.
• Help identify new control points and demonstrating awareness of potential operational risk.
• Analysis of large data sets in MS Excel, VBA, SQL, Python
• Engaging internal teams to ensure new initiatives are implemented and that data flow and translations are correct.
• Helping to maintain the relationships between with internal stakeholders such as the Investment Desks, IT, Risk, Fund Accounting, and the Performance team.
• Taking full ownership demonstrating full awareness of any system upgrades and enhancements, and any potential regulatory breaches.
• Ensuring that the systems provide timely, accurate and complete information to staff and clients.
• Contributing towards weekly updates for senior management.
• Proactive delivery of projects using own initiative.

What do you need to succeed?

Must-have

• Data literacy, skilled in Excel
• Experience of working at a financial institution
• Strong communication skills
• Python
• Demonstratable usage of generative AI

Nice-to-have

• Degree in STEM or Finance topic
• Basic SQL
• Experience working with a security mastering system.

What is in it for you?

• A comprehensive Total Rewards Program including bonuses, flexible benefits and competitive compensation
• Leaders who support your development through coaching and managing opportunities
• Opportunities to work with the best in the field
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial services.

RBC strives to deliver an inclusive workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally. We believe a workplace based on respect, belonging and opportunity for all helps to bring our Purpose to life and create value for our clients and communities.