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 • Toronto, Ontario, Canada
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
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
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
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
Business System Analyst (Azure).Toronto ON (3 days onsite in a week).Responsibilities & Qualifications.Experience working on Azure Databricks.Experience in SQL server and PySpark as legacy system h... Show more
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
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
Business group: Technology Program Management & Transformation – team that manages cloud data integration and governance for IB, providing efficient and standardised solutions that enable different... Show more
A recruitment agency is seeking a Business Data Analyst for a hybrid role in Toronto.This position involves leading data-driven initiatives within the insurance and wealth management sector.Candida... Show more
Business Analyst and Project Manager needed to analyze customer processes, design Zoho solutions, manage projects, and lead the team. Show more
Contract (potential for Extension).Perform manual content testing to ensure accuracy and consistency across all pre-sign-on pages.Validate that mockups match live pages precisely and align with des... Show more
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
A leading staffing firm in Toronto is looking for an IT Business Analyst for a full-time position with a large financial client.Responsibilities include interviewing end users to document business ... Show more
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
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
A Senior Business Analyst role focusing on Business Intelligence projects.Responsibilities include gathering requirements, supporting BI projects, and mentoring team members, with a focus on proces... Show more
Seeking a Senior Business Analyst to engage stakeholders, document needs, and ensure IT alignment with business strategies.Responsibilities include testing, communication, and supporting project im... Show more
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
Business Analyst/Business System Analyst.Established in 1991, Collabera is one of the fastest growing end-to-end information technology services and solutions companies globally.As a half a billion... Show more
Iris’s leading financial client is looking for a Business System Analyst with Banking to join their team in Toronto, ON (Hybrid) location.Job TitleBusiness System Analyst with BankingLocationToront... Show more
