Business Analyst - Risk IT

Capgemini; Toronto; On-site; CAD 36,000 - 56,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Job summary

Capgemini in Toronto, Canada is seeking a Business Analyst with strong regulatory reporting experience in banking. You will map source data to internal monitoring and reporting, support external regulatory reporting such as LEF/SCCL, and coordinate production activities across teams.

Responsibilities include creating mapping logic, documenting requirements, liaising with IT for development, planning UAT, coordinating implementation and migration, and providing regular status updates to project

Qualifications

• Experience in systems implementation or reengineering within a banking organization or consulting company.
• Undergraduate degree or higher, preferably in Mathematics, Computer Science, Engineering, or Finance.
• Knowledge of SDLC methodologies, Agile, and related delivery frameworks.
• Experience with SQL and data platforms, including Hive, MS SQL Server, Teradata, HUE, and Dremio.
• Advanced proficiency in MS Word, MS Project, MS PowerPoint, MS Excel, Visio, MS Access.

Responsibilities

• Understand counterparty credit exposure measurement for various products and map source data to internal monitoring and reporting.
• Create mapping logic for counterparty credit exposure reporting and liaise with IT developers.
• Plan and coordinate user testing (UAT), coordinate implementation and migration activities, and provide status updates to project leadership.
• Understand product attributes from upstream systems (Lending Products, Facilities, Securities, SFT, Derivatives).
• Communicate requirements to Development and QA teams; perform testing and assist with production implementations.
• Contribute to process reengineering and process improvement initiatives; support user training and documentation.

Skills

Regulatory reporting

Data mapping

SQL

Agile

SDLC

Documentation

UAT coordination

Education

Bachelor's degree

Math / CS / Engineering / Finance

Tools

Hive

MS SQL Server

Teradata

HUE

Dremio

Job description

The Business Analyst must have work experience in regulatory reporting and be familiar with RBC Capital Markets products, including Loans, Deposits, Nostro/Vostro, as well as client data domains such as Client Data Repository (CDR), Client Lifecycle Management (CLM), and Know Your Client (KYC), and booking data such as Booking Data Repository (BDR).

The project will work closely with teams in Asia, and working hours will be extensive. The candidate may be required to join calls in the early morning and late evening to accommodate time zone differences.

Preferred: Mandarin and/or Cantonese language skills.

Role Summary

The Business Analyst's responsibilities will include understanding counterparty credit exposure measurement for various products, mapping source data to internal monitoring and reporting (e.g., Counterparty Concentration Report), external regulatory reporting (e.g., Large Exposure Framework (LEF) and Single Counterparty Credit Limit (SCCL)), and supporting production-related activities.

The BA will primarily create mapping logic for counterparty credit exposure reporting, develop requirements documentation, and liaise with IT developers to communicate requirements. The role will also involve planning and coordinating user testing, coordinating implementation and migration activities, and providing written and verbal project status updates to the project leadership team and senior management throughout the project lifecycle.

What You Will Do

Understand various product attributes from upstream systems, including Lending Products, Facilities, Securities, Securities Finance Transactions (SFT), and Derivatives.

Quickly learn and apply new concepts, including LEF Risk Shifting for Credit Default Swaps (CDS), SFTs, Derivatives, Guarantees, and LC Fronting.

Perform data gap analysis across systems, processes, and procedures as required for the project.

Create reporting mapping logic and requirements documentation.

Communicate requirements to Development and QA teams.

Perform testing, coordinate UAT activities, and assist with production implementations.

Contribute to process reengineering and process improvement initiatives where applicable.

Support user training and documentation as needed.

Report BA team status and elevate concerns or issues that may impact project timelines to management and project managers.

What Do You Need to Succeed?

Must Have

Experience in systems implementation, process improvement, or systems reengineering projects within a banking organization or consulting company.

Undergraduate degree or higher, preferably in Mathematics, Computer Science, Engineering, or Finance.

Knowledge of SDLC methodologies, Agile, and related delivery frameworks.

Experience with SQL and data platforms, including Hive, MS SQL Server, Teradata, HUE, and Dremio.

Advanced proficiency in:

MS Word

MS Project

MS PowerPoint

MS Excel

Visio

MS Access

The pay range that the employer in good faith reasonably expects to pay for this position is $25.85/hour - $40.39/hour. Our benefits include medical, dental, vision and retirement benefits.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.