Junior Business Analyst, MS Excel

4 weeks 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 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,...


  • Toronto, Canada Randstad Canada Remote Work Freelance Full time

    Are you a Junior Business Analyst 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: Junior Business Analyst-Start: ASAP-Estimated length: 18 months-Location: Toronto-Hybrid role, onsite twice a week.Advantages- You will have an opportunity to work with a...


  • Toronto, Canada Randstad Canada Remote Work Freelance Full time

    Are you a Junior Business Analyst 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: Junior Business Analyst-Start: ASAP-Estimated length: 18 months-Location: Toronto-Hybrid role, onsite twice a week.Advantages- You will have an opportunity to work with a...


  • Toronto, Ontario, Canada Randstad Canada Full time

    Are you a Junior Business Analyst 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: Junior Business AnalystStart: ASAPEstimated length: 18 monthsLocation: TorontoHybrid role, onsite twice a week.Advantages You will have an opportunity to work with a leading...


  • 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...


  • 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...

  • Junior MS Developer

    2 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Technical Support Analyst On behalf of our client in the Banking Sector, PROCOM is looking for a Technical Support Analyst. Technical Support Analyst – Job Description Meaningful work is fueled by meaningful performance and career development conversations with your manager Transform business requirements and research into winning delivery solutions that...

  • Junior Analyst

    1 month ago


    Toronto, Canada AppleOne Full time

    North York Junior Analyst (Promotions Analyst) Position Summary: Promo Analytics the incumbent is responsible with weekly P&L and Compliance reporting. Supporting Manager, Merchandising and promotions, the incumbent creates and transmits promotional events communications for stores. The incumbent also oversees the co-ordination of various order...


  • Toronto, ON, Canada Hays Full time

    Utilities Sector Role: Business Analyst Job Type: Contract Our client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city. Our client is looking for a Contractor, Business Analyst to be a liaison for both technical and business stakeholders. The...

  • Lead, IT Analyst

    2 weeks ago


    Toronto, Ontario, Canada MS Canada Full time

    Are you someone who is passionate about the work that you do? Do you want your next adventure to be part of a great cause? If so, look no further than MS Canada Our team is looking for a Lead, IT Analyst on a full-time basis working 35 hours per week. We support flexible work options including remote work where possible; with some in-person meetings based on...


  • 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...

  • Junior Analyst

    2 weeks ago


    Toronto, Ontario, Canada AppleOne Full time

    North York Junior Analyst (Promotions Analyst)Position Summary:Promo Analytics the incumbent is responsible with weekly P&L and Compliance reporting. Supporting Manager, Merchandising and promotions, the incumbent creates and transmits promotional events communications for stores. The incumbent also oversees the co-ordination of various order generations and...

  • Junior Risk

    4 weeks ago


    Toronto, Canada Questrade Financial Group Full time

    Questrade Financial Group (QFG) of Companies is committed to helping Canadians become much more financially successful and secure. We are everything a traditional financial institution is not. Our vision is to revolutionize financial services for the benefit of Canadians by providing the most innovative and cost efficient financial services online. That’s...


  • 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...


  • Toronto, Canada Hays Full time

    Client : Utilities Sector Role: Business Analyst Job Type: Contract Rate: Open *depending on experience Location: Hybrid Role in Toronto Your new Company Our client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city. Your Role & Responsibilities ...


  • Toronto, Canada Hays Full time

    Client: Utilities SectorRole: Business AnalystJob Type: ContractRate: Open *depending on experienceLocation: Hybrid Role in TorontoYour new CompanyOur client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city.Your Role & ResponsibilitiesDescription:Our client is...


  • Toronto, Canada Hays Full time

    Client: Utilities SectorRole: Business AnalystJob Type: ContractRate: Open *depending on experienceLocation: Hybrid Role in TorontoYour new CompanyOur client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city.Your Role & ResponsibilitiesDescription:Our client is...


  • toronto, Canada Hays Full time

    Client: Utilities SectorRole: Business AnalystJob Type: ContractRate: Open *depending on experienceLocation: Hybrid Role in TorontoYour new CompanyOur client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city.Your Role & ResponsibilitiesDescription:Our client is...


  • Toronto, Canada Hays Full time

    Client: Utilities SectorRole: Business AnalystJob Type: ContractRate: Open *depending on experienceLocation: Hybrid Role in TorontoYour new CompanyOur client owns and operates an electricity distribution system that delivers electricity to approximately 80,000 customers in one of Canada's largest city.Your Role & ResponsibilitiesDescription:Our client is...


  • Toronto, Canada Eurofins Canada BioPharma Full time

    **Company Description** **_ Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins works with the...