Data Analyst, Client Data Services

What is the opportunity?

The Client and Account Data Solutions Group (CADS) is responsible for driving the overall data strategy and data management goals for RBC CM.  The team is accountable for ensuring that the organization is aware of our data intent, that all of our solutions are aligned to our intent and that we are consistently delivering value to our business teams through our active work and influence.  The Client & Account Enablement team is accountable for the implementation and maintenance of the reference data that is used in our operational processes, accountable for maturing our data governance controls as well as participating actively in business and regulatory initiatives that have a significant data impact.

The Data Analyst supports the CDR and broader Client Data team by performing hands-on data analysis, profiling, and validation across multiple source systems and platforms. This role is central to ensuring that client and counterparty data is accurate, complete, and fit-for-purpose across regulatory, risk, and business use cases. This is a hands-on, execution-focused role well suited for someone early in their career who is analytically sharp, curious about data, and eager to develop expertise in a complex capital markets environment. You will work closely with Business Analysts, stakeholders, and technology teams to investigate data issues, support onboarding and migration initiatives, and contribute to the team's delivery commitments.

**North American shift: 9PM-6AM**

What will you do?

•       Data Quality & Issue Resolution

Execute data quality checks against defined rules, thresholds, and business expectations. Investigate data breaks and exceptions, performing root cause analysis with guidance from senior team members. Document findings clearly and contribute to remediation tracking and resolution workflows.

•      Collaboration & Support

Support Business Analysts in requirements validation by providing data samples, profiling results, and feasibility assessments. Participate in working sessions with stakeholders and technology teams, contributing data-level insights. Respond to ad hoc data requests from stakeholders, delivering accurate and timely outputs.

•     Learning & Development

Develop domain knowledge in client and counterparty reference data, including data models, source systems, and regulatory context. Build technical skills in SQL, data analysis tooling, and visualization. Contribute to team process improvements and adopt evolving best practices for analysis and documentation.

What do you need to succeed?

Must have

Experience

• 1-3 years in a Data Analyst, Reporting Analyst, or similar data-focused role.
• Experience working with large datasets and relational databases.
• Exposure to a financial service or similarly regulated environment is an asset.
• Experience of working in a data management function within an Investment Bank

Technical Skills

• Proficiency in SQL with the ability to write and troubleshoot queries against large relational databases.
• Proficiency in Excel including advanced functions, pivot tables, and lookups; Power Query familiarity is an asset.
• Exposure to Python, R, VBA, Tableau, or Power BI is an asset. (nice to have)
• Comfort working with messy, incomplete, or inconsistent data and applying structured approaches to make sense of it.

Communication & Working Style

• Strong attention to detail and a commitment to accuracy
• Clear and concise communication skills, both written and verbal
• Organized and able to manage multiple tasks with competing deadlines.
• Proactive in flagging issues and asking questions rather than making assumptions.
• Curious, self-motivated, and receptive to feedback.
• Ability to network and build strong relationships

What’s in it for you?

• Our Client thrive on the challenge to be their best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. Our Client care about each other, reaching their potential, making a difference to their communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including performance based bonuses, flexible benefits, and competitive compensation.

• Leaders who support your development through coaching and managing opportunities.

• A world-class training program in financial services.

• A collaborative dynamic culture where personal initiative and hard work are recognized and rewarded.

Job Skills

Business Analytics, Commercial Acumen, Critical Thinking, Customer Analytics, Detail-Oriented, Group Problem Solving, Long Term Planning, Professional Presentation

Additional Job Details

PERSIARAN IRC 2, IOI RESORT CITY IOI CITY TOWER ONE:PUTRAJAYAPutrajayaMalaysia40Full timeCAPITAL MARKETSRegularSalaried2026-05-152026-06-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.

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.