Skip to content

RBC

Data Analyst – Client Intelligence

RBC is hiring a Data Analyst – Client Intelligence. Level rates it ; you can apply on RBC.

Level's read on this job

  • Little AI ●○○○ is how Level rates this data analyst role: aI is not part of the work.
  • The posting mentions Salesforce, data analysis and data cleansing among its tools and skills.
  • Level classes it as a mid-level role.
  • RBC has 807 other open roles on Level.

AI in this role

Data Analyst responsible for client hierarchy data integrity, revenue reporting, and analytical business insights at RBC Capital Markets.

Salesforce
data-analysisdata-cleansingdata-governanceclient-intelligencereporting

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.

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.

Working Hours : 8.00PM -5.00AM (North America Time Zone)

What will you do?

Ensure client hierarchy data integrity by identifying and remediating issues that impact revenue reporting. Leverage CRM platforms such as Salesforce to manage client records, account hierarchies, and entity mappings. Analyze and cleanse datasets to produce actionable insights that inform client strategy and business decisions. Establish and maintain data quality controls and process governance frameworks to ensure consistency and accountability across remediation workflows.

What do you need to succeed?

Must-Have:

  • Minimum 2 years of professional experience in client data management, trade reconciliations, reporting, or business systems analysis
  • Strong understanding of client hierarchies and their application in financial systems
  • Demonstrable experience working within CRM platforms such as Salesforce, specifically in managing client records, account hierarchies, and entity mappings
  • Strong analytical skills with the ability to leverage cleaned datasets to produce actionable insights that inform client strategy and business decisions
  • Experience establishing and maintaining data quality controls, process governance frameworks, and standard operating procedures to ensure consistency and accountability across remediation workflows
  • Collaborative mindset with ability to work in fast-paced, agile environments
  • Ambitious and driven; committed to continuous improvement and innovation
  • Passion for data with strong attention to detail with proven ability to identify data inconsistencies and drive to remediate issues
  • Strong written and verbal communication skills; ability to translate technical concepts for business audiences
  • Strong critical thinking and investigative skills; ability to trace root causes, challenge assumptions, and solve complex data problems with rigor and curiosity
  • Hands-on experience with data analysis, cleansing, aggregation, workflow automation
  • Advanced Excel skills including pivot tables, formulas, charting, and data manipulation
  • Data modelling experience including logical and physical models that represent hierarchical relationships and translate business requirements into data structures
  • Bachelor's degree or higher

Nice-to-Have:

  • Familiarity with data governance frameworks or metadata management tools
  • Awareness of corporate actions and their impact on client hierarchies
  • SQL proficiency including query optimization, complex joins, subqueries, and performance tuning across multiple database platforms
  • Practical experience with Python for data analysis and wrangling; ability to write clean, maintainable code
  • Knowledge of relational databases and data governance best practices
  • Exposure to enterprise data warehouse environments
  • Experience working with data architects
  • Background in client data management or master data management (MDM) systems

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:

    2026-08-17

    Application Deadline:

    2026-11-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.

    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.

    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.

    How we rate this

    Data Analyst – Client Intelligence at RBC rates 0 out of 100 for how much of the daily work is AI. That makes it Little AI (AI Level 1 of 4). The level is about AI in the job, not seniority.

    Classification

    Little AI. AI is not part of the work.

    1. ●●●● Builds AI80 to 100
    2. ●●●○ Works on AI60 to 79
    3. ●●○○ Uses AI40 to 59
    4. ●○○○ Little AI0 to 39

    Levels come from how often the tools, models and workflows of the role are named in the posting itself. Read the description and count the AI tools, models and workflows it names.

    Prepare for this job

    Built from this posting and from similar jobs on Level.

    Skills and AI tools this role asks for

    Data AnalysisData CleansingData GovernanceClient IntelligenceReportingSalesforce

    Also common in data analyst jobs at this level

    Pay

    Typical data analyst job
    $112k

    This posting doesn't list pay. Use the typical data analyst figure when pay comes up. See data analyst jobs

    Questions you could be asked

    1. Tell me about a project where data analysis was part of your work. What did you do?
    2. Tell me about a project where data cleansing was part of your work. What did you do?
    3. Tell me about a project where data governance was part of your work. What did you do?
    4. Tell me about a project where client intelligence was part of your work. What did you do?
    5. Tell me about a project where reporting was part of your work. What did you do?

    Adapt your resume

    • List these exact terms on your resume: Data Analysis, Data Cleansing, Data Governance, Client Intelligence, and Reporting. An applicant tracking system matches the wording, not the idea.
    • Attach one line of real, concrete experience to at least one of them. A tool named with nothing behind it rarely survives a human read.

    Get your CV reviewed before you apply

    Send your CV and the role you want next. Your review arrives by email within 3 days.

    Get new data analyst jobs by email

    One email a week, each job rated for how much AI is in the work. No recruiter spam, unsubscribe in one click.

    Free.

    Similar roles

    Data roles that involve little AI, at other companies.

    What kind of AI work fits you?

    Answer 12 practical questions in about three minutes. Get a simple profile, the work it points to, and live roles to explore next.

    Find my next step

    More jobs at RBC

    More data analyst jobs

    Related searches

    Same AI level