Analyst, Investment Analytics - Toronto, Canada - Royal Bank of Canada

Royal Bank of Canada

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Job Summary

What is the Opportunity?

The Portfolio Advisory Group (PAG) is responsible for advising RBC WM Canada's ~2000 Investment Advisors, who collectively manage more than $450 billion in assets under management at RBC Dominion Securities.

The team provides support on a broad range of investment-related activities, including asset allocation, portfolio construction, equity, fixed income, alternatives, active and passive fulfillment evaluation and selection, and individual security analysis.

The role on the Analytics team will be focused on supporting the investment teams and more specifically enhancing the team's capabilities around data on its portfolios and underlying investments so that more informed decisions can be made to raise the quality and outcomes across a range of our portfolios.

What will you do?

Support I&T's ability to increase the efficiency and effectiveness of PAG's investment strategy by partnering with various groups across RBC.
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Design, implement, and continuously support the development of our web analytics platform (dash, flask, fastapi).
Help improve processes through automation where possible.
Learn the business as usual for performance and risk management to support our investment committees.
Ensure policies and procedures are implemented and documented.
Conduct Ad hoc projects, data extractions or analysis as directed.
Be a part of a startup like setting where fastfail is highly valued, level of uncertainty is high and requirements are not all defined in advance (iterative feedback loop).

What do you need to succeed?

Must Have:

At least 2 years experience with data engineering, and development work.
Bachelor's degree in a STEM field, or strong technical skills with Business degree or MIS.
Experience in
Microsoft SQL Server, and programming languages/related frameworks (
Python, Javascript, HTML, CSS).
Strong interest or exposure to investments/markets.
Knowledge of financial systems (FactSet, Bloomberg, Refinitiv, etc) and working with time series data from these vendors.

Nice to Have

Experience using Git, Github, Openshift, agile design methodologies and frameworks.
Pursuing/interest in Chartered Financial Analyst or other finance/risk training or designation.
Experience using cloudenabled technologies such as Amazon Web Services (AWS), specifically S3, Athena, EMR, RDS, or other AWS database related products.
Experience with big data analytics technologies (e.g. Hadoop, Spark, Kafka); experience compiling, manipulating and analyzing large datasets, with a good understanding of data processing frameworks.

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, commissions, and stock where applicable
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and highperforming team
A worldclass training program in financial services

Job Skills
Critical Thinking, Data Engineering, Data Pipelines, Developmental Work, Financial Instruments, Flask (Web Framework), Hyper Text Markup Language (HTML), Investment Performance Measurement, Investment Risk Management, JavaScript, Microsoft SQL Server, Process Improvements, Python (Programming Language), R Programming, Structured Query Language (SQL) Development, Web Development

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:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

Inclusion
and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth.

We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work.

We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.

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.