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

Royal Bank of Canada; Toronto; On-site; CAD 65,000 - 90,000; Full time

Job summary

Royal Bank of Canada is seeking a Data Analyst to provide expertise for Data Management spanning platforms and projects. You will ensure data is well documented and managed across RBC Investor Services, leading design, development, testing and delivery.

In a dynamic team, you will apply strong data analysis, leadership, and communication skills, with a sense of urgency to respond to changing priorities and accountability for results achieved.

Qualifications

• Bachelor or Master’s degree in data management, data analytics, data science, finance, business administration, or related field.
• Ability to work independently and within a team environment.
• Professional written and verbal communication skills.
• Strong analytical, communication and problem solving skills.
• Highly organized with high attention to detail and accuracy.
• Ability to prioritize, handle multiple tasks under pressure and meet time-sensitive deadlines.
• Ability to think critically and outside the box.

Responsibilities

• Collaborate with product, business development, Client Ops and digital teams to gather data requirements.
• Analyze data within legacy data delivery channels and translate business rules for modern tools.
• Lead agile-like and business-led initiatives across a matrix environment.
• Leverage data to create efficiencies and reduce business/client risk.
• Build and enhance Data quality frameworks and operating models for datasets.
• Consult with business, SMEs and Domain Experts for Data Quality Rules implementation.
• Coordinate with data engineers to define data flows and Data Quality points.
• Provide weekly updates on data quality rules and share reports with Stewards.
• Manage the status of data quality rules and investigate exceptions.
• Build AI/ML solutions to identify data anomalies in production pipelines.
• Investigate client exceptions & escalations.

Skills

Communication skills

Analytical thinking

Problem solving

Time management

Organizational skills

Education

Bachelor’s or Master’s degree in data management / data analytics / data science / finance / business administration

Tools

Python

Scala

Java

SQL

PySpark / Apache Spark

Hadoop / MapReduce

Apache Kafka

PostgreSQL

AWS / Azure

Docker

Kubernetes

Power BI / Tableau

Job description

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 tobe eligible for these student positions, you must either: