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

Job summary

The Data Analyst will manage and document data across platforms while designing and delivering solutions for complex business requirements. They will also build data quality frameworks and develop AI/ML solutions to identify anomalies within production pipelines.

Job details

Job Description Job Description Summary 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. Job Description 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 Please note: In order to be eligible for these student positions, you must either: Be returning back to school after the work term end-date; or If you are not returning back to school (i.e. are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully 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. At RBC, you will have opportunities to: Interact with leaders who support your development through coaching and managing Network and build lasting relationships with students from diverse backgrounds from across Canada Make a difference and lasting impact through meaningful work Work in a dynamic, collaborative, progressive, and high-performing team Job Skills Communication, Computer Literacy, Detail-Oriented, Interpersonal Relationships, Listening Effectively, Personal Development, Personal Initiative 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 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.

What you’ll do

The Data Analyst will manage and document data across platforms while designing and delivering solutions for complex business requirements. They will also build data quality frameworks and develop AI/ML solutions to identify anomalies within production pipelines.

Requirements

Candidates must be currently pursuing a Bachelor or Master's degree in a relevant field such as Data Science, Finance, or Economics. Strong analytical, communication, and organizational skills are required, along with proficiency in programming languages like Python and SQL.

Benefits

• Professional development coaching • Networking opportunities • Collaborative work environment

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• Problem solving · Preferred
• Data analysis · Preferred
• Machine learning · Preferred
• Communication · Preferred
• Critical Thinking · Preferred
• data management · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data analysis
• Data management
• Python
• SQL
• Data quality frameworks
• Data pipelines
• ETL
• Apache Spark
• Power BI
• Tableau
• Problem-solving
• Communication
• Critical thinking
• Artificial intelligence
• Machine learning
• Cloud computing
• Database Management
• Atlassian Confluence
• Workplace Inclusivity
• Pipelines
• CI/CD
• Accountability
• Git (Version Control System)
• Positivity
• Strong Work Ethic
• Programming Languages
• Java (Programming Language)
• Application Programming Interface (API)
• Agile Methodology
• Artificial Intelligence
• Amazon Web Services
• Amazon Elastic Compute Cloud
• Amazon S3
• Data Analysis
• JIRA
• Microsoft Azure
• Business Development
• Business Administration
• Containerization
• Cloud Computing
• Computer Literacy
• Critical Thinking
• Data Integrity
• Extract Transform Load (ETL)
• Data Management
• Data Transformation
• Data Quality
• Data Visualization
• Development Testing
• Distributed Computing

Job areas

• Data & Analytics
• Finance & Accounting
• Technology
• Software
• Investment Data Analyst
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists