Lead Business Systems Analyst, Compliance Technology, GFT

Job DescriptionWHAT 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 ManagementDevelop plans and accurate estimates for completion of requirements, continuously improving the level of details and accuracy of estimatesBuild and maintain on Confluence a repository of reusable requirements documentation to support future initiatives, following the enterprise standardsInteract 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) environmentExperience 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 scriptingAbility to analyze and understand database schema for data mappingAbility to work with a global business group and requirementsWhat’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 applicableLeaders who support your development through coaching and managing opportunitiesAbility to make a difference and lasting impact in technology transformationWork in a dynamic, collaborative, progressive, and high-performing teamA world-class training program in financial services and technologyFlexible work/life balance options#LI-POSTJob SkillsAtlassian Confluence, Data Requirements, Functional Testing, IT Business Analysis, JIRA Tool, Reimbursement Analysis, Requirements Capture, Requirements Management, Scrum (Agile), SQL Database QueriesAdditional Job DetailsAddress:175 WESTERN PKY:BEDFORDCity:BedfordCountry:CanadaWork hours/week:37.5Employment Type:Full timePlatform:TECHNOLOGY AND OPERATIONSJob Type:RegularPay Type:SalariedPosted Date:2025-10-20Application Deadline:2026-02-21Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date aboveInclusion and Equal Opportunity EmploymentAt 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 CommunityStay 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.RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.