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 BI Analyst

    Senior BI Analyst

    Black & McDonald Limited • Markham, ON, Canada
    Full-time
    Senior Business Intelligence (BI) Analyst.Black & McDonald's Business Intelligence / IT team is growing! If you are committed and collaborative professional looking to contribute to a hard-wo...Show more
    Last updated: 30+ days ago • Promoted
    Data Migration & SQL Analyst — Business Systems Specialist

    Data Migration & SQL Analyst — Business Systems Specialist

    Project X Ltd. • Toronto
    Full-time
    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
    Last updated: 17 days ago • Promoted
    Data Analyst – Power BI & SQL

    Data Analyst – Power BI & SQL

    Astra North Infoteck Inc. • Toronto, ON, ca
    Full-time
    Quick Apply
    Role : Data Analyst with strong technical and communication skills.This role involves working closely with business leads and executives to translate data into actionable insights.The ideal candidat...Show more
    Last updated: 15 days ago
    BI Data Architect & Analyst - SQL, ETL, Netezza

    BI Data Architect & Analyst - SQL, ETL, Netezza

    Virtusa • Toronto
    Full-time
    A leading technology services company in Toronto is seeking an experienced Business Analyst to analyze requirements and provide data transformations. The role involves converting business needs into...Show more
    Last updated: 6 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: 29 days ago • Promoted
    Business Application Analyst III

    Business Application Analyst III

    TD Bank • Toronto
    Full-time
    Work Location : • •Toronto, Ontario, Canada • •Hours : • •37.Line of Business : • •Enterprise Enabling Functions • •Pay Details : • •$69,700 - $98,400 CADTD is committed to providing fair and equitable compensatio...Show more
    Last updated: 8 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: 8 days ago • Promoted
    Business Data Analyst : SQL / Python | Onsite Toronto

    Business Data Analyst : SQL / Python | Onsite Toronto

    Mindlance • Toronto
    Full-time
    A data solutions provider is looking for a Business Data Analyst in Toronto, ON.The candidate will manage business and data analysis, designing data flows and quality monitors while collaborating w...Show more
    Last updated: 5 days 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: 21 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: 29 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 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: 29 days ago • Promoted
    Prime Services Business Analyst for Hedge Funds (Hybrid)

    Prime Services Business Analyst for Hedge Funds (Hybrid)

    Yochana • Toronto C6A, ON, Canada
    Remote
    Full-time
    A leading financial services firm in Toronto is seeking an experienced Business Analyst for its Prime Services division.The ideal candidate will have over 5 years of experience in Investment Bankin...Show more
    Last updated: 6 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: 8 days ago • Promoted
    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: 8 days 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
    Senior Analyst BI & Analytics

    Senior Analyst BI & Analytics

    Rogers Communications • 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: 29 days ago • Promoted
    Senior Genesys Cloud CX Business Analyst

    Senior Genesys Cloud CX Business Analyst

    Miratech • Toronto, ON, Canada
    Full-time
    Miratech helps visionaries change the world.We are a global IT services and consulting company that brings together enterprise and start-up innovation. Today, we support digital transformation for s...Show more
    Last updated: 30+ days ago • Promoted