Job Summary

Support the Capital Markets client franchise by providing accurate client reporting. Support various client data initiatives such as resource utilization and competitor benchmarking to deliver business insights empowering the business to make more informed decisions on its clients and supports its formulation of sales and client strategies

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.

What will you do?

Provide accurate and timely client data and analytics to the Capital Markets businessesSupport the annual sales & client planning process; develive KPIs to track business performanceBe responsible for client benchmarking data submissions to external competitor benchmarking vendorsProvide senior leadership client briefs ahead of client meetingsSupport 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?

Passion for data and analytics; at least 2 years of work experience in reporting, analytics and/or data visualizationStrong attention to detail and demonstrated ability to query, organize and structure large amounts of dataProficiency in BI tools, preferably TableauStrong proficiency in Excel (pivot tables, formulas, charts & graphs)Strong proficiency with SQL (optimizing large complicated SQL statements) and its variation among popular databasesExperienced with Python frameworks and libraries (e.g. Pandas)Knowledge of best practices when dealing with relational databasesProficient understanding of code versioning tools (e.g. Git)Positive attitude and collaborative work approachAbility to work in fast-paced environment; be agile and flexible to support business needsStrong written & verbal communication skillsSelf-starter, ability to progress and deliver initiatives with little direction / oversightAmbition & drive; doesn’t settle for status quo and looks for ways to improve and thinks outside the boxBachelor’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 businessesExperience with client provided ranking and feedback such as scorecards and broker votesAbility to effectively communicate to senior management in a concise mannerStrong PowerPoint skills; ability to synthesize large amounts of information to key takeaways and themes

​​​​​​​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 mutualWork in a dynamic, collaborative, progressive, and high-performing teamAbility 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:

WEALTH MANAGEMENT

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2024-11-05

Application Deadline:

2025-01-22

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 embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
​​​​​​​
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

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.