Job Summary

Manages the development, implementation and support of business analytics initiatives and projects. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.

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.

What will you do?

Support complex data query requests to provide insight into the coverage and nature of reference dataBe responsible for large scale multi-way comparisons of Securities data against various internal and external sources to identify trends and to measure overall data qualityOverseeing 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 measurementsDevelop monitoring to proactively identify data quality gapsSupport the root cause analysis of data issues relating to security data, and perform complex remediation requiring advanced pattern recognition and machine learningIdentify 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 reportingAbility to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and auditBuild 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 unionsUnderstanding and usage of update and insertion statements and syntax for altering and creating structuresCan generate complex data reports using GROUP BY and aggregate functionsUnderstands SQL concepts of foreign keys, transactions, triggers, and stored proceduresExcellent communication skills – written and oralStrong 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 compensationLeaders who support your development through coaching and managing opportunities Work in a dynamic, collaborative, progressive, and high-performing teamOpportunities to do challenging workFlexible 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-10

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.