Search jobs > Toronto, ON > Intermediate analyst

Intermediate Business Analyst – Banking/VBA/SQL

CB Canada
Toronto, Ontario, Canada
$60 an hour (estimated)
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
  • 30+ days ago
Related jobs
CB Canada
Toronto, Ontario

Job Posting Title: Intermediate Business AnalystBanking/VBA/SQL. Collaborate and build rapport with Project Manager, other Business Analysts, reporting analysts and IT partners. Basic knowledge in VBA and SQL, and Microsoft advanced functions. Good knowledge of banking products, as well as liquid...

Foilcon
Toronto, Ontario

Experience and nbsp;withand nbsp;a and nbsp;wide and nbsp;range and nbsp;of andnbsp;methods and nbsp;tools and nbsp;and and nbsp;techniques andnbsp;for and nbsp;business and nbsp;analysis and nbsp;such andnbsp;as: and nbsp;business and nbsp;functional and nbsp;modellingand nbsp;business and nbsp;eve...

S.i. Systems
Toronto, Ontario

Business Analyst to develop new initiatives and business processes for a major banking client -. Lead research and analysis projects that will contribute to the overall efficiency of the business unit from a products, service and workflow perspective;. Assist teams or individuals in the development ...

E-Solutions
Mississauga, Ontario

Role: Business Analyst (Python & SQL ). Act as a senior Business Analyst with previous experience working in Financial Services, governance and metadata management tools. The Business Analyst will work in a team setting to gather requirements on various metadata management tools and to support gover...

International Financial Group
Toronto, Ontario

Our client, a Top 5 bank in Canada is looking to hire an Intermediate Business Analyst to their team for an initial 3-month contract. The ideal candidate will gain experience with different applications within commercial banking:. Previous commercial banking experience. ...

CB Canada
Toronto, Ontario

On behalf of our client in the Banking Sector, PROCOM is looking for a Business Analyst - Banking/Capital Markets - Regulatory Data Reporting. Business Analyst, Banking/Capital Markets – Regulatory Data Reporting. Business Analyst - Banking/Capital Markets - Regulatory Data Reporting. Business Analy...

S.i. Systems
Toronto, Ontario

Intermediate Business Intelligence Analyst to migrate Power BI Report Server solutions to Power BI Services. Business Intelligence users/developers. ...

Scotiabank
Toronto, Ontario

Bridge the gap between business and IT, ensuring common understanding and IT/Business alignment of both functional (for business needs) and non-functional requirements (such as reporting, performance, interfaces, and constraints. Business Systems Analyst in a challenging IT system solution environme...

S.i. Systems
Toronto, Ontario

Intermediate Records Management Business analyst. The main function of a Business Analyst is to perform the analysis, design, implementation, modification, and daily functional support of all applications. Line of Business: Enterprise Risk Management – Risk Data Management Office. ...

Procom
Mississauga, Ontario

The Business Analyst I is responsible for managing data files, conducting reconciliations, and other business analysis activities in consultation with business-facing partners and stakeholders to enable informed, evidence-based, operational and strategic decisions . On behalf of our client in the Re...