Client Intelligence Data Analyst

RBC; Putrajaya; On-site; USD 30,000 - 50,000; Full time

Job summary

A leading firm seeks a Client Intelligence Data Analyst to join their Capital Markets division in Putrajaya. The role focuses on managing client data and analytical reporting to support business decisions, requiring strong data proficiency and communication skills. This position offers growth in a collaborative environment, emphasizing innovation and teamwork.

Benefits

Opportunities for professional development

Dynamic and collaborative work environment

Ability to make a lasting impact

Qualifications

• At least 2 years of work experience in operations, data management, and/or reporting.
• Strong written & verbal communication skills.
• Proficiency in BI tools, preferably Tableau.

Responsibilities

• Use SQL, Python, and Tableau to pull and analyze client data.
• Develop and maintain reports, dashboards, and visualizations.
• Ensure data quality and integrity across various reporting.

Skills

Adaptability

Critical Thinking

Customer Service

Detail-Oriented

Financial Engineering

Financial Statement Analysis

Investments Analysis

Personal Development

Personal Initiative

Teamwork

Education

Bachelor's degree or higher

Tools

Tableau

SQL

Python

Excel

Job description

Job Summary

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 data & reporting across revenues, balance sheet, capital, CRM and competitor benchmarking data. This data is leveraged to deliver actionable insights that empower 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 intelligence.

Job Description

Client Intelligence Data Analyst

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 data & reporting across revenues, balance sheet, capital, CRM and competitor benchmarking data. This data is leveraged to deliver actionable insights that empower 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 intelligence.

What will you do?

• Use SQL, Python and Tableau to pull data from various sources to provide accurate and timely client data and analytics to stakeholders
• Use Tableau & Excel to develop and maintain reports, dashboards and other data visualizations
• Responsible for various daily, weekly, monthly reports to stakeholders
• Ensure data quality and integrity, run various control reports and processes to address data errors
• Develop and maintain client feedback database and other client databases
• Responsible for facilitating the timely upload of manual client revenues to database
• Collaborate with IT and Operations to address technical and operational issues impacting data quality
• Investigate and address client hierarchy inconsistencies
• Perform ad-hoc analysis and data clean up as needed
• Provide client briefs to senior leadership and stakeholders as required

What do you need to succeed?

Must-have:

• Passion for data and analytics; at least 2 years of work experience in operations, data management and/or reporting
• 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
• Ambition & drive; doesn’t settle for status quo and looks for ways to improve and thinks outside the box
• Strong attention to detail and demonstrated ability to query, organize and structure large amounts of data
• Proficiency in BI tools, preferably Tableau
• Strong proficiency in Excel (pivot tables, formulas, charts & graphs)
• Bachelor’s degree or higher

Nice to have:

• Capital Markets experience, knowledge of Global Markets products (Fixed Income, FX, Commodities, Futures and Equities) or Corporate & Investment Banking businesses
• Experience with client provided ranking and feedback such as scorecards and broker votes
• Ability to effectively communicate to senior management in a concise manner
• Strong PowerPoint skills; ability to synthesize large amounts of information to key takeaways and themes
• Proficient understanding of code versioning tools (e.g. Git)
• Proficiency with SQL (optimizing large complicated SQL statements) and its variation among popular databases
• Experienced with Python frameworks and libraries (e.g. Pandas)

• Experience working with Alteryx (data cleansing, data aggregation)

Working Hours: 8AM – 5PM EST or 8PM – 5AM Kuala Lumpur Time (+/- 1-2hrs)

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

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:

2025-05-07

Application Deadline:

2025-07-31

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.