Rbc
Capital Markets
DataAnalyst
Neural analysis suggests this role is
optimal for Entry candidates.
“Data Analyst at Rbc. Skills: Data analysis, SQL, Data quality checks, Root cause analysis, Data profiling. Perform hands-on data analysis, profiling, and validation across multiple source systems and platforms. Execute data quality checks against defined rules, thresholds, and business expectations”
What You'll Achieve.
Ensuring that client and counterparty data is accurate, complete, and fit-for-purpose across regulatory, risk, and business use cases; Delivering value to our business teams through our active work and influence
Industry & Context.
Analytically sharp; Investigate data issues; Perform root cause analysis; Comfort working with messy, incomplete, or inconsistent data and applying structured approaches to make sense of it; Critical Thinking; Group Problem Solving
North American shift: 9PM-6AM
What They're Looking For.
Must Have
1-3 years in a Data Analyst, Reporting Analyst, or similar data-focused role, Experience working with large datasets and relational databases, Experience of working in a data management function within an Investment Bank, Proficiency in SQL with the ability to write and troubleshoot queries against large relational databases
Nice to Have
Exposure to a financial service or similarly regulated environment is an asset, Proficiency in Excel including advanced functions, pivot tables, and Power Query familiarity is an asset, Exposure to Python, R, VBA, Tableau, or Power BI is an asset
What You'll Do.
Perform hands-on data analysis
and validation across multiple source systems and platforms
Execute data quality checks against defined rules
and business expectations
Investigate data breaks and exceptions
performing root cause analysis
Document findings clearly and contribute to remediation tracking and resolution workflows
Support Business Analysts in requirements validation by providing data samples
and feasibility assessments
Respond to ad hoc data requests from stakeholders
delivering accurate and timely outputs
Develop domain knowledge in client and counterparty reference data
Build technical skills in SQL
data analysis tooling
Contribute to team process improvements and adopt evolving best practices for analysis and documentation
How You'll Work.
Team & Collaboration
Work closely with Business Analysts, stakeholders, and technology teams; Participate in working sessions with stakeholders and technology teams; Collaborate with senior team members for guidance; Build relationships
Communication Scope
Clear and concise communication skills, both written and verbal; Professional Presentation
Process & Methodology
Manage multiple tasks with competing deadlines, Long Term Planning
Full Job Description
**_Job Description_** **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 dat
Applying for this Data Analyst role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Workday
- Workday has a multi-step form — save your progress after every section.
- "Apply With LinkedIn" can fail or lose data; manual entry is more reliable.
- Watch for the "Submit for Review" final step — hitting "Save" alone does not submit.
- Job requisition numbers are useful when following up with HR by email.
ANONYMOUS · UNFILTERED
What do employees actually say about Rbc?
Real rants from real employees. Read before you apply.