Reporting & Analytics Analyst – Client Intelligence
Description
The RBC Capital Markets Client Intelligence team supports the firm's strategic client initiatives by ensuring accurate client revenue reporting and leveraging internal and external data for analytical business insights. This data empowers the business to make informed client decisions and formulate sales and client strategies. The role involves contributing to a collaborative, creative, and innovative team focused on delivering best-in-class business analytics, data visualizations, and client strategy recommendations.
What We're Looking For
Deliver timely, actionable client analytics that drive Capital Markets business decisions.,Support key business processes by developing and maintaining KPI dashboards that track client engagement, revenue concentration, and market performance.,Translate complex data into executive-ready insights, preparing client briefs that equip senior leadership ahead of critical meetings.,Play a key role in advancing RBC's client analytics capabilities by identifying and executing data initiatives that enhance client profitability measurement and revenue attribution models.
Ideal Candidate
Passion for data and analytics with at least 2 years of work experience in reporting, analytics, and/or data visualization.,Strong attention to detail and demonstrated ability to query, organize, structure, and aggregate large amounts of data.,Understanding and experience navigating data hierarchies (e.g., product, client).,Proficiency in BI tools, specifically Tableau.,Strong proficiency in Excel (pivot tables, formulas, charts, and graphs).,Solid proficiency with SQL across popular databases.,Ability to translate business questions into analytical solutions and scope undefined data problems.,Experience presenting findings and recommendations to non-technical stakeholders.,Positive attitude and collaborative work approach; comfort working cross-functionally.,Ability to thrive in a fast-paced environment; agile and flexible in supporting evolving business needs.,Strong written and verbal communication skills.,Self-starter with ability to progress initiatives with minimal oversight.,Drive to improve processes and think beyond status quo.,Bachelor's degree or higher.,Nice to have: Advanced SQL proficiency, including optimization of complex queries.,Nice to have: Experience with Python frameworks and libraries (e.g., Pandas).,Nice to have: Proficient understanding of code versioning tools (e.g., Git).,Nice to have: Experience with Alteryx (data cleansing, data aggregation).,Nice to have: Experience with AI tools and willingness to adopt emerging analytics technologies.,Nice to have: Experience with Capital Markets businesses and products.,Nice to have: Familiarity with benchmarking data and competitive analytics.,Nice to have: 3+ years of analytics or reporting experience.
Minimum Education
Bachelor's Degree
Hard Skills
Soft Skills
Work Hours
40 hours/week, US Hours (9 PM - 6 AM MYT)
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.