Typical Day in Role
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
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.