IT Business & Data Analyst – Funding and Liquidity Technology

RBC•Toronto, ON

20h•Onsite

About The Position

The Funding and Liquidity Data Analyst ensures the bank's funding, liquidity, and treasury teams have accurate, reliable data for decision-making. You will manage data sourcing across multiple systems, establish governance frameworks to maintain data quality, and resolve inconsistencies that could impact reporting or compliance. By bridging business needs and technical solutions, you'll help the organization optimize operations, reduce risk, and ensure regulatory requirements are met.

Requirements

Bachelor's degree in business, finance, economics, data science, mathematics, computer science, or related field.
4–7 years of experience in data analysis, business analysis, or data engineering roles
Demonstrated proficiency with SQL for querying and analyzing relational databases
Strong experience with data sourcing, data mapping, and ETL processes
Proven ability to work with data governance frameworks and authoritative data source management

Nice To Haves

Experience with funding, liquidity management, cash management, or treasury systems
Advanced SQL skills and experience with Python or similar scripting languages
Experience with data visualization tools such as Tableau or Power BI
Knowledge of regulatory requirements related to liquidity reporting and core banking platforms

Responsibilities

Identify, evaluate, and maintain an inventory of internal and external data sources that support funding and liquidity operations, including core banking systems, market feeds, and regulatory platforms
Conduct data mapping exercises and document how data flows from source systems through transformation layers to end-user reports, capturing business rules and transformation logic
Assess data quality, completeness, and timeliness across systems, identify data discrepancies, and develop remediation plans for gaps or inconsistencies
Gather business requirements from stakeholders and translate them into data specifications, preparing impact assessments on changes to data sources or definitions
Extract and analyze funding and liquidity data to identify trends, risks, and optimization opportunities, developing dashboards that help teams monitor key metrics in real time
Participate in testing and user acceptance activities, validating data accuracy and providing ongoing support to users in understanding data sources and quality considerations