Intermediate Business Analyst – Banking/VBA/SQL

2 weeks ago

Toronto, Ontario, 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 problemsolving 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:

  • 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.
  • 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
  • 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, Data Mapping – PowerBI

    2 weeks ago

    Toronto, Ontario, 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...

  • Senior SQL Database Analyst

    2 weeks ago

    Toronto, Ontario, Canada Procom Full time

    Senior SQL Database Analyst - AzureOn behalf of our client in the Banking Sector, PROCOM is looking for a Senior SQL Database Analyst - Azure.Senior SQL Database Analyst - Azure - Job DescriptionTaking ownership of and leading technical resolutions for production incidentsCommunicating clearly complex technical issues to stakeholders and Lines of Business...

  • Analyst, Business Intelligence Systems

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Requisition ID: 194371Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.What your role will beAnalyst, Business Intelligence SystemsThe Analyst, Business Intelligence Systems is responsible for administering subvention and performance reporting for the Automotive Finance OEM programs offered by Automotive...

  • Business Analyst, Banking/Capital Markets – Regulatory Data Repo

    2 weeks ago

    Toronto, Ontario, Canada CB Canada Full time

    Business Analyst, Banking/Capital Markets – Regulatory Data Reporting Business Analyst - Banking/Capital Markets - Regulatory Data Reporting 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...

  • Data Analyst, Model Risk Reporting

    2 weeks ago

    Toronto, Ontario, Canada Procom Full time

    Data Analyst, Model Risk Reporting (Python/SQL/VBA)On behalf of our client in the Banking Sector, PROCOM is seeking a skilled Data Analyst, Model Risk Reporting (Python/SQL/VBA).Role:Act as a subject matter expert to support MRG in the daily operation of the model inventory system and risk management reportingBuild solutions for Enterprise Model Risk...

  • Senior Technical Business Analyst- Remote

    2 weeks ago

    Toronto, Ontario, Canada Lorven Technologies Full time

    Job Title: Senior Technical Business Analyst Location Remote (Canada) Job Type: Contract (Incorporated/ T4) General Skills: We are looking for people who can be autonomous in driving the required assigned tasks, flexible in their role, ready to acknowledge any knowledge gap, and ramp up quickly. Accountable, responsible and proactiveness are...

  • Business Analyst- Intermediate

    2 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Are you a Business Analyst- Intermediate looking for a new opportunity?Are you looking for a new contract opportunity?We are pleased to offer you a new contract opportunity for you to consider: Business Analyst- IntermediateStart: ASAPEstimated length: 12 monthsLocation: TorontoHybrid role Mondays & First Friday of each month.Advantages You will have an...

  • Business Analyst

    3 weeks ago

    Toronto, Ontario, Ontario, Canada Robert Half Full time

    Our client is looking for a Business Analyst for a 3 months contract, hybrid opportunity in downtown Toronto. If you have the below requirements, please apply today!• Minimum 4-6 years’ business analysis experience (intermediate to senior level)• Exposure to subscription management services applications• Experience dealing with stakeholders in...

  • Urgent- IT Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada Apptoza Inc. Full time

    Sign in to save Business System Analyst at Apptoza Inc. . We have a job opening for a Business Analyst (BSA), if you are interested please apply for the job Role: Business Analyst (BSA)Contract: 12 months we are looking for candidates who have strong experience in Hadoop, Big Data, SQL, Google Data Seniority level Mid-Senior level Employment type...

  • Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada Finance Professionals Inc. Full time

    The Senior Analyst in charge of providing operational and technical support for Global Banking Markets will play a crucial role in the team.Responsibilities:The Senior Analyst, Special Processing Support Services will be responsible for the full system life cycle management including analysis, technical requirements, design, testing, and implementation of...

  • Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada Finance Professionals Inc. Full time

    The Senior Analyst provides all aspects of operational and technical support for Global banking Markets.What You'll Do: The Senior Analyst, Special Processing Support Services will provide full system life cycle management (analysis, technical requirements, design, testing and implementation) and support of the bank's Corporate Lending System.The core duties...

  • Intermediate Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada Seneca Full time

    Position Summary The Intermediate Business Analyst (IBA) provides business process and systems proficiency in relation to ERP and college business activity and information technologies. The IBA interactively works across functional areas with the service provider and business stakeholders to define the current and planned business processes, detailing...

  • Senior Business Process Solutions Analyst

    2 weeks ago

    Old Toronto, Ontario, Canada Scotiabank Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Title: Senior Business Process Solutions Analyst Requisition ID: 200637Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. As a Senior Business Process and Solutions Analyst, you will be responsible for support and...

  • Intermediate Compliance analyst

    2 weeks ago

    Toronto, Ontario, Canada Robertson & Company Ltd. Full time

    ***Please note before applying: We require Mandarin speaking as a MUST-HAVEPosition: Intermediate Compliance AnalystLocation: Markham, Ontario, Canada (Hybrid- 3 days ONSITE)Type: Full time permanentMandarin-speaking candidates required **Upto $70-80K year + BonusOur Client:Our client is an International Bank with Canadian operations across major cities...

  • Business Analyst

    2 weeks ago

    Old Toronto, Ontario, Canada Finance Professionals Inc. Full time

    The Senior Analyst provides all aspects of operational and technical support for Global banking Markets.What You'll Do: The Senior Analyst, Special Processing Support Services will provide full system life cycle management (analysis, technical requirements, design, testing and implementation) and support of the bank's Corporate Lending System. The core...

  • Senior Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Requisition ID: 201580Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Senior Business Analyst contributes to the overall success of the Department in Canada by ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team's business strategies and objectives....

  • stages business analyst bi

    2 weeks ago

    Toronto, Ontario, Canada S I Systems Full time

    Intermediate Business Analyst to improve wire payments processes with one of our major banking clients- BNSJP Intermediate Business Analyst to improve wire payments processes with one of our major banking clients- BNSJP Location Address: Scarborough– 1-2 days/per week in the office Contract Duration: ASAP to 10/31/2024 (Possibility of extension &...

  • Business Analyst

    2 weeks ago

    Toronto, Ontario, Canada CRC Full time

    Need Help?- Accessibility_- (accommodation requests only; other inquiries won't receive a response)._Regular or Temporary:RegularLanguage Fluency: English (required)Work Shift:1st Shift (Canada)Please review the following job description:The Reinsurance Business Analyst is responsible for supporting Operations through the identification and implementation of...

  • Intermediate Business Intelligence Analyst to migrate Power BI Report Server solutions to Power

    2 weeks ago

    Toronto, Ontario, Canada S I Systems Full time

    Intermediate Business Intelligence Analyst to migrate Power BI Report Server solutions to Power BI Services for our public sector client (Req 330)Job Type: Contract Our public sector client is seeking a Intermediate Business Intelligence Analyst to migrate Power BI Report Server solutions to Power BI Services Candidates can be 100% remote in Canada...

  • business analyst

    2 weeks ago

    Old Toronto, Ontario, Canada Epsilon Solutions Ltd. Full time

    Business Analyst Location: Toronto (Hybrid)Responsibilities 8 + years of overall IT experience Combined experience in Financial Domain + Data Analytics (SQL)/Data Mapping Very strong in SQL/Retrieving data sets from various tables. Have a good understanding of Banking domain & Regulatory requirements. Experience in Banking applications/projects - AML, Credit...