2027 Investor Services, PEY Data Analyst (12-16 months)

0000055528 RBC Investor Services Trust; Toronto; On-site; CAD 42,000 - 64,000; Full time

Job summary

RBC Investor Services Trust is seeking a Data Analyst to provide expert data management across platforms and projects. You will lead data requirements gathering, translate business rules, and drive data quality frameworks with a proactive, collaborative approach.

In this role you will work with agile-like initiatives, apply data principles to reduce risk, and deliver timely data solutions for business and client needs in a dynamic team environment.

Qualifications

• Working towards a Bachelor or Master’s degree in data management or related field.
• Strong written and verbal communication skills.
• Ability to analyze data and solve problems with attention to detail.
• Ability to work independently and in a team, manage multiple tasks.

Responsibilities

• Collaborate with product, business development, Client Ops and digital teams on data requirements.
• Analyze data across legacy channels and define requirements for modern tools and channels.
• Lead agile-like initiatives across a matrix environment.
• Leverage data to create efficiencies and reduce risk for business/clients.
• Build and enhance data quality frameworks and operating models.
• Confirm critical data elements with business and domain experts.
• Coordinate with data engineers to define data flows and quality points.
• Provide weekly updates on data quality rules for Master Reference Data.
• Manage status of data quality rules and investigate exceptions.
• Explore AI/ML solutions to identify data anomalies in production pipelines.
• Support client exceptions and escalations as needed.

Skills

Data analysis

Communication

Problem solving

Teamwork

Attention to detail

Education

Bachelor's or Master’s degree in data management or related field

Tools

Python

SQL

Apache Spark

Hadoop

Kafka

Power BI

Tableau

PostgreSQL

AWS

Azure

Docker

Kubernetes

Jira

Confluence

Git

Job description

Job Description

As the Data Analyst, you will provide expertise for Data Management spanning both platforms and projects. At the core of the role is a detailed understanding of Data management principles and the ability to apply them to meet business and client data requirements. Your role is to ensure that data is well documented and managed across RBC Investor Services. You will be called on to find solutions to complicated data requirements and lead the design, development, testing and delivery. As a member of a dynamic, fast paced team, this role brings strong data analysis skills and leadership, effective written and verbal communication skills, a strong work ethic and a demonstrated capability to multi-task effectively. This role requires strong interpersonal, organizational and problem-solving skills as well as a demonstrated sense of urgency to respond to changing priorities at times. This is complemented by a positive attitude and a willingness to take accountability for results achieved.

What will you do?

• Collaborate with product, business development, Client Ops and digital teams on gathering data requirements.
• Analyze data within existing legacy data delivery channels, understand/translate business rules and define data requirements for delivering through modern tools and channels.
• Actively lead and engage in agile-like and business-led initiatives across a matrix environment.
• Leverage data to create efficiencies and reducing business/client risk.
• Build & enhance Data quality frameworks and operating models, which will deliver measurement, execution, monitoring, analysis and resolution support for datasets.
• Consult & confirm critical data elements (CDEs) with business, SME and Domain Experts for implementation of Data Quality Rules.
• Coordinate with data engineers to define Data flows and Data Quality measuring Points
• Provide weekly updates for actively running data quality rules for Master Reference Data and share reports with Stewards
• Actively manage the status of data quality rules enabled on datasets and investigate identified exceptions
• Build “Artificial Intelligence & Machine Learning” solutions that can identify data anomalies within active production pipelines
• Investigate and provide support for client exceptions & escalations

What do you need to succeed?

• Must-have Working towards a Bachelor or master’s degree in data management, Data Analytics, Data Science, Finance, Business Administration, Economics other related field
• Strong personal skills and the ability to work effectively independently and within a team environment.
• Professional written and verbal communication skills
• Good analytical, communication and problem solving skills
• Highly organized with good attention to detail and very high level of accuracy
• Ability to prioritize, handle multiple tasks under pressure and meet time-sensitive deadlines
• Ability to think critically and “outside the box”

Nice-to-have

Prior experience in the financial services industry, and strong understanding of the data lifecycle, including strong focus on data management and data quality practices.

Technical Skills

• Programming Languages: Python, Scala, Java, SQL, etc.
• Data Management: ETL (PySpark, Apache Spark), Data Transformation, Data Pipelines, Data Integrity Distributed Computing: Hadoop, HDFS, MapReduce, Apache Spark
• Data Streaming: Apache Kafka
• Database Management: PostgreSQL, AWS RDS, DynamoDB (NoSQL), Elastic Search
• Cloud Computing: AWS (S3, EC2, Lambda, RDS), Azure
• Containerization & Orchestration: Docker, Kubernetes
• Terraform
• Jira, Confluence, Postman, APIs
• CI/CD Tools: Jenkins, Git
• Data Analysis and Visualization: Data Visualization Tools: Power BI, Tableau

Additional Job Details

• Address: RBC CENTRE, 155 WELLINGTON ST W:TORONTO City: Toronto Country: Canada
• Work hours/week: 37.5
• Employment Type: Full time
• Platform: WEALTH MANAGEMENT
• Job Type: Student/Coop (Fixed Term)
• Pay Type: Salaried
• Posted Date: 2026-09-16
• Application Deadline: 2026-10-01

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.

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 84,000+ employees who bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to more than 16 million clients in Canada, the U.S. and 34 other countries.

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at rbc.com/community-social-impact.