Client Intelligence Data & Analytics

RBC; Kuala Lumpur; On-site; MYR 80,000 - 120,000; Full time

Job summary

RBC Capital Markets is seeking a Client Intelligence Data & Analytics professional in Malaysia to deliver accurate client data and analytics for Capital Markets. The role supports sales planning, KPI development, and benchmarking submissions to external vendors.

You will work with senior leadership to brief clients and contribute to evolving RBC’s analytics and profitability metrics across Global Markets, Corporate Banking and Investment Banking.

Qualifications

• At least 2 years of work experience in reporting, analytics and/or data visualization.
• Strong attention to detail; ability to query, organize and structure large data sets.
• Proficiency in BI tools, specifically Tableau.
• Strong Excel skills (pivot tables, formulas, charts/graphs).
• Strong SQL skills; experience with large databases.
• Experience with Python frameworks and libraries (e.g. Pandas).
• Knowledge of relational databases and code versioning tools (Git).
• Strong written & verbal communication and collaborative mindset.
• Bachelor’s degree or higher.

Responsibilities

• Provide accurate and timely client data and analytics to the Capital Markets businesses.
• Support the annual sales and client planning process; develop KPIs to track performance.
• Be responsible for client benchmarking data submissions to external vendors.
• Provide senior leadership client briefs ahead of meetings.
• Support evolution of RBC’s client analytics and profitability metrics.

Skills

Tableau

SQL

Python (Pandas)

Excel

Relational databases

Data visualization

Data analysis

Git

Education

Bachelor's degree

Tools

Alteryx

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.

Job Description

Client Intelligence Data & Analytics

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 : 8.00 PM -5.00AM (North America Time Zone)

What will you do?

• Provide accurate and timely client data and analytics to the Capital Markets businesses
• Support the annual sales & client planning process; develop KPIs to track business performance
• Be responsible for client benchmarking data submissions to external competitor benchmarking vendors
• Provide senior leadership client briefs ahead of client meetings
• Support the evolution of RBC’s client analytics by working on data initiatives the improve client revenue data and enhance client profitability metrics

What do you need to succeed?

Must-have:

• Passion for data and analytics; at least 2 years of work experience in reporting, analytics and/or data visualization
• Strong attention to detail and demonstrated ability to query, organize and structure large amounts of data
• Proficiency in BI tools, specifically Tableau
• Strong proficiency in Excel (pivot tables, formulas, charts & graphs)
• Strong proficiency with SQL (optimizing large complicated SQL statements) and its variation among popular databases
• Experienced with Python frameworks and libraries (e.g. Pandas)
• Knowledge of best practices when dealing with relational databases
• Proficient understanding of code versioning tools (e.g. Git)
• Positive attitude and collaborative work approach
• Ability to work in fast‑paced environment; be agile and flexible to support business needs
• Strong written & verbal communication skills
• Self‑starter, ability to progress and deliver initiatives with little direction / oversight
• Ambition & drive; doesn’t settle for status quo and looks for ways to improve and thinks outside the box
• Bachelor’s degree or higher

Nice to have:

• Passion for data and analytics; at least 2 years of work experience in reporting, analytics and/or data visualization
• Experience with AI tools
• Experience working with Alteryx (data cleansing, data aggregation, etc.)
• Strong attention to detail and demonstrated ability to query, organize and structure large amounts of data

Job Skills

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

Additional Job Details

Address

PERSIARAN IRC 2, IOI RESORT CITY IOI CITY TOWER ONE:PUTRAJAYA

City

Putrajaya

Country

Malaysia

Work hours/week

40

Employment Type

Full time

Platform

CAPITAL MARKETS

Job Type

Regular

Pay Type

Salaried

Posted Date

2026-08-17

Application Deadline

2026-09-30

Note

Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.