Job Summary
Job Description
What is the opportunity?
Reporting to the Vice President within Client Data Services, the Senior Manager will play a key role in developing and executing upon the data management strategy and goals for RBC Capital Markets. As part of an evolving and maturing client data services function, the Client Data Services team is accountable for the implementation and maintenance of the Client reference data used in our operational processes, supporting our data governance and quality controls, as well as participating actively in business and regulatory initiatives that have a significant data impact. The incumbent will possess significant knowledge of, and experience with, counterparty reference data, data analysis tools and technologies. The ideal candidate brings expertise in project implementation and a high degree of comfort with technology and data related applications. This position requires the ability to collaborate extensively with colleagues from varying backgrounds including investments, operations and technology. Experience in relationship management, data operations, project management, and SDLC is required. Candidate must also have vast experience leading a successful team.
**** Please note, this is an 18-month contract position***
What will you do?
- Collaborate with different teams across RBC (Information Technology, Change Management, Operations, Regulatory Reporting ) in order to enhance the functioning and efficiency of Counterparty Data and identify emerging issues and trends to assist senior leader with decision making.
- Make strategic recommendations on data collection, integration and retention requirements incorporating business requirements and best practices.
- Develop analytical solutions by applying machine learning techniques and making recommendations based on an understanding of the business strategy and stakeholder needs and work with various data owners to discover and select available data from internal sources and external vendors to fulfill analytical needs.
- Summarize statistical findings and drawing conclusions; presenting actionable business recommendations in a simplified manner, applying expertise and thinking creatively to address unique or ambiguous situations and to find solutions to problems that can be complex and non-routine.
- Test the implementation of new requirements and working with QA team for successful releases and applying scripting/programming skills to assemble various types of source data (unstructured, semi-structured, and structured) into well prepared data sets with multiple levels of granularities.
- Perform supervisory duties including but not limited to interviewing, hiring, and training of employees and assist the team with developing and executing upon the data services strategy of RBC Capital Markets and the maintenance of client reference data through the use of technology.
- Support and manage data governance, data quality initiatives and business and regulatory initiatives
What do you need to succeed?
Must-have:
- Completion of an applicable university degree and/or relevant professional designation preferably in Computer Science
- A minimum of two years of experience in Python, R and or other programming languages.
- Advanced Excel Skills including the ability to; Analyze large data sets using pivot tables and pivot reporting, write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit, build macros using VBA (Visual Basic for Applications) and structure and present data for reporting using conditional formatting, tables and charting.
- Intermediate SQL skills including the ability to: understand and use SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions, understand and use update and insertion statements and syntax for altering and creating structures, generate complex data reports using GROUP BY and aggregate functions and understand 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.
- Opportunities to do challenging work
- Work in a dynamic, collaborative, progressive and high-performing team
- Opportunities to take on progressively greater accountabilities
- Access to a variety of job opportunities across business and geographies
Job Skills
Business Intelligence (BI), Commercial Acumen, Critical Thinking, Customer Analytics, Detail-Oriented, Requirements Analysis, Results-Oriented
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:
CAPITAL MARKETS
Job Type:
Regular
Pay Type:
Salaried
Posted Date:
2024-10-01
Application Deadline:
2024-10-15
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.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
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.
Top Skills
What We Do
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 88,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com.
We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities.
_2.png)
.JPG)
_2.png)
