Business Analyst - SQL & UAT

Story Behind the Need:

• 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.

Candidate Value Proposition:

• The successful candidate will have the opportunity to work in a growing field in the banking industry.

Typical Day in Role:

• Documentation:
o Create, update, and maintain business requirement documents of different products for liquidity risk cashflow engine to generate cashflows used in LCR and NSFR reporting
o Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module.
o Create, update, and maintain product mapping logic from source system to liquidity risk data provisioning and enrichment layer
• Data Analysis and testing:
o Review various data mappings along the liquidity risk data flow and understand the data structures along with the mappings.
o Write SQL queries for data mining.
o Write UAT test cases.
o Conduct UAT of data provisioned to support LCR and NSFR migration.
o Conduct UAT of LCR and NSFR contractual cashflows generated from liquidity risk cashflow engine.
o Conduct UAT of LCR and NSFR reports generated from the reporting layer.
• Relationship Management:
o Collaborate and build rapport with the Project Manager, other Business Analysts, reporting analysts, and IT partners.
o Work with IT partners to help translate users’ requests into technical specifications, when necessary

Candidate Requirements/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.

Candidate Review & Selection:

• 1 round of interview: 1st round – Business Lead Director and Project Manager/Lead BA – 15 Mins – MS Teams Video – The first 15 minutes is for Introduction, role overview, and what we are looking for the rest of the interview the manager will ask business questions and talk about previous experience based on the resume.