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
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... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
A financial services company is seeking a highly proficient SAS Analyst in downtown Toronto.The role involves developing complex data analysis, creating Power BI dashboards, and optimizing SQL quer... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
Business group: Technology Program Management & Transformation – team that manages cloud data integration and governance for IB, providing efficient and standardised solutions that enable different... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
Iris's Direct client, a highly diversified financial services provider based in Canada is looking to hire a.Business Analyst – Foreign Exchange.Experience with payment modernization: real-time paym... Voir plus
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... Voir plus
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... Voir plus
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... Voir plus
