What is the opportunity?

Reporting to the Manager, Client Data Management, you will play a key role in developing and executing upon the data management strategy and goals for RBC Capital Markets. 

You will support the global management of Client reference data for Capital Markets, ensure data content is fit for purpose and meets the data quality requirements of business consumers, provide robust data analysis and subject matter expertise that supports daily operations and enterprise initiatives and interface with internal and external clients and vendors as they relate to client data management 

What will you do?

Technical Competencies

Analyze large data sets; must possess strong skills in string query languages and Excel

Write, design and test algorithms and applications for data analysis & data manipulation using R, Python and other known programming languages. Use technology to collect, analyze and compile data for various operational and reporting purposes.

Modify and maintain existing scripts and queries in response to technical issues and changing requirements.

Drive operational effectiveness

Provide subject matter expertise within the client data and data management function knowledge domains that support daily operations and enterprise initiatives   

Create and automate operational processes to reduce processing time, reduce manual effort and improve data quality 

Capture, measure, and report metrics on the dimensions of data quality that support business defined objectives 

Demonstrate strong initiative to produce insightful analysis of business issues and suggest potential solutions/options based on analysis

Communication & Leadership

Work collaboratively and build strong relationships with colleagues across RBC Capital Markets

Build and mature working relationships with colleagues within the Data Management Office

Deliver concise, relevant presentations at the client and book data management team level

What you need to succeed?

University degree and/or relevant professional designation with a minimum of two years of experience in Python, R and or other programming languages

Solid understanding of data management practices

2+ years of data management experience in a similar role within the investment industry

Advanced Excel Skills

Analyze large data sets using pivot tables and pivot reporting

Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit

Build macros using VBA (Visual Basic for Applications)

Ability to structure and present data for reporting using conditional formatting, tables and charting

Intermediate SQL skills

Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions

Understanding and usage of update and insertion statements and syntax for altering and creating structures

Can generate complex data reports using GROUP BY and aggregate functions

Understands SQL concepts of foreign keys, transactions, triggers, and stored procedures

Excellent communication skills – written and oral

Strong troubleshooting and problem solving skills

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

Leaders who support your development through coaching and managing opportunities  

Work in a dynamic, collaborative, progressive, and high-performing team 

Opportunities to do challenging work

Flexible work/life balance options

RBC requires as a condition of employment that all successful candidates in the United States and Canada be fully vaccinated against COVID-19 prior to their start date, and may require proof of the same.  Reasonable accommodation is available where required by law.

RBC exige, à titre de condition d’emploi, que tous les candidats retenus aux États-Unis ou au Canada soient entièrement vaccinés contre la COVID-19 avant leur date d’entrée en fonction. Il est possible qu’ils aient à présenter une preuve vaccinale. Des mesures raisonnables d’adaptation sont offertes lorsque la loi l’exig

RBC is committed to supporting flexible work arrangements when and where available. Details to be discussed with Hiring Manager.

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.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

JOB SUMMARY

City:  Halifax 

Address:  120 Western Parkway - 4th Floor, Bedford 

Work Hours/Week:  37.5 

Work Environment:  Office 

Employment Type:  Full Time  

Career Level:  Experienced Hire/Professional 

Application Deadline:  02/02/2022 

Platform:  Capital Markets 

Req ID:  443881