Intermediate Business Analyst – Banking/VBA/SQL

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

  • Toronto, Canada S.I. SYSTEMS Full time

    Location Address: Hybrid (Office Downtown Toronto) Contract Duration: 8 Months + extension (likely) Business Group: The Enterprise Risk Management Solutions team provides risk based analysis to multiple high profile groups throughout the Bank. Typical Day in the Role: - Attending working sessions with the team regarding project updates - Conducting Data...


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


  • Toronto, Canada InfoTek Consulting Full time

    **Business Systems Analyst - Expert - JOB-27378** Prospective Start Date: 07 Oct 2024 Prospective End Date: 06 Apr 2025 Location: Toronto, Physical Presence: Hybrid One to two days in the office Job Title: IT - Business Systems Analyst - Expert Position Title: Business Systems Analyst Line of Business: Foreign exchange technology. Duration: 6...

  • Business Analyst

    15 hours 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...

  • Business Analyst

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


  • Toronto, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for an Intermediate Business Analyst with strong Mutual Funds experience:The BA will work within a project team ensuring all tasks assigned to them are completed thoroughly, accurately and within assigned time frames. Activities include data analysis, impact analysis, process analysis, preparing detailed documentation of...

  • Business Analyst Iv

    4 weeks ago


    Toronto, Canada Robertson and Company Full time

    Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking. Introduction: Robertson is seeking a skilled Business Analyst to join our client. Contract Dates: 6...


  • Toronto, Ontario, C6A, Ontario, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for an Intermediate Business Analyst with strong Mutual Funds experience:The BA will work within a project team ensuring all tasks assigned to them are completed thoroughly, accurately and within assigned time frames. Activities include data analysis, impact analysis, process analysis, preparing detailed documentation of...


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


  • Toronto, Canada Astra North Infoteck Inc. Full time

    Description: Business System analysis, SQL skills Competencies: Business Analysis, Usability Analysis and Evaluation Techniques Experience (Years): 6-8 Essential Skills:Business system analyst, Wealth and Journeys experience, Agile background, banking experience, JIRA, Confluence, MS Visio and other BSA toolsDesirable Skills:Advanced to Expert knowledge of...


  • Toronto, Canada Apex Systems Full time

    We are seeking an experienced Business Analyst to join our team at Apex Systems, a global IT services provider. As a Business Analyst with Apex Systems, you will work on banking regulatory projects and utilize your skills in SQL queries to pull data.The ideal candidate will have 5+ years of experience as a Business Analyst, knowledge of working on banking...

  • Business Analyst

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


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


  • Toronto, Canada Compest Solutions Inc Full time

    **Job title**:Business Systems Analyst Bank domain **Location: Hybrid in Toronto (2 days a week in office).** **Max Rate CAD$49/hr on T4** **Job summary** BSA We need a strong BSA preferably in Toronto (2 days a week in office). Should be good in **data mapping, able to write basic SQL queries** to do data analysis, and have basic **understanding of...


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

  • Business Analyst

    4 months ago


    Toronto, Canada Atlantis IT group Full time

    **Role**: Business Analyst **Location**: Toronto **Role Description**: Business System analysis, SQL skills **Competencies**: Business Analysis, Agile Way of Working **Experience (Years)**: 8-10 **Essential Skills**: Business system analyst, Agile background, banking experience, Credit experience


  • 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 Experience: 8 -10+ Yrs **Job Description/ Responsibilities**: - Work closely with business users to understand...


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


  • Toronto, Canada Sumitomo Mitsui Banking Corporation Full time

    **Role Description**: The Analyst will also assist in managing the credit portfolio through on-going monitoring and reporting of asset quality. **Role Objectives**: - Participate in the negotiation, structuring, and execution of new transactions and ancillary products (derivatives, DCM, trade finance, etc.) - Participate in the due diligence of new...

  • Business Analyst

    4 weeks ago


    Toronto, Canada Compest Solutions Inc Full time

    **Job title**:Business System Analyst **Client**: Bank Domain **Location**: 3 day Hybrid in Toronto **Position Type-Regular** Full-Time Contract **Max CAD$40/hr on Inc** **Please reply** with your **expected Contract range--** 1. Experience with **Confluence, Jira.** 2. Experience with **ORM function, previous work experience as a Risk Specialist i**s...