Talent.com
CB Canada
Intermediate Business Analyst – Banking/VBA/SQLCB Canada • Toronto, Ontario, Canada
Intermediate Business Analyst – Banking/VBA/SQL

Intermediate Business Analyst – Banking/VBA/SQL

CB Canada • Toronto, Ontario, Canada
30+ days ago
Salary
CA$60.00 hourly
Job type
  • Full-time
Job description

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
Create a job alert for this search

Intermediate Business Analyst – Banking/VBA/SQL • Toronto, Ontario, Canada

Similar jobs

Data Migration & SQL Analyst — Business Systems Specialist

Project X Ltd.Toronto, ON, CA
Full-time

A leading technology solutions provider in Toronto seeks a Consultant, Business Systems Analyst.This role involves collaborating with stakeholders to develop and implement tailored data solutions f... Show more

 • Promoted

Senior Business Analyst - Hybrid (Azure/Agile)

Rubicon PathToronto, ON, CA
Full-time

A leading consulting firm in Toronto is seeking a Senior Business Analyst.The role involves leading business analysis to assess client needs, developing strategies, and ensuring effective project m... Show more

 • Promoted

Experienced Maximo Business Analyst Role

Gilder Search GroupToronto, ON, CA
Full-time

Contribute to significant IT implementation projects as an Experienced Maximo Business Analyst at Bevertec in Toronto, with a flexible hybrid model.Your skills in IBM Maximo will be key to success.... Show more

 • Promoted

Senior Business Systems Analyst

ProcomToronto, ON, CA
Temporary

On behalf of our Banking client, Procom is searching for a Senior Business Systems Analyst for a 12-month role.This position is a hybrid position with 2 days onsite at our client’s Toronto office.T... Show more

 • Promoted

Azure-Driven Business Systems Analyst - Hybrid Toronto

Global Technical Talent, an Inc. 5000 CompanyToronto, ON, CA
Full-time

A leading technology workforce provider in Toronto is seeking a Business Systems Analyst to support the enhancements of the Messaging Back Office application.This role is crucial for Azure migratio... Show more

 • Promoted

Strategic Business Systems Analyst in Banking with API Expertise

Soroc TechnologyToronto, ON, CA
Full-time

Elevate your career as a Strategic Business Systems Analyst specializing in Payments, Fraud, and AML.Drive critical requirements management for complex technology initiatives while collaborating wi... Show more

 • Promoted

Business Analyst - Intermediate 26-10657

Russell TobinToronto, ON, CA
Full-time

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.Business Analyst - Intermediate.BRD, FRD, NFRs, user stories, and acceptance criteria across complex enterprise environ... Show more

 • Promoted

Business Analyst - SAP

Tech Talent InternationalToronto, ON, CA
Full-time

Duration: 6 months to start + potential extension.Location: Toronto, ON - Hybrid - 2-3 days/week onsite.Rate: $80 -$100 CDN/hr C2C depending on overall experience.Job Description: We are looking fo... Show more

 • Promoted

Business Systems Analyst - Agile and Mainframe

TekStaff IT SolutionsToronto, ON, CA
Full-time

Elevate your career as a Business Systems Analyst at MCA, where your engineering mindset and Mainframe experience will drive innovation in banking systems.Collaborate effectively with key stakehold... Show more

 • Promoted

Business Analyst - Intermediate (HYBRID) JP215

PathlionToronto, ON, CA
Full-time

We are looking for a highly skilled and dynamic Business Analyst / Product Owner to bridge the gap between business needs and technical solutions.In this dual role, you\'ll be instrumental in defin... Show more

 • Promoted

Business Analyst - Intermediate JP215

P@thlion Staffing CareersToronto, ON, CA
Full-time

We are looking for a highly skilled and dynamic Business Analyst / Product Owner to bridge the gap between business needs and technical solutions.In this dual role, you\'ll be instrumental in defin... Show more

 • Promoted

Jonas Software BI Analyst with SQL Expertise

Jonas Club SoftwareMarkham
Full-time

Take on the Development Analyst role with Jonas Software's Business Intelligence team, using your skills in SQL and AWS QuickSight to develop insightful BI solutions.This position focuses on buildi... Show more

 • Promoted

Senior Business Analyst: API, Azure DevOps, Power BI

Source CodeToronto, ON, CA
Temporary

A technology solutions provider in Ontario is seeking a Sr.Business Analyst for an 11-month contract with possible extensions.Responsibilities include requirements gathering, document API integrati... Show more

 • Promoted

Business Analyst - Banking, Agile & Data-Driven

Onico SolutionsRichmond Hill, York Region, CA
Full-time

A financial services company in Richmond Hill is seeking an Intermediate Business Analyst to bridge development teams and stakeholders.The role involves analyzing business requirements, facilitatin... Show more

 • Promoted

Core Banking Senior Analyst Role

ScotiabankToronto, ON, CA
Full-time

Excel as a Senior Programmer Analyst at Scotiabank, focusing on innovative technology solutions in Core Banking Engineering.This position allows you to impact Canadian Banking systems significantly... Show more

 • Promoted

Business System Analyst

Insight GlobalGreater Toronto Area, ON, CA
Full-time

Insight Global is seeking a Senior Project Analyst/BSA to join a leading bank in Downtown Toronto within their Securities division.The role requires advanced data manipulation skills to analyze lar... Show more

 • Promoted

Senior Business Systems Analyst - SQL / wealth Mgmt.

TEEMA Solutions GroupToronto, ON, CA
Full-time

Business Systems Analyst – Wealth Platform (Agile | API | Data Mapping).We’re looking for a Business Systems Analyst (BSA) to join a fast-moving Wealth Tech team delivering critical features for a ... Show more

 • Promoted

Senior SQL/Oracle DBA - Onsite Toronto (Contract)

BevertecToronto
Full-time

A technology solutions provider in Toronto is seeking a Senior Database Administrator with expertise in SQL and Oracle.The role involves performance tuning, storage optimization, and managing repli... Show more

 • Promoted

Business Analyst And Lead - Oracle - Up To $110,000 A Year

IT ConnexToronto, Canada
Full-time

Supports business applications project leads in planning, designing, developing, and launching efficient business systems, gathering data for requirements, and generating reports for systems analysis. Show more

 • Promoted

Senior Banking API & Data Contracts Analyst

Tata Consultancy ServicesToronto, ON, CA
Full-time

A leading IT consulting firm in Toronto is seeking experienced candidates for a position involving defining KPIs, documenting debt collection journeys, and collaborating on API contracts.Applicants... Show more