Analyst, Investment Analytics

Key Skills

3D data processing, Agile methodologies, Amazon Athena, Apache Hadoop, Apache Kafka, AWS, CSS, Data Engineering, Data pipelines, Design, Git, Github, HTML, Investment Bank, JavaScript, Python Programming, R Programming, Red Hat OpenShift, SPARK Programming, SQL, SQL Server

Job Description

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.

This is an opportunity for someone with strong technical skills and some exposure to investment to continue applying data engineering, automation and web development skills, and develop knowledge with us on performance and risk.

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 start-up like setting where fast-fail 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 cloud-enabled 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 high-performing team
• A world-class 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