About this role
Job Description
What is the opportunity?
The RBC Capital Markets Client Intelligence team plays an integral role in support of the firm’s key strategic client initiatives. The Client Intelligence team is part of the Business Resource Management division which supports all global businesses within Capital Markets including Global Markets Sales & Trading, Corporate Banking & Investment Banking.
The CI team is responsible for ensuring accurate client revenue reporting and leverages internal data (revenue, resource utilization, CRM interactions) and external data (competitor benchmarking, client provided scorecards and feedback) to deliver analytical business insights. The data and analytics provided by the CI team empowers the business to make more informed decisions on its clients and supports its formulation of sales and client strategies.
The team offers individuals the opportunity to be part of a collaborative, creative and innovative organization with a collective ambition to deliver best-in-class business analytics, data visualizations and client strategy recommendations.
What will you do?
- Data Remediation: Identify and remediate data quality issues across client datasets, systematizing how problems are discovered, documented, and resolved
- Data Analysis: Analyze cleaned datasets to extract meaningful insights and generate actionable analytics that inform client decisions and business strategy
- Quality Assurance: Ensure that every dataset meets quality standards, with remediation work directly enabling reliable analytical outputs
- Data Wrangling & Preparation: Manage the cleaning and preparation of datasets to ensure accuracy and consistency across Capital Markets businesses.
Must-Have:
- Minimum 2 years of professional experience in data analysis, data cleanup, reporting, or business systems analysis with a demonstrated passion for delivering clean, reliable data
- Hands-on experience identifying, documenting, and remediating data quality issues at scale
- Hands-on experience with data wrangling, cleansing, and validation across client datasets
- Strong critical thinking and investigative skills to trace root causes of data problems and implement lasting solutions
- Hands-on experience with data cleansing, aggregation, workflow automation, and ETL processes
- Advanced Excel skills including pivot tables, formulas, charting, and data manipulation
- Understanding of data lineage and ability to document data flows from source to consumption
- Detail-oriented with exceptional ability to identify inconsistencies and errors
- Strong analytical mindset capable of transforming raw data into actionable insights
- Collaborative mindset with ability to work in fast-paced, agile environments
- Strong written and verbal communication skills to translate technical concepts for business audiences
- Self-starter capable of driving initiatives with minimal oversight
- Bachelor's degree or higher
Nice-to-Have:
- SQL proficiency including query optimization, complex joins, subqueries, and performance tuning across multiple database platforms
- Practical Python experience for data analysis and wrangling with ability to write clean, maintainable code
- Python experience for statistical analysis or machine learning
- Exposure to enterprise data warehouse environments
- Background in client data management or master data management (MDM) systems
- Experience with Tableau
What’s in it for you?
- Work in a dynamic, collaborative, progressive, and high-performing team
- Make a real difference and lasting impact
- Be part of an organization that thrives on the challenge to be our best, progressive thinking, and working together to deliver trusted advice to help clients thrive and communities prosper
Job Skills
Adaptability, Critical Thinking, Customer Service, Detail-Oriented, Financial Engineering, Financial Statement Analysis, Investments Analysis, Personal Development, Personal Initiative, TeamworkAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
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.
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.
RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.
Other facts
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com.
We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
http://rbc.com/legalstuff.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.
https://www.rbc.com/conditions-dutilisation/
What you'll do
- The Data Analyst will identify and remediate data quality issues, analyze cleaned datasets for insights, and ensure quality standards for datasets. They will also manage data preparation to maintain accuracy across Capital Markets businesses.
Ready to join RBC?
Take the next step in your career journey