Senior Business/Data Analyst to implement a migration of LCR and NSFR regulatory and business line reports.33969

Description:

Location Address: 40 Temperance Street 9th Floor- 2 for now per week in the office (Mandatory), 3 days per week coming soon.

Contract Duration: ASAP to 5/30/2025

Business group: Global Cash Management

Liquidity Regulatory Reporting team is responsible for reporting and managing liquidity and funding risk for the Bank.

Project: The incumbent will work with the project manager, developer and IT partners to implement a migration of LCR and NSFR regulatory and business line reports. Project delivery is expected in 2025.

Responsibilities:

1. Documentation

- Create, update, and maintain business requirement documents of different products for liquidity risk cashflow engine to generate cashflows used in LCR and NSFR reporting

-Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module.

- Create, update, and maintain product mapping logic from source system to liquidity risk data provisioning and enrichment layer

2. Data Analysis and testing

- Review various data mappings along the liquidity risk data flow and understand the data structures along with the mappings.

- Write SQL queries for data mining.

- Write UAT test cases.

- Conduct UAT of data provisioned to support LCR and NSFR migration.

- Conduct UAT of LCR and NSFR contractual cashflows generated from liquidity risk cashflow engine.

- Conduct UAT of LCR and NSFR reports generated from the reporting layer.

3. Relationship Management

- Collaborate and build rapport with the Project Manager, other Business Analysts, reporting analysts, and IT partners.

- Work with IT partners to help translate users’ requests into technical specifications, when necessary

Must Have Skills:

10+ years of experience conducting UAT on data-intensive reporting implementations involving technology changes.

10+ years of experience using SQL

10+ years of experience with MS Office suite of products.

7 + years of experience working with banking products, as well as liquidity risk reporting required.

3+ years of experience working with VBA, and Microsoft advanced functions.

Nice-To-Have Skills:

Experience with large data programming preferred.

Exposure to liquidity cashflow generator would be an asset.

Soft Skills Required:

Creative, results-oriented, highly motivated individual with excellent analytical and problem-solving skills, with the ability to apply knowledge to independently and effectively resolve complex business problems.

Strong communication (written & verbal) and interpersonal skills to facilitate working with colleagues at all levels of the organization.

Ability to work in a dynamic environment, manage multiple deadlines and priorities.

Adaptable working as part of a team or independently with minimum supervision.• Exceptional leadership skills to review processes and procedures to create efficiencies, eliminate duplication and provide organizational support to achieve business objectives.

Strong relationship management with an ability to establish productive relationships between various leaders, departments, and partners across the organization.

Solutions-oriented and ability to develop and create innovative solutions to critical business or organizational data issues

Strong analytical skills with amplitude for generating insights through an evidence-based thought process

Sound judgment, learning agility, and a high level of professional and personal integrity

Excellent communication (written and verbal) and interpersonal skills

Education:

An undergraduate degree in business, finance or computer science is required

- MBA, CFA or accounting designation is an asset.

Best vs. Average Candidate

The best candidate is someone who is a quick learner and proactive, who is an expert with SQL, and someone who can demonstrate hands-on experience right away based on the experience in the resume.