Intermediate Data Analyst - Review various data mappings along the liquidity risk data flow - 27425
Job Type: Contract
Positions to fill: 1
Start Date: Oct 10, 2022
Job End Date: Apr 09, 2023
Pay Rate: Hourly: Negotiable
Job ID: 123444
Location: Toronto
Data Analyst
Location Address: 40 King Street W – hybrid as of Nov. (2x a week in office)
Contract Duration: 6 months - Possibility of extension
Business group: The Liquidity Regulatory Reporting team is responsible for reporting and managing liquidity and funding risk for the Bank.
Project: The incumbent will work with project manager, developer and IT partners to implement daily new undrawn commitment reports.
Responsiblities:
1. 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 undrawn commitment report changes.
- Conduct UAT of undrawn commitment records generated from liquidity risk cashflow engine.
- Conduct UAT of undrawn commitment report generated from reporting layer.
2. Documentation
- Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in undrawn commitment 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
3. Relationship Management
- Collaborate and build rapport with 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:
1) 3+ years as a Data/Business Analyst
2) Basic knowledge in VBA and SQL, and Microsoft advanced functions.
3) Experience with conducting UAT on data intensive reporting implementations involving technology changes.
Nice-To-Have Skills:
1) Good knowledge of banking products, as well as liquidity risk reporting preferred.
2) Exposure to liquidity cashflow generator would be an asset.
3) Advance expertise in MS Office suite of products
Education:
- Undergraduate degree in business, finance or computer science is required
- MBA, CFA or accounting designation is an asset
Location Address: 40 King Street W – hybrid as of Nov. (2x a week in office)
Contract Duration: 6 months - Possibility of extension
Business group: The Liquidity Regulatory Reporting team is responsible for reporting and managing liquidity and funding risk for the Bank.
Project: The incumbent will work with project manager, developer and IT partners to implement daily new undrawn commitment reports.
Responsiblities:
1. 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 undrawn commitment report changes.
- Conduct UAT of undrawn commitment records generated from liquidity risk cashflow engine.
- Conduct UAT of undrawn commitment report generated from reporting layer.
2. Documentation
- Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in undrawn commitment 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
3. Relationship Management
- Collaborate and build rapport with 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:
1) 3+ years as a Data/Business Analyst
2) Basic knowledge in VBA and SQL, and Microsoft advanced functions.
3) Experience with conducting UAT on data intensive reporting implementations involving technology changes.
Nice-To-Have Skills:
1) Good knowledge of banking products, as well as liquidity risk reporting preferred.
2) Exposure to liquidity cashflow generator would be an asset.
3) Advance expertise in MS Office suite of products
Education:
- Undergraduate degree in business, finance or computer science is required
- MBA, CFA or accounting designation is an asset
