Data Analyst – Client Intelligence
Description
The RBC Capital Markets Client Intelligence team plays a crucial role in supporting the firm's strategic client initiatives. This involves ensuring accurate client revenue reporting and leveraging both internal (revenue, resource utilization, CRM interactions) and external data (competitor benchmarking, client scorecards) to provide analytical business insights. The role focuses on identifying and resolving data quality issues, performing in-depth data analysis to extract meaningful insights, ensuring that all datasets meet rigorous quality standards, and managing the cleaning and preparation of datasets to maintain accuracy and consistency across Capital Markets businesses. The goal is to empower the business with informed decisions on clients and support the formulation of sales and client strategies.
What We're Looking For
Identify and remediate data quality issues across client datasets, systematizing how problems are discovered, documented, and resolved.,Analyze cleaned datasets to extract meaningful insights and generate actionable analytics that inform client decisions and business strategy.,Ensure that every dataset meets quality standards, with remediation work directly enabling reliable analytical outputs.,Manage the cleaning and preparation of datasets to ensure accuracy and consistency across Capital Markets businesses.,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.
Ideal Candidate
Bachelor's degree or higher.,SQL proficiency including query optimization, complex joins, subqueries, and performance tuning across multiple database platforms (Nice-to-Have).,Practical Python experience for data analysis and wrangling with ability to write clean, maintainable code (Nice-to-Have).,Python experience for statistical analysis or machine learning (Nice-to-Have).,Exposure to enterprise data warehouse environments (Nice-to-Have).,Background in client data management or master data management (MDM) systems (Nice-to-Have).,Experience with Tableau (Nice-to-Have).
Minimum Education
Bachelor's Degree
Hard Skills
Soft Skills
Work Hours
40 hours/week
Benefits
About the Company
Royal Bank of Canada
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.
We respect your privacy
BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.