Story Behind the Need:

• Business Unit: The Global Cash Management team is working on a large scale migration project. Moving data from their current platform to a new in house tool.
• Project: Liquidity Risk Reporting team is responsible for reporting and managing liquidity and funding risk for the Bank. The incumbent will work with project manager, developer and IT partners to implement migration of LCR and NSFR regulatory and business line reports.

Candidate Value Proposition:

• The successful candidate will have the opportunity to work within one of the Top 5 Banking Institutions in Canada. You’ll get to work with and learn from diverse industry leaders all over the globe, who have hailed from top technology companies around the world.

Typical Day in Role:

• BAU monthly defects support:
o Collaborate with the reporting team to clarify, create and update the business requirements for the defects identified.
o Work with the IT team to ensure the functional specifications are in line with the business requirements.
o Perform User Acceptance Testing (UAT) to ensure the changes are implemented as per the requirements.
o Perform regression testing to support the monthly defects releases.
• Liquidity Risk Reporting Project Support:
o Understand the data structures along with the mappings and review various data mappings along the liquidity risk data flow.
o Write UAT test cases.
o Conduct UAT of data provisioned to support LCR migration.
o Conduct UAT of LCR contractual cashflows generated from liquidity risk cashflow engine.
o Conduct UAT of LCR report generated from reporting layer.
• Documentation Support:
o Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LCR report.
o Create, update, and maintain product mapping logic from source system to liquidity risk data provisioning and enrichment layer.
o Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module.
• Relationship Management:
o Collaborate and build rapport with 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:

• 5+ years as a Business Analyst
• Knowledge of banking products, as well as liquidity risk reporting required
• Experience with conducting UAT on data intensive reporting implementations involving technology changes
• Advanced knowledge in VBA, SQL and Microsoft Excel advanced functions.
• Advance expertise in MS Office suite of products.

Nice to Have:

• Prior Financial Institution Experience
• Experience with large data programing preferred.
• Exposure to liquidity cashflow generator would be an asset.

Soft Skills:

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

Education:

• Undergraduate degree in business, finance or computer science is required
• MBA, CFA or accounting designation is an asset.

Best vs Average:

• The ideal candidate would have liquidity risk reporting experience as well as have prior experience with large data programing. A large part of the project will revolve around UAT so someone with a proven track record with UAT is preferred.

Candidate Review & Selection:

• Initial 1st round interview – hiring manager (1 hour)
• 2nd round interview – 45 to an hour