Intermediate Business Analyst – Banking/VBA/SQL

4 weeks 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

  • Intermediate Business Analyst – Banking/VBA/SQL

    1 week ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Posting Title: Intermediate Business Analyst – Banking/VBA/SQLBusiness 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...

  • VBA Developer

    2 days ago

    Toronto, Canada CGI Full time

    Position Description: We are looking for a skilled Excel VBA Developer with 3+ years of experience in the investment or finance sector. The ideal candidate will have a proven track record of resolving execution issues with complex VBA scripts, transforming and enhancing VBA logic, and integrating SQL and Python to improve efficiency. Your future...

  • Analyst, Business Banking Product Analytics

    4 weeks ago

    Toronto, Canada BMO Financial Group Full time

    33 Dundas Street West Toronto Ontario,M5G 3C2 **The Analyst** is accountable to develop and deliver reporting, analytics, and measurement strategies in line with both immediate and long term Canadian P&C Business Banking (BB) Segment business objectives. **Specific Accountabilities** **Reporting Proposals** - Responsible to design reporting that is...

  • Business Analyst

    2 weeks ago

    Toronto, Canada Wafe consulting Full time

    Job Overview: We are seeking a skilled and detail-oriented Business Analyst to join our team. As a Business Analyst, you will be responsible for analyzing business processes, identifying areas for improvement, and implementing effective solutions. Your expertise in data analysis, project management, and various software tools will be crucial in driving...

  • Treasury Analyst, Manulife Bank of Canada

    2 months ago

    Toronto, Canada Manulife Full time

    **_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You’ve come to the right place. We’re looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the career below sounds exciting, we’d like to hear from you....

  • Intermediate Business Analyst, Data Mapping – PowerBI

    1 week ago

    Toronto, Ontario, 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...

  • Intermediate Business Analyst, Data Mapping – PowerBI

    2 months 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...

  • Intermediate Business Analyst, Data Mapping – PowerBI

    3 weeks 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 – IT

    2 months ago

    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 – IT

    2 months ago

    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 – IT

    2 months ago

    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 – IT

    3 weeks ago

    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 – IT

    3 weeks ago

    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

    2 weeks ago

    Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of **Business...

  • Business Systems Analyst with

    2 weeks ago

    Toronto, Canada Compest Solutions Inc Full time

    **Job title: Business Systems Analyst_ Bank domain** **Location: Hybrid 3 days mandatory in Toronto office** 10+ Years of Experience **Excellent English communication Mandatory skills**: SQL, Data Warehouse, Strong **Insurance **background **Job Description/ Responsibilities**: - Work closely with business users to understand business requirements -...

  • Analyst, Business Intelligence Systems

    1 week ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 194371 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **What your role will be** Analyst, Business Intelligence Systems The Analyst, Business Intelligence Systems is responsible for administering subvention and performance reporting for the Automotive Finance OEM programs offered by...

  • Senior SQL Database Analyst

    1 week ago

    Toronto, Ontario, Canada Procom Full time

    Senior SQL Database Analyst - AzureOn behalf of our client in the Banking Sector, PROCOM is looking for a Senior SQL Database Analyst - Azure.Senior SQL Database Analyst - Azure - Job DescriptionTaking ownership of and leading technical resolutions for production incidentsCommunicating clearly complex technical issues to stakeholders and Lines of Business...

  • Lead Business Analyst, Banking

    1 month ago

    Toronto, Canada CB Canada Full time

    Lead Business Analyst - Banking - Basel On behalf of our client in the Banking Sector, PROCOM is looking for a Lead Business Analyst - Banking - Basel. Lead Business Analyst - Banking - Basel – Job Description Works with key stakeholders within the regulatory capital reporting to test alignment of technology solutions with business requirements as well as...

  • Lead Business Analyst, Banking

    3 weeks ago

    Toronto, Canada CB Canada Full time

    Lead Business Analyst - Banking - Basel On behalf of our client in the Banking Sector, PROCOM is looking for a Lead Business Analyst - Banking - Basel. Lead Business Analyst - Banking - Basel – Job Description Works with key stakeholders within the regulatory capital reporting to test alignment of technology solutions with business requirements as well as...

  • Technical Business Analyst

    2 weeks ago

    Toronto, Canada Compest Solutions Inc Full time

    Request-ID:33030-1 10+ years previous work experience as a Business or Data Analyst, or in a technical/functional Role Experience working on Risk Data projects (Agile methodologies), sourcing, standardization, and aggregation of risk in one of the functional risk areas such as Counterparty/Credit Risk Understanding of financial Instruments including...