WHAT IS THE OPPORTUNITY?

As a Lead Business Systems Analyst in the Compliance Technology team, you will execute all aspects of requirements delivery and data analysis- planning, elicitation, analysis and documentation, and requirements management. You will play a core role in translating business requirement documents into functional requirements to design and implement new scenarios to provide surveillance to detect potential market misconduct.

WHAT WILL YOU DO?

• Elicit and document functional and system requirements for Trade Compliance projects for Capital Markets and Wealth Management
• Develop plans and accurate estimates for completion of requirements, continuously improving the level of details and accuracy of estimates
• Build and maintain on Confluence a repository of reusable requirements documentation to support future initiatives, following the enterprise standards
• Interact with source systems teams that will provide data for trade, market, client and reference data for Compliance Applications.
• Manage data acquisition and data mapping activities.
• Work with the ETL team, developers, Vendor consultants and numerous data sources to gather data requirements and mapping specifications.
• Provide BSA support to development team and quality assurance team during development, testing and implementation.
• Participate in implementation planning, data preparation and post implementation validation.

WHAT DO YOU NEED TO SUCCEED?

Must have:

• 5+ years of experience with business systems analysis in agile (Scrum) environment
• Experience with defining and documenting complex functional business logic and data mapping specifications within Investment Industry (knowledge of investment products and their trade life cycle)
• Strong understanding of ETL processes and working knowledge of databases: Oracle, MS SQL Server or MySQL (SQL scripting)
• Expertise in test planning, test case preparation and testing of applications and data mapping.
• Expertise in managing various stakeholder expectations in delivering project deliverables.

Nice-to-have:

• Experience in working with large projects with multiple data sources and system interfaces.
• Experience with software development methods and life cycle, hands on Python scripting
• Ability to analyze and understand database schema for data mapping
• Ability to work with a global business group and requirements

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 compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact in technology transformation
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial services and technology
• Flexible work/life balance options

#LI-POST

Job Skills

Atlassian Confluence, Data Requirements, Functional Testing, IT Business Analysis, JIRA Tool, Reimbursement Analysis, Requirements Capture, Requirements Management, Scrum (Agile), SQL Database Queries

Additional Job Details

175 WESTERN PKY:BEDFORDBedfordCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2025-10-202025-11-20

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.