Sql analyst Jobs in Old toronto, ON

What is the opportunity?

• The Business Analyst supports the delivery of data and analysis initiatives across the Counterparty Data Repository and broader Client Data ecosystem. Working closely with the Associate Director and cross-functional stakeholders, this role is responsible for gathering and refining business requirements, performing data analysis, and ensuring that solutions meet business and regulatory expectations.

• This is a hands-on role in a change-driven environment. The ideal candidate is analytically strong, detail-oriented, and comfortable working across business and technology teams to translate requirements into clear, actionable specifications. You will be expected to take ownership of workstreams within larger programs and deliver independently with appropriate oversight.

What will you do?

Key Responsibilities

Requirements Gathering & Analysis

• Elicit, document, and refine business and data requirements from stakeholders across various lines of business.

• Translate business needs into structured specifications including data mappings, transformation logic, and acceptance criteria.

• Challenge and pressure-test requirements to ensure completeness and feasibility before handoff to technology teams.

Documentation & Process

• Maintain clear, structured documentation including business requirements documents, data dictionaries, data flow diagrams, and mapping specifications.

• Contribute to the development and improvement of team standards for requirements gathering, analysis, and documentation. Ensure all deliverables align with enterprise data governance standards.

Stakeholder Engagement

• Act as a day-to-day point of contact for assigned stakeholder groups, building strong working relationships across business and technology.

• Communicate progress, findings, and issues clearly to both technical and non-technical audiences.

• Participate in project meetings, working sessions, and walkthroughs, contributing analysis and insights to support decision-making.

Continuous Improvement

• Identify opportunities to improve data processes, reporting, and analysis workflows.

• Support automation and standardization initiatives within the team.

• Contribute to the evolution of the Client Data operating model as directed by the Associate Director.

What you need to succeed?

Required Experience & Skills

• 3-5 years in Business Analysis, Data Analysis, or a related role within financial services. Experience working in a data-intensive environment with exposure to multiple source systems and complex data flows.

• Demonstrated ability to own and deliver analysis workstreams within larger programs.

Technical Skills

• Strong SQL skills with experience querying large relational databases (SQL Server preferred).

• Proficiency in Excel including advanced functions; Power Query familiarity is an asset.

• Experience with data profiling, validation, and reconciliation across multi-source datasets.

• Exposure to Python, R, VBA, Tableau, or Power BI is an asset.

• Experience with Visio, PowerPoint & JIRA

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.

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

• Leaders who support your development through coaching and managing opportunities

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

• Flexible work/life balance options

#LI-KA2

Job Skills

Active Learning, Adaptability, Atlassian JIRA, Communication, Customer Service, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Operational Delivery, Product Services, Python (Programming Language), Time Management

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTorontoCanada37.5Full timeCAPITAL MARKETSRegularSalaried2026-04-142026-04-28

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.