Lead Business Systems Analyst, Compliance Technology, GFT - Halifax

RBC; Halifax; On-site; CAD 85,000 - 115,000; Full time

Job summary

A leading Canadian bank is seeking a Lead Business Systems Analyst to join its Compliance Technology team in Halifax. The successful candidate will be responsible for eliciting and documenting functional requirements for Trade Compliance projects, developing project plans, and managing data acquisition activities. Applicants should have over 5 years of experience in business systems analysis within an agile environment, strong understanding of databases, and expertise in managing stakeholder expectations. This position offers competitive compensation and opportunities for professional development.

Benefits

Comprehensive Total Rewards Program

Leaders support development

Flexible work/life balance options

World-class training program

Qualifications

• 5+ years of experience with business systems analysis in an agile environment.
• Experience with defining and documenting complex functional business logic and data mapping specifications.
• Strong understanding of ETL processes and knowledge of databases like Oracle and MS SQL Server.

Responsibilities

• Elicit and document functional and system requirements for Trade Compliance projects.
• Develop plans and accurate estimates for completion of requirements.
• Manage data acquisition and mapping activities.

Skills

Atlassian Confluence

Functional Testing

SQL Database Queries

Scrum (Agile)

IT Business Analysis

JIRA Tool

Job description

Job Description

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, along with 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 an agile (Scrum) environment
• Experience with defining and documenting complex functional business logic and data mapping specifications within the 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

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

Address: 175 WESTERN PKY:BEDFORD

City: Bedford

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2025-10-20

Application Deadline: 2026-02-21

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.

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.