Talent.com
Intermediate Business Analyst – Banking/VBA/SQL
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
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 Analyst • Toronto, Ontario, Canada

    Similar jobs
    Senior Data BA

    Senior Data BA

    Capgemini • Toronto
    Full-time
    The role requires handling data analysis, migration, and quality assessment within financial services.The candidate will partner with technology teams and run SQL queries to extract insights and su...Show more
    Last updated: 1 day ago • Promoted
    Hybrid Data Analyst : Insights, SQL & BI for Growth

    Hybrid Data Analyst : Insights, SQL & BI for Growth

    Achievers • Toronto
    Full-time
    A leading employee recognition platform in Toronto is seeking a motivated individual to join their team as a Data Analyst. You will analyze datasets to identify trends impacting revenue and collabor...Show more
    Last updated: 6 hours ago • Promoted • New!
    Senior Enterprise Data Governance Analyst — Hybrid & Impact

    Senior Enterprise Data Governance Analyst — Hybrid & Impact

    EQ Bank | Equitable Bank • Toronto
    Full-time
    A leading Challenger Bank in Canada is seeking a Senior Analyst for Enterprise Data Governance.This role involves applying data governance policies, ensuring data quality throughout the lifecycle, ...Show more
    Last updated: 21 days ago • Promoted
    Capital Markets Data Analyst - 6mo Contract, SQL / Azure

    Capital Markets Data Analyst - 6mo Contract, SQL / Azure

    Recruit Action inc. • Toronto
    Full-time +1
    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
    Last updated: 21 days ago • Promoted
    Senior BI Analyst

    Senior BI Analyst

    Black & McDonald Limited • Markham
    Full-time
    Senior Business Intelligence (BI) Analyst.Black & McDonald’s Business Intelligence / IT team is growing! If you are a committed and collaborative professional looking to contribute to a hard-working,...Show more
    Last updated: 21 days ago • Promoted
    Senior SQL Server DBA - On-Prem to Azure Platform Lead

    Senior SQL Server DBA - On-Prem to Azure Platform Lead

    RBC • Toronto
    Full-time
    A leading financial institution in Toronto is seeking an experienced SQL Server DBA Specialist to ensure seamless database operations. The ideal candidate will have over 10 years of experience and a...Show more
    Last updated: 1 day ago • Promoted
    Consultant, Business Systems Analyst(Data Migration and SQL)

    Consultant, Business Systems Analyst(Data Migration and SQL)

    Project X • Toronto, ON, Canada
    Full-time
    We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and wants to see you grow. Our team members are trusted advisors to our clients and offer i...Show more
    Last updated: 14 days ago • Promoted
    Senior Analyst BI & Analytics

    Senior Analyst BI & Analytics

    Rogers Communications, Inc. • Toronto
    Full-time +1
    We are committed to connecting Canadians through unique partnerships, our world‑class network and content Canadians love—and our innovative team is growing. We are looking for dedicated team members...Show more
    Last updated: 21 days ago • Promoted
    Business System Analyst

    Business System Analyst

    Caspian One • Toronto
    Full-time
    Senior Business Systems Analyst – Core BankingLocation : Hybrid - 2 days a week downtown TorontoAbout the RoleWe are seeking a Senior Technical Business Systems Analyst (BSA) with strong experience ...Show more
    Last updated: 18 days ago • Promoted
    Associate, Business Analyst, Banking Products

    Associate, Business Analyst, Banking Products

    MUFG Investor Services • Toronto, ON, Canada
    Full-time
    MUFG Investor Services is a trusted partner to many of the world’s largest public and private funds, providing asset servicing and operational solutions built for alternatives.With over $1 tr...Show more
    Last updated: 30+ days ago • Promoted
    Senior Business Solutions Analyst — FinTech & Mobile Banking

    Senior Business Solutions Analyst — FinTech & Mobile Banking

    Kumaran Systems • Toronto
    Full-time
    A leading technology consulting firm in Toronto is seeking an experienced Senior Business Solutions Analyst with over 8 years of BSA experience, particularly in the financial industry.The role invo...Show more
    Last updated: 1 day ago • Promoted
    Senior Business Systems Analyst - SQL / wealth Mgmt.

    Senior Business Systems Analyst - SQL / wealth Mgmt.

    Talent To Hire Inc. • Toronto, ON, Canada
    Full-time
    Business Systems Analyst – Wealth Platform (Agile | API | Data Mapping).Domain : Wealth Management | Agile Delivery.Business Systems Analyst (BSA). Wealth Tech team delivering critical features...Show more
    Last updated: 30+ days ago • Promoted
    Senior BI & Analytics Analyst : Shape Go-to-Market Insights

    Senior BI & Analytics Analyst : Shape Go-to-Market Insights

    Rogers Communications • Toronto
    Full-time
    A leading telecommunications company in Toronto is seeking a Senior Analyst BI & Analytics to drive business insights and support decision-making. This role involves analyzing product impacts on sub...Show more
    Last updated: 21 days ago • Promoted
    Business Application Analyst (Workday)

    Business Application Analyst (Workday)

    ICONMA • Toronto
    Full-time
    Our Client, a Banking company, is looking for a Business Application Analyst (Workday) for their Toronto, ON / Hybrid location. Responsible for intake of projects and major initiatives.Responsible for...Show more
    Last updated: 1 day ago • Promoted
    Senior Delivery Governance Analyst – Business Banking

    Senior Delivery Governance Analyst – Business Banking

    TD • Toronto
    Full-time
    Une grande institution financière à Toronto recherche un Analyste principal en gestion des affaires.Le candidat idéal sera responsable de l'exécution stratégique et de la gouvernance des livraisons...Show more
    Last updated: 1 day ago • Promoted
    Oracle Senior Business Systems Analyst

    Oracle Senior Business Systems Analyst

    Aquanow • Toronto, Canada
    Full-time +1
    Aquanow is a trading and technology company powering the next generation of financial services.We’re at the forefront of the rapidly evolving digital asset space, empowering businesses to navigate ...Show more
    Last updated: 13 hours ago • Promoted • New!
    Senior eCommerce Data Analyst : SQL, Looker, Insights

    Senior eCommerce Data Analyst : SQL, Looker, Insights

    STAPLES Canada • Richmond Hill
    Full-time
    A leading retail company is looking for a Data Analyst to join their data science and analytics team.The role involves analyzing customer experience data, leveraging SQL and cloud tools for reporti...Show more
    Last updated: 1 day ago • Promoted
    Intermediate Database Developer

    Intermediate Database Developer

    Sym-Tech Dealer Services • Richmond Hill
    Full-time
    Opportunities to grow and develop your career.On-going industry training programs and professional development opportunities. A workplace that supports workplace diversity, equity and inclusion.A st...Show more
    Last updated: 30+ days ago • Promoted