Intermediate Business Analyst – Banking/VBA/SQL

Found in: Talent CA 2 C2 - 7 days ago


Toronto, Canada CB Canada Full time

Job Posting Title: Intermediate Business Analyst – Banking/VBA/SQL

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.

Candidate Requirements/Must Have Skills:
1) 3+ years as a 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

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.

Education:
- Undergraduate degree in business, finance or computer science is required
- MBA, CFA or accounting designation is an asset

Typical Day in Role:
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
  • Business Analyst

    7 days ago


    Toronto, Canada Atlantis IT group Full time

    **Role: Business Analyst - Retail Banking** **Location: Toronto, ON** **Duration - Long Term** Overall experience of 10+ in Business Analysis BA - Deposits (Retail) Banking Experience min of 5 years Strong in knowledge in **Retail** **Banking** (Account, Deposits and Loans) Experience in Data Migration projects Experience in Data Mapping Experience...

  • Intermediate Business Analyst, Data Mapping – PowerBI

    Found in: Talent CA 2 C2 - 7 days ago


    Toronto, Canada CB Canada Full time

    Intermediate Business Analyst - Data Mapping - PowerBI On behalf of our client in the Banking Sector, PROCOM is looking for an Intermediate Business Analyst - Data Mapping - PowerBI. Intermediate Business Analyst - Data Mapping - PowerBI – Job Description End to end project regarding wire mapping and data integration mapping, international wire processing...

  • Business Analyst

    Found in: Jooble CA O C2 - 1 week ago


    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Business Analyst x 2 Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...

  • Business Analyst

    Found in: Jooble CA O C2 - 1 week ago


    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Business Analyst Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need • Business group: The CRM GWRT Technology team is looking for a Support Analyst/BA to join the ongoing Capital Markets Salesforce Integration.• Project: We are the GBM Salesforce team responsible for providing best practices and leadership over development activities for the CRM platform. The team supports many different business...

  • Senior Business Analyst

    Found in: Jooble CA O C2 - 1 week ago


    Toronto, ON, Canada ProViso Staffing Full time

    Story Behind the Need • Business group: The CRM GWRT Technology team is looking for a Support Analyst/BA to join the ongoing Capital Markets Salesforce Integration. • Project: We are the GBM Salesforce team responsible for providing best practices and leadership over development activities for the CRM platform. The team supports many different business...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need • Business group: The CRM GWRT Technology team is looking for a Support Analyst/BA to join the ongoing Capital Markets Salesforce Integration.• Project: We are the GBM Salesforce team responsible for providing best practices and leadership over development activities for the CRM platform. The team supports many different business...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need • Business group: The CRM GWRT Technology team is looking for a Support Analyst/BA to join the ongoing Capital Markets Salesforce Integration.• Project: We are the GBM Salesforce team responsible for providing best practices and leadership over development activities for the CRM platform. The team supports many different business...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst x 2 Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst x 2 Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Business Analyst x 2 Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...

  • Business Analyst x 2

    Found in: Jooble CA O C2 - 1 week ago


    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Business Analyst x 2Typical Day in Role: 1. Documentation - Create, update, and maintain business requirement document of different products for liquidity risk cashflow engine to generate cashflows used in LST reporting - Update and maintain product mapping table from liquidity risk data feeds to cashflow generation module. - Create, update, and maintain...

  • Senior Technical Business Analyst

    Found in: Talent CA C2 - 1 week ago


    Toronto, Canada Lorven Technologies Full time

    Job Title: Senior Technical Business Analyst Location Remote (Canada) Job Type: Contract (Incorporated/ T4) General Skills: We are looking for people who can be autonomous in driving the required assigned tasks, flexible in their role, ready to acknowledge any knowledge gap, and ramp up quickly. Accountable, responsible and proactiveness are...


  • Toronto, Canada CB Canada Full time

    Business Analyst, Banking/Capital Markets – Regulatory Data Reporting Business Analyst - Banking/Capital Markets - Regulatory Data Reporting On behalf of our client in the Banking Sector, PROCOM is looking for a Business Analyst - Banking/Capital Markets - Regulatory Data Reporting. Business Analyst - Banking/Capital Markets - Regulatory Data Reporting...

  • Business Analyst

    1 week ago


    Toronto, Canada Delpath Full time

    Typical Day in Role: • The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources...

  • Business Analyst

    1 week ago


    Toronto, Canada Delpath Full time

    Typical Day in Role: • The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources...

  • Business Analyst

    1 week ago


    Toronto, Canada Delpath Full time

    Typical Day in Role: • The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources...