Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support the creation and maintenance of financial data, ensuring accuracy and quality.
- Company: Join RBC, a leading global bank committed to innovation and community impact.
- Benefits: Enjoy flexible work options, competitive pay, bonuses, and world-class training.
- Why this job: Be part of a dynamic team making a real difference in finance and communities.
- Qualifications: Data literacy, Excel skills, Python experience, and strong communication are essential.
- Other info: Work in London with opportunities for professional growth and development.
The predicted salary is between 36000 - 60000 £ per year.
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 through 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 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
- Degree in STEM or Finance topic
- Basic SQL
- Experience working with a security mastering system.
What is 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. 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.
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.
Data Analyst - Pricing and Reference Data employer: RBC
Contact Detail:
RBC Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Pricing and Reference Data
✨Tip Number 1
Familiarise yourself with the specific systems mentioned in the job description, such as IVP Security Master and Simcorp Dimension. Having a solid understanding of these platforms will not only boost your confidence during interviews but also demonstrate your proactive approach to learning.
✨Tip Number 2
Brush up on your data analysis skills, particularly in Excel, Python, and SQL. Consider working on personal projects or online courses that allow you to showcase your ability to analyse large datasets, as this is a key requirement for the role.
✨Tip Number 3
Network with professionals in the financial sector, especially those who work in data analysis roles. Engaging with them can provide insights into the industry and may even lead to referrals, which can significantly enhance your chances of landing the job.
✨Tip Number 4
Prepare to discuss your experience with generative AI and how it can be applied in data analysis. This is a unique skill that can set you apart from other candidates, so think of examples where you've used AI tools to improve data quality or efficiency.
We think you need these skills to ace Data Analyst - Pricing and Reference Data
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analysis, particularly in financial institutions. Emphasise your skills in Excel, Python, and any experience with security mastering systems.
Craft a Strong Cover Letter: In your cover letter, explain why you are interested in the Data Analyst position and how your background aligns with the job requirements. Mention specific examples of how you've improved data quality or resolved issues in previous roles.
Showcase Technical Skills: Clearly outline your technical skills in your application. Include your proficiency in SQL, VBA, and any experience with generative AI, as these are key for the role.
Highlight Communication Abilities: Since strong communication skills are essential for this role, provide examples of how you've effectively collaborated with internal teams or stakeholders in past positions. This will demonstrate your ability to engage with various departments.
How to prepare for a job interview at RBC
✨Showcase Your Data Skills
Make sure to highlight your proficiency in Excel, Python, and any experience with SQL during the interview. Be prepared to discuss specific projects where you've used these skills to analyse data or improve processes.
✨Understand the Financial Context
Since this role is within a financial institution, it's crucial to demonstrate your understanding of pricing and reference data. Familiarise yourself with terms like bonds, derivatives, and equities, and be ready to discuss how you would handle data quality issues.
✨Communicate Effectively
Strong communication skills are a must-have for this position. Practice articulating your thoughts clearly and concisely, especially when discussing complex data issues or collaborating with internal teams.
✨Prepare for Scenario Questions
Expect scenario-based questions that assess your problem-solving abilities. Think of examples from your past experiences where you resolved data discrepancies or improved data processes, and be ready to explain your thought process.
