Business Analyst - Tax Operations Service Enablement

RBC; Halifax; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading bank in Canada is seeking an experienced Business Analyst to support projects related to tax regulations such as FATCA and CRS. The role involves data analysis, documentation of business requirements, and collaboration with various teams to enhance tax operations. Candidates should have 3 to 5 years of relevant experience and strong skills in Excel VBA. This position offers competitive compensation and flexible work options.

Benefits

Comprehensive Total Rewards Program

Flexible work/life balance options

Opportunities for professional development

Qualifications

• 3 to 5 years of Business Analyst experience, preferably on tax related projects.
• Proven ability to work with Excel VBA (macros).
• Proven ability to manage multiple, concurrent assignments.

Responsibilities

• Conduct data analysis using Excel and VBA macros.
• Create business process map diagrams for operational processes.
• Document formal Business Requirements for application development.

Skills

Business Data Analysis

Communication

Critical Thinking

Excel VBA (macros)

Attention to detail

Education

Undergraduate degree

Tools

Excel

Visio

Job description

What is the opportunity?

Act as business analyst (BA) and subject matter expert (SME) on tax initiative based projects covering FATCA, US IRC Ch. 3/61, CDOT, CRS, US IRC Section 871(m), QI/QDD, US IRC 305(c) and 302.

The CM Tax Operations team has been initially formed to support FATCA but has assumed an expanded mandate covering a wide array of tax regulation; the BA will be expected to perform analysis against (i) the above mentioned tax regulation and (ii) the needs of the CM Tax Operations team; subsequently, the BA will be expected to document business requirements and outline current and future state process flows such that the CM Tax Operations team has the necessary processes, system functionality, controls and protocols in place to support compliance across all relevant tax regulations.

The BA will be dedicated to the enhancement and development of the CM Tax Operations team and will work closely with the Product Manager and Head of the CM Tax Operations team as well as collaborate with the CM Taxation, Global Client Data Services and other partners across Business Client Services.

What will you do?

• Data analysis involving heavy use of excel as well as VBA macros
• Create business process map diagrams for existing and proposed operational processes and system workflow; process maps required for end-to-end process flows, which delineate the roles and responsibilities of the various functions and teams involved, whilst highlighting (a) the interactions and hand-offs between the functions and teams (b) controls required (c) identification of gaps and outstanding issues and (d) recommended solutions
• Gather and document formal Business Requirements to support on-going development for an in-house application; requirements gathered in respect of the tax regulation and needs of the CM Tax Operations team; requirements to be documented using established RBC project management framework and standards.
• Requirements and process flows to be gathered and documented in collaboration with the Product Manager and Head of the CM Tax Operations team, CM Taxation, Global Client Data Services and other partners across Business Client Services
• Document and track project tasks that are assigned to the CM Tax Operations team; provide report of status to key partners and senior management
• Participate in testing initiatives; create and execute test cases
• Develop and document business cases for new or proposed initiatives
• As required and based on business need, develop and implement tactical initiatives in place of more strategic system based solutions

What you need to succeed?

• 3 to 5 years of Business Analyst experience, preferably working on financial regulatory projects and ideally on Tax related projects and an Undergraduate degree
• Proven ability to work with Excel VBA (macros)
• Proven ability to act as a Lead Business Analyst on projects
• Excellent analytical skills
• Excellent communication skills - both verbal and written
• Excellent appreciation for controls within processes
• Proven ability to manage multiple, concurrent assignments and multiple/conflicting priorities; well-developed time/self-management skills to plan, prioritize and organize work of others
• Proven ability to plan and execute work to meet tight deadlines
• Working knowledge of business process modelling tools such as Visio
• Good team player and comfortable dealing with all levels of management; proven ability to build relationships, work collaboratively, and resolve problems with people at all levels within the organization and with third party vendors
• Proven ability to propose and evaluate solutions in terms of business, financial and client requirements
• Displays a positive attitude towards complex challenges and problems, as well as routine maintenance and administrative tasks
• Attention to detail
• Proven ability to work independently
• Good Knowledge of FATCA/CRS and related tax regulation
• Overall Knowledge of tax operations applicable to a capital markets environment
• Securities/financial industry experience within Operations

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
• Leaders who support your development through coaching and managing opportunities
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work
• Flexible work/life balance options

Job Skills

Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements Analysis

Additional Job Details

• Address: 90 WESTERN PKY:BEDFORD
• City: Bedford
• Country: Canada
• Work hours/week: 37.5
• Employment Type: Full time
• Platform: CAPITAL MARKETS
• Job Type: Regular
• Pay Type: Salaried
• Posted Date: 2025-06-25
• Application Deadline: 2025-10-11

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.