Analyst, Data Insights

What is the opportunity?

In the increasingly complex world of financial services, accurate and complete data is critical for risk management and regulatory compliance. Ensuring data integrity begins with an understanding of financial services data, data quality controls and identifying and resolving data observations and issues. As an Analyst, Data Insights, you will be accountable for driving improvements in Risk and Finance data through the management of identification, root cause analysis, and resolution of data issues for US business critical processes and regulatory reports.

Reporting to the Associate Director, you will be responsible in building trust and ensuring the accuracy and completeness of shared data assets and reporting data by managing data quality initiatives.

What will you do?

Data Quality monitoring, observation identification and management

• Review and assessment of exceptions and observations management investigations and reporting, and overseeing and monitoring the remediation of data and processes, as required.

Investigations and reporting

• Manages and conducts detailed investigations and report findings based on data exceptions, identified observations, and ad hoc requests from critical Report owners and other users of shared data assets.
• Provide monthly summary and detailed data quality reporting to business partners and stakeholders, including data quality exceptions, findings and the status of outstanding observations.

Continuous improvement

• Based on root-cause analysis findings, propose process changes/improvements to address gaps or inconsistencies in data, processes and/or controls and raise awareness of best practices and approved provisioning points for commonly used data assets.
• Maintain data quality tests and data quality observation repositories

Leadership and collaboration

• Communicate effectively with team members, stakeholders and business partners, resolving conflicts/issues of medium complexity and escalating to others as appropriate.

What do you need to succeed?

Must-have

• Demonstrated ability to understand data relationships, aggregate information and utilize SQL or other querying languages to research data issues and conduct root cause analysis
• 2+ years of experience in financial services, data management and business analysis.
• Ability to translate business requirements into data requirements
• Excellent communication skills, both written and spoken, and able to dissect complex ideas and concepts to provide clear, concise and relevant summaries and insights
• Results oriented; able to set and consistently meet high-quality standards while handling a variety of task and deadlines simultaneously, with ability to collaborate with many stakeholders
• Detail-oriented with strong analytical skills and ability to work under pressure to deliver within time-sensitive deadlines

Nice-to-have

• Undergraduate degree.
• Ability to read and understand financial and regulatory documentation.
• Ability to be able to think creatively and use 'out of the box' solutions where possible.
• Change mindset and ability to apply a process improvement lens to all BAU activities.
• Experience working with financial or credit risk data.
• Knowledge of Collibra or a similar data management workflow platform.

​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 and 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

Job Skills

Communication, Critical Thinking, Data Administration, Data Analysis, Database Structures, Data Integrity, Data Modeling, Data Movement, Data Quality, Data Reporting, Datasets, Detail-Oriented, Group Problem Solving, Information Capture, Microsoft Excel, Standard Operating Procedure (SOP), Structured Query Language (SQL), Tableau (Software), Teamwork, Teradata SQL, Time Management

Additional Job Details

BAY WELLINGTON TOWER, 181 BAY ST:TORONTOTORONTOCanada37.5Full timeCHIEF LEGAL & ADMIN OFFICE GRPRegularSalaried2025-04-092025-04-23

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 believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.