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

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.

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.

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