Job Summary
Job Description
What is the opportunity?
A a Senior Analyst, you will be responsible for ensuring the accuracy and completeness of the data in Securities Data Repository by leveraging advanced analytics techniques, and for providing insight into data through reporting and analytics.
***Please note, this is a Eighteen-Month contract opportunity***
What will you do?
- Support complex data query requests to provide insight into the coverage and nature of reference data
- Be responsible for large scale multi-way comparisons of Securities data against various internal and external sources to identify trends and to measure overall data quality
- Overseeing the integrity and maintenance of organizational data.
- Reviewing and recommending policies and procedures for collecting and managing organization data.
- Develop and implement reporting and data visualization dashboards to articulate trends and data quality measurements
- Develop monitoring to proactively identify data quality gaps
- Support the root cause analysis of data issues relating to security data, and perform complex remediation requiring advanced pattern recognition and machine learning
- Identify and coordinate system and process enhancements and improvements
What you need to succeed?
- Completion of an applicable university degree and/or relevant professional designation.
- A minimum of two years of experience in Python, R and or other programming languages.
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
Job Skills
Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Quantitative Research, Research Documents
Additional Job Details
Address:
120 WESTERN PKY:BEDFORD
City:
BEDFORD
Country:
Canada
Work hours/week:
37.5
Employment Type:
Full time
Platform:
CAPITAL MARKETS
Job Type:
Regular
Pay Type:
Salaried
Posted Date:
2025-01-06
Application Deadline:
2025-01-31
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
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
RBC Toronto, Ontario, CAN Office
200 Bay Street, Toronto, Ontario, Canada, M5J 2J5
