Senior Business Analyst (Data)

Royal Bank of Canada • Montreal, QC

5d • Onsite

About The Position

The Funding and Liquidity Senior Business Analyst (Data) 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 with 3+ years of experience in business analysis, data 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

• Translate and validate complex business rules with stakeholders, ensuring mutual agreement on definitions, logic, and expected outcomes.
• Implement data masking techniques to protect sensitive information in non-production environments.
• Analyze and evaluate system solutions that meet business objectives, including assessing existing systems and recommending improvements or replacements, while creating system diagrams and technical specifications to guide implementation.
• 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.
• Communicate and interact frequently with RBC partners and/or employees located across Canada and/or worldwide.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior