Junior Business Analyst, MS Excel

5 months ago


Toronto, Canada CB Canada Full time

Junior Business Analyst - MS Excel - Tax/Lending

On behalf of our client in the Banking Sector, PROCOM is looking for a Junior Business Analyst - MS Excel - Tax/Lending.

Junior Business Analyst - MS Excel - Tax/Lending – Job Description

  • Tax Module - solution analysis to implementation stages: Validation and reconciliation of data from ACBS to Tax module, and LIQ to Tax module, when possible

  • Meet up challenges (unseen) on post GOLIVE of newly developing Tax module

  • Testing of different reports (Detail, Upload, Master deal agented, etc.) from the perspective of static data; will be assisting with BAU

  • Work with LIQ project team to validate Data Migration from ACBS to LIQ system

  • Identify gaps within static fields on a large spread sheet, extract provided by LIQ project team

  • Investigate ACBS to understand static info and confirm Data Integrity in order to input in LIQ system

  • Conduct UAT testing as required for the GO-LIVE of system migration

  • Involved with project-related work as required by the manager

  • Work with the Manager to resolve highly complex, multi-faceted problems to meet the business needs of GWO, Front Office and Middle Office with a specific focus on creating measurable/qualitative improvements relating to static data setup for counterparties

  • Delivery client experience and data accuracy for all counterparties across different source systems maintained by GWS Static Data that is continuously growing

  • Assist income amount both from ACBS and LIQ for filing IRS Tax report for the year 2021

  • Maintain Tax Module for maintenances of IRS tax static data for Loan Syndication customers

  • Reconciliate tax fields required between ACBS and Tax Module

  • Liaise with existing counterparty set-up operations groups, GWO, Front Office and GCMD to clarify data errors / inconsistencies

  • Contact with other departments for counterparty related issues and champion continuous improvement initiatives that support the optimal function for the businesses that we support

  • Performing new lender/borrower set up and static data validation and maintenance

  • Perform customer setup maintenances and verify/mapping/capture pertinent information to the related sub-systems

  • Document standard operating procedures (SOPs) to maintain the standard set of rules.

  • Contribute/participate in user acceptance testing activities for ongoing system enhancements or implementation of new systems

  • Contribute to the protection of the Bank from exposure to loss by ensuring compliance with Bank policies/procedures and regulatory requirement

  • Review daily email requests from the business lines and liaise with technology and other departments for improvements in the process

  • Perform any other duties as needed to support the desk smoothly as per need of Manager/Higher management

  • Able to do overtime as needed at short notices or as per need of the desk

Junior Business Analyst - MS Excel - Tax/Lending – Mandatory Skills

  • 1+ year experience as a Business Analyst, preferably within banking

  • Demonstrated expert Excel skills (vLookups, data comparison, macros) and overall good MS Office skills

  • Team player

  • Eager to learn

  • Can take ownership

  • Strong communication skills

  • Strong analytical skills

  • Post-secondary degree - preferably in business or equivalent

Junior Business Analyst - MS Excel - Tax/Lending - Nice to Have Skills

  • Experience with ACBS/Loan IQ or equivalent lending systems

  • Background in accounting/taxes an asset

Junior Business Analyst - MS Excel - Tax/Lending - Assignment Start Date

ASAP – 12 months to start

Junior Business Analyst - MS Excel - Tax/Lending - Assignment Location

Toronto, ON – Work Hybrid



  • Toronto, Ontario, Canada Randstad Full time

    Financial Services Junior Analyst OpportunityWe are seeking a highly motivated and detail-oriented Junior Analyst to join our team in Toronto. As a Junior Analyst, you will have the opportunity to work with a leading organization and gain valuable experience in the financial services industry.Key Responsibilities:Assist in the analysis and reporting of...


  • Toronto, Ontario, Canada CB Canada Full time

    Job Title: Junior Detection AnalystRobert Half is seeking a highly motivated and detail-oriented Junior Detection Analyst to join our team at one of Canada's top banks. As a Junior Detection Analyst, you will be part of a project reviewing bank transactions to ensure compliance with Canadian and International banking standards.Key Responsibilities:Review and...


  • Toronto, Ontario, Canada CB Canada Full time

    Job Title: Junior Detection AnalystRobert Half is seeking a highly motivated and detail-oriented Junior Detection Analyst to join our team at one of Canada's top banks. As a Junior Detection Analyst, you will be part of a project reviewing bank transactions to ensure compliance with Canadian and International banking standards.Key Responsibilities:Review and...


  • Toronto, Ontario, Canada Randstad Full time

    Exciting Opportunity for a Junior AnalystWe are seeking a highly motivated and detail-oriented Junior Analyst to join our team in Toronto. As a Junior Analyst, you will play a key role in supporting our clients in the Financial Services industry.Key Responsibilities:Assist in the analysis and review of financial data and reportsConduct research and provide...


  • Toronto, Ontario, Canada Randstad Full time

    Exciting Opportunity for a Junior AnalystWe are seeking a highly motivated and detail-oriented Junior Analyst to join our team in Toronto. As a Junior Analyst, you will play a key role in supporting our clients in the Financial Services industry.Key Responsibilities:Assist in the analysis and review of financial data and reportsConduct research and provide...

  • Junior Tax Analyst

    1 month ago


    Toronto, Ontario, Canada CB Canada Full time

    Junior Tax Analyst, Tax Slips AdministrationCB Canada is seeking a detail-oriented Junior Tax Analyst to join our team in Toronto, ON. As a Junior Tax Analyst, you will be responsible for maintaining accurate records for investors of various Investment Companies.Key Responsibilities:Maintain records for investors of various Investment CompaniesProvide...

  • Junior Tax Analyst

    1 month ago


    Toronto, Ontario, Canada CB Canada Full time

    Junior Tax Analyst, Tax Slips AdministrationCB Canada is seeking a detail-oriented Junior Tax Analyst to join our team in Toronto, ON. As a Junior Tax Analyst, you will be responsible for maintaining accurate records for investors of various Investment Companies.Key Responsibilities:Maintain records for investors of various Investment CompaniesProvide...

  • Junior Tax Analyst

    4 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Junior Tax Analyst, Tax Slips AdministrationCB Canada is seeking a detail-oriented Junior Tax Analyst to join our team in Toronto, ON. As a Junior Tax Analyst, you will be responsible for maintaining accurate records for investors of various investment companies.Key Responsibilities:Maintain records for investors of various investment companiesProvide...

  • Junior Tax Analyst

    4 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Junior Tax Analyst, Tax Slips AdministrationCB Canada is seeking a detail-oriented Junior Tax Analyst to join our team in Toronto, ON. As a Junior Tax Analyst, you will be responsible for maintaining accurate records for investors of various investment companies.Key Responsibilities:Maintain records for investors of various investment companiesProvide...

  • Business Analyst

    1 month ago


    Toronto, Ontario, Canada Randstad Full time

    Business Analyst OpportunityWe are pleased to offer a new contract opportunity for a Business Analyst to join our team.Key Responsibilities:Interfacing directly with clients to analyze business needsWorking with a leading employer in the local marketHybrid role with 3 days in office and 2 days remoteWhat You Will Gain:Opportunity to work with a reputable...

  • Business Analyst

    1 month ago


    Toronto, Ontario, Canada Randstad Full time

    Business Analyst OpportunityWe are pleased to offer a new contract opportunity for a Business Analyst to join our team.Key Responsibilities:Interfacing directly with clients to analyze business needsWorking with a leading employer in the local marketHybrid role with 3 days in office and 2 days remoteWhat You Will Gain:Opportunity to work with a reputable...


  • Toronto, Canada CB Canada Full time

    Junior Tax Analyst, Tax Slips AdministrationOn behalf of our client in the Banking Sector, PROCOM is looking for a Junior Tax Analyst, Tax Slips AdministrationJunior Tax Analyst, Tax Slips Administration – Job DescriptionResponsible for maintaining the records for investors of various Investment Companies that offer investments such as Mutual, Segregated...

  • Business Analyst

    4 weeks ago


    Toronto, Ontario, Canada Randstad Canada Full time

    Junior Business Analyst Job DescriptionWe are seeking a highly motivated and detail-oriented Junior Business Analyst to join our team at Randstad Canada. As a Junior Business Analyst, you will play a key role in supporting our clients by analyzing business needs and developing solutions to drive growth and efficiency.Key Responsibilities:Collaborate with...

  • Business Analyst

    4 weeks ago


    Toronto, Ontario, Canada Randstad Canada Full time

    Junior Business Analyst Job DescriptionWe are seeking a highly motivated and detail-oriented Junior Business Analyst to join our team at Randstad Canada. As a Junior Business Analyst, you will play a key role in supporting our clients by analyzing business needs and developing solutions to drive growth and efficiency.Key Responsibilities:Collaborate with...


  • Toronto, Canada Sinai Health Full time

    Sinai Health is looking for a client focused Junior Analyst who is aligned with our purpose to join our Finance team. Reporting directly to the Manager of Accounts Payable, the Junior Analyst will play a key role in supporting the Finance team with our Finance integration and transformation roadmap. The Junior Analyst will support Finance Leadership and our...


  • Toronto, Canada Rakuten Kobo Full time

    Job Description: - Rakuten Kobo Here at Rakuten Kobo Inc., our mission is to make reading lives better. We stand for readers. We also stand for our employees - from interns and co-ops to permanent staff - and support their growth and development. Whether you are a student at the start of your career or a professional carving a different path, our early...


  • Toronto, Canada Spectrum Health Care Full time

    Company Description Spectrum Health Care is hiring a **Junior Patient Experience Analyst** for our corporate office in **Toronto**. As a **Junior Patient Experience Analyst**, you will be responsible for completing patient surveys and analyzing and interpreting the data for stakeholders. This role is for you if: - You are customer service superstar - You...

  • Business Analyst

    3 weeks ago


    Toronto, Ontario, Canada Randstad Full time

    Business Opportunities Are you a skilled Business Analyst looking for a new challenge? We are pleased to offer a new contract opportunity for a Business Analyst to work with a leading employer in the local market. Key Responsibilities: • Interfacing directly with clients to analyze business needs • Collaborating with cross-functional teams to...


  • Toronto, Ontario, Canada Randstad Full time

    Business Analyst OpportunityWe are pleased to offer a new contract opportunity for a Business Analyst to join our team.Key Responsibilities:Interfacing directly with clients to analyze business needsWorking with a leading employer in the local marketHybrid role with 3 days in office and 2 days remoteWhat You Will Gain:Opportunity to work with a reputable...


  • Toronto, Ontario, Canada Randstad Full time

    Business Analyst OpportunityWe are pleased to offer a new contract opportunity for a Business Analyst to join our team.Key Responsibilities:Interfacing directly with clients to analyze business needsWorking with a leading employer in the local marketHybrid role with 3 days in office and 2 days remoteWhat You Will Gain:Opportunity to work with a reputable...