Manager, Data Analyst, CFO Group

RBC; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A major financial institution in Toronto is looking for a professional to join the CFO Group as a Data Analyst. This role involves leveraging strategic data assets and creating automation solutions to support financial transformation. The ideal candidate will have expertise in SQL, Python, and data analytics, and will work collaboratively with various stakeholders to identify and resolve business issues. This position offers full-time employment and an opportunity to be part of a high-performing team.

Benefits

Opportunities for career growth

Challenging work with the latest technologies

Collaborative work environment

Qualifications

• Experience with data extraction and loading from various sources using SQL.
• Proficiency in Python packages like Pandas and Numpy.
• Strong analytical skills to investigate and resolve system issues.

Responsibilities

• Document and analyze business requirements with stakeholders.
• Design and test reporting solutions using Python.
• Build and manage relationships with stakeholders across teams.

Skills

Data Extraction

SQL

Data Transformation

Analytical Thinking

Python

Tools

Apache Airflow

Dagster

Tableau

Selenium

Windows Servers

Job description

Job Description

What is the Opportunity?

This is an exciting opportunity in CFO Group where you will play an instrumental role in leveraging RBC's strategic data assets to build automation solutions and data analytics models. We are currently seeking for an individual with strong data/business analysis background who is quick to adapt to new technologies and enthusiastic about developing innovative solutions to support the digital transformation in Finance. This role will work with various stakeholders in helping to identify business problems and prioritize them to unlock business value.

The Data Enablement team is focused on developing strategic solutions to support key Report to Shareholder and Regulatory Reporting initiatives across the bank. Our team consists of highly accomplished professionals with various backgrounds in computer science, data engineering, business analytics, accounting and finance to deliver innovative solutions that supports data-driven decisions.

Areas of Focus

• Personal Banking and Commercial Banking business and products
• Capital Markets business and products
• International Banking (U.S. and Caribbean) Insurance and Corporate Support business and products
• Wealth Management business and products

What will you do?

Data Analysis

• Work closely with subject matter experts to document detailed business requirement, and ensures requirements are in line with business goals and objectives
• Analyze large data sets and system extracts to build business rules behind automated data pipelines
• Using SQL to understand data sets about different systems and extract data
• Identify, analyze implications and communicate program issues, risks and dependencies, so that they can be appropriately mitigated
• Work collaboratively with cross-functional teams and develop and manage relationship with relevant stakeholders
• Manage, communicate and author changes to the requirements

Solution Design

• Design, develop and test reporting solutions and reconciliation processes using Python
• Develop and execute tests, log and track issues and drive them to resolution with verification of bug fixes, document test results and research findings
• Develop scripts as needed to assist in the systems validation process
• Integrate with existing data storage solutions
• Coordinate with front-end developers and data engineers

What do you need to succeed?

Must-have

• Demonstrated experience with data extraction, transformation, and loading from a wide variety of data sources using SQL and related technologies (Oracle, Vertica, Hive, etc).
• Working knowledge in implementing and performance tuning ETL pipelines using Dagster, Apache Airflow or Prefect.
• Proficiency in Python, specifically Pandas, Sqlalchemy, Numpy and Selenium packages.
• Excellent analytical skills & critical thinking skills to investigate system and business issues, determine root cause, and deliver sustainable solutions.
• Commitment to continuous improvement; specifically, ability to identify existing processes and gaps across the current system landscape.

Nice to have

• Experience in RBC IT systems and service platforms (e.g. Core, Confluence, ServiceNow, Access Manager).
• Open to learn and innovate using tech stack or framework like Flask, Django and any front-end framework.
• Experience in managing Windows Servers using IIS.
• Proficiency in Excel VBA.
• Experience with Business Intelligence Reporting & visualizations using Tableau.
• Basic knowledge of git, APIs, Docker and/or DevOps.

What’s in it for you?

It provides the opportunity to be a part of a high performing experienced team with progressive thinking to deliver trusted advice to help our clients thrive and communities prosper.

• Opportunities to do challenging work utilizing latest technologies
• Opportunities to see measurable results in relatively short term
• Opportunities to take on progressively greater accountabilities
• Opportunities to building close relationships with counterparts across the bank

Job Skills

Artificial Intelligence (AI), Big Data Management, Data Mining, Data Science, Decision Making, Machine Learning (ML), Natural Language Processing (NLP), Predictive Analytics, Python (Programming Language), Statistical Analysis

Additional Job Details

Address: ROYAL BANK PLAZA, 200 BAY ST:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: OFFICE OF THE CFO

Job Type: Regular

Pay Type: Salaried

Posted Date: 2025-12-11

Application Deadline: 2026-01-30

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.

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.