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.

Working Hours: US Hours > 9PM-6AM MYT

What will you do?

Deliver timely, actionable client analytics that drive Capital Markets business decisions. You'll support key business processes by developing and maintaining KPI dashboards that track client engagement, revenue concentration, and market performance. You'll translate complex data into executive-ready insights, preparing client briefs that equip senior leadership ahead of critical meetings. You'll also play a key role in advancing RBC's client analytics capabilities by identifying and executing data initiatives that enhance our client profitability measurement and revenue attribution models.

What do you need to succeed?

Must-have:

• 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
• Experience with Python frameworks and libraries (e.g., Pandas)
• Proficient understanding of code versioning tools (e.g., Git)
• Experience with Alteryx (data cleansing, data aggregation)
• Experience with AI tools and willingness to adopt emerging analytics technologies
• Experience with Capital Markets businesses and products
• Familiarity with benchmarking data and competitive analytics
• 3+ years of analytics or reporting experience

​​​​​​​What’s 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
• Work in a dynamic, collaborative, progressive, and high-performing team
• Ability to make a difference and lasting impact

Job Skills

Adaptability, Critical Thinking, Customer Service, Detail-Oriented, Financial Engineering, Financial Statement Analysis, Investments Analysis, Personal Development, Personal Initiative, Teamwork

Additional Job Details

PERSIARAN IRC 2, IOI RESORT CITY IOI CITY TOWER ONE:PUTRAJAYAPutrajayaMalaysia40Full timeCAPITAL MARKETSRegularSalaried2026-01-232026-02-27

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.

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.