London-based Senior Data Analyst: Pricing & Reference Data

RBC; Greater London; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Bonuses

Flexible benefits

World-class training program

Job summary

RBC is seeking a data-focused analyst to ensure accurate pricing and reference data across core systems in a London-based role. You will manage data integrity, execute daily pricing, and collaborate with Trading, IT, Risk, and Fund Accounting to support NAV and client reporting.

The role requires strong Excel skills and Python knowledge, with experience in asset management data environments and an interest in generative AI solutions.

Qualifications

• Demonstrable experience in a Data Analyst role, preferably within Asset Management.
• Data literacy, advanced skills in Excel.
• Python knowledge (Intermediate).
• Demonstrable usage of generative AI.
• Strong communication skills.

Responsibilities

• Maintain security, fund, broker, benchmark, and reference data in key systems (IVP Security Master, Simcorp Dimension, Charles River, and Wall Street Office).
• Execute daily pricing of bonds, derivatives, equities, loans, and manage exceptions within IVP Price Master and verify values using market data platforms (Bloomberg, Pricing Direct, ICE Data Services, Refinitiv, and S&P).
• Investigate and resolve pricing and reference data issues.
• Identify new control gaps and recommend mitigation measures.
• Analyze large data sets using Excel, VBA, SQL, Python.
• Collaborate with internal teams on new initiatives, ensuring correct data flow and translations.
• Maintain stakeholder relationships (Investment Desks, IT, Risk, Fund Accounting, Performance & Attribution).
• Engage with system upgrade projects and monitor for data or process change impacts.
• Provide weekly updates to senior management.

Skills

Data analyst experience

Advanced Excel

Python

Generative AI

Communication skills

Education

Degree in STEM or Finance

Tools

IVP Security Master

Simcorp Dimension

Charles River

Wall Street Office

Bloomberg

Pricing Direct

ICE Data Services

Refinitiv

S&P

Job description

RBC is seeking a data-focused analyst to ensure accurate pricing and reference data across core systems in a London-based role. You will manage data integrity, execute daily pricing, and collaborate with Trading, IT, Risk, and Fund Accounting to support NAV and client reporting.

The role requires strong Excel skills and Python knowledge, with experience in asset management data environments and an interest in generative AI solutions.