What is the opportunity?

We are seeking a Data Specialists (Data Engineer, Analytics Engineer and Data Analyst) to join the Data Analytics and Insights Team of RBC Global Asset Management (RBC GAM). If you are passionate to learn about data engineering and data products delivery practices, please read on.

Data Engineer

• Assist in the development and delivery of data product solutions including building, customizing, and management of data pipelines, data integration tools, databases, data warehouses, and analytical systems.

• Analyze the business requirements and needs in terms of data sources, data transformation, data flow, and data quality.

• Produce technical artifacts to document solution designs and operational guidelines.

• Support testing requirements for data products and services including testing automation.

• Support the development and execution of strategic initiatives in collaboration with internal and external stakeholders using our software development life cycle (SDLC)

• Candidate must have knowledge of data engineering concepts and best practices such as data pipelines, ETL, data quality and data modeling.

Analytics Engineer

• Machine learning Platform Enhancement: to increase reusability and accelerate insight creation for GAM funds sales and marketing business.

• Increase awareness of the Advanced Analytics capabilities: to experiment with NLP capabilities on feature mining and retrievals.

• Developing, deploying, and maintaining data pipelines as well as building out our workflow framework to further the quality of our data assets and streamline the creation and delivery of the assets to end business users.

• Performing research and providing answers for customer generated inquiries.

• Contributing to ad-hoc tasks under direct supervision.

• Documenting processes or upgrading existing procedure manuals.

Data Analyst

• Process security, product and employee set up on Eagle system.

• Review data quality monitors daily and address data quality issues with data stakeholders.

• Analyze data and data workflows to improve data quality.

• Participate in data projects (e.g. contribute to GAM’s Data Literacy Program)

• Update and organize DMO’s Connect and Confluence (intranet) pages.

Technical skills:

Must-have:

• Data Engineer & Analytics Engineer stream: Have a strong quantitative background, a degree in math/statistics/computer science/engineering would be a plus. Data Analyst Stream: Have a strong business and finance background, a degree in Finance/Accounting/Business/Math is preferred.

• Experience working with SQL and large data sets.

• Experience in writing high quality code using general-purpose programming languages. Python is a strong asset.

• Familiar with Docker and containerization technologies.

• Strong Unix/Linux/Bash scripting skills

• Knowledge of AWS or similar storage solutions

• Experience working with DevOps CI/CD pipelines and automated testing.

• Experience working within professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source code management, build processes and testing.

• Decent understanding of Kubernetes/Docker compose (container orchestration).

• Experience with public and private cloud computing services including AWS or similar storage solutions.

• Desire to learn data capabilities such as data management, data governance, data mastering, data quality, data literacy, etc.

• Desire to learn data business intelligence tools (e.g. Excel, Tableau)

Soft skills:

• Great communication skills. Team player with the ability to work with a diverse group and offshore team

• Must be a self-starter, with strong analytical and problem-solving skills

• Ability to work in teams and collaborate effectively with people in different functional areas

• Excellent interpersonal and highly developed communication skills (verbal and written)

Please note: To be eligible for these student positions, you must either:

• Be returning 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.

Communication, Computer Literacy, Detail-Oriented, Interpersonal Relationships, Listening Effectively, Personal Development, Taking Initiative

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTORONTOCanada37.5Full timeWealth ManagementStudent/Coop (Fixed Term)Salaried2024-06-032024-06-16

Inclusion and Equal Opportunity Employment