Junior Business Analyst, MS Excel

Found in: Talent CA 2 C2 - 5 days 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, Canada Dawn InfoTek Inc. Full time

    institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. **We are currently seeking competent individuals to fulfill the role of Junior Business Analyst** **to join our dynamic team for our client, one of the major...

  • Junior Tax Analyst, Tax Slips

    Found in: Talent CA 2 C2 - 5 days ago


    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

    6 days ago


    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...


  • Toronto, Canada COPERNICUS LODGE Full time

    **Job description** Copernicus Lodge is a healthcare organization that provides for a continuum of care to primarily polish seniors. We are located in the heart of Roncesvalles Village just west of downtown Toronto. We have 200 seniors’ apartments with a Supportive Housing program, 228 Long Term Care beds and an Adult Day Program. We are looking for a...


  • Toronto, Canada Kingstar Media Full time

    **Job Title** Junior Media Research Analyst **Reports to** Director, Media & Analytics **Location** Toronto, ON (hybrid work model) **Deadline** August 29th, 2023 **Background** Kingstar Media is Canada’s fastest growing full-service Performance Marketing Agency, located in Toronto’s historic Distillery District, is looking for a full-time,...


  • Toronto, Canada Kingstar Media Full time

    **Job Title** Junior Media Research Analyst **Reports to** Director, Media & Analytics **Location** Toronto, ON (hybrid work model) **Deadline** August 29th, 2023 **Background** Kingstar Media is Canada’s fastest growing full-service Performance Marketing Agency, located in Toronto’s historic Distillery District, is looking for a full-time,...


  • Toronto, Canada ydc pro Inc Full time

    Hi All, We are Hiirng for **MS Dynamics Business Analyst **Position for Toronto Location work type: Contract and Hybrid Client: Ministry Exp: 7+ Years Must Haves: - At least 5+ years of experience of software quality assurance and testing experience, in an Agile/SDLC environment - Demonstrated experience in implementing and integrating **Microsoft...

  • Junior IT Security Analyst, Networks

    Found in: Talent CA 2 C2 - 5 days ago


    Toronto, Canada CB Canada Full time

    Junior IT Security Analyst - Networks On behalf of our client in the Banking Sector, PROCOM is looking for a Junior IT Security Analyst - Networks. Junior IT Security Analyst - Networks – Job Description Identify security issues and risks, and provide recommendation of mitigation plans Govern the deployment of data security controls that mitigate and...

  • Junior Data Analyst

    5 days ago


    Old Toronto, Canada Sage City Full time

    Sage Vacancy Junior Data Analyst #sagecareers Sage Vacancy Junior Data Analyst #sagecareers sage careers Applicant PortalJob Details: Junior Data Analyst Full details of the job. Job Title Junior Data Analyst Job Description The Junior Data Analyst role will form an important part of the Data & Insights team to build a...

  • Junior Data Analyst

    2 weeks ago


    Old Toronto, Canada Sage City Full time

    Sage Vacancy Junior Data Analyst #sagecareers Sage Vacancy Junior Data Analyst #sagecareers sage careers Applicant PortalJob Details: Junior Data Analyst Full details of the job. Job Title Junior Data Analyst Job Description The Junior Data Analyst role will form an important part of the Data & Insights team to build a...


  • Toronto, Canada 123Dentist Full time

    123Dentist is Canada's oldest and largest dentist-owned network of dental practices with more than 425 locations nationwide and more than 5,000 employees and growing. We provide Canadian dentists and dental practices with an array of non-clinical support and resources, including accounting, HR, marketing, as well as supply & equipment procurement. By...


  • Old Toronto, Canada Horizon Media Inc. Full time

    Junior Data Analyst, Strategy & Insights page is loaded Junior Data Analyst, Strategy & Insights Apply locations Toronto time type Full time posted on Posted 4 Days Ago job requisition id R0014278 Job Description The Junior Data Analyst will support the business across a range of data collection initiatives along with...

  • Junior Data Analyst, Strategy

    Found in: Jooble CA O C2 - 7 days ago


    Toronto, ON, Canada Horizon Media Inc. Full time

    Junior Data Analyst, Strategy & Insights page is loaded Junior Data Analyst, Strategy & Insights Apply locations Toronto time type Full time posted on Posted 4 Days Ago job requisition id R0014278 Job Description The Junior Data Analyst will support the business across a range of data collection initiatives along with analysis, and visualization of...


  • Old Toronto, Canada Horizon Media Inc. Full time

    Junior Data Analyst, Strategy & Insights page is loaded Junior Data Analyst, Strategy & Insights Apply locations Toronto time type Full time posted on Posted 4 Days Ago job requisition id R0014278 Job Description The Junior Data Analyst will support the business across a range of data collection initiatives along with...


  • Old Toronto, Canada Horizon Media Inc. Full time

    Junior Data Analyst, Strategy & Insights page is loaded Junior Data Analyst, Strategy & Insights Apply locations Toronto time type Full time posted on Posted 4 Days Ago job requisition id R0014278 Job Description The Junior Data Analyst will support the business across a range of data collection initiatives along with...

  • Business Analyst

    Found in: Talent CA 2 C2 - 5 days ago


    Toronto, Canada CB Canada Full time

    Position Title: CAN - Business Analyst II# of positions: 1Start Date: Nov 1stCost Center: 9508Business Unit: 2 - Platforms & Technology (S_0003239)Duration: 1 yearExtension possible: yesConversion Possible: yesSchedule: M-F 8:30-5Rotation Schedule: noOT: occasionallyInterview Process: 1 round, WebexWork Location (Remote, Hybrid or Both?): 320 Front Street...

  • Senior Business Analyst, Plan Operations

    Found in: Talent CA C2 - 5 days ago


    Toronto, Canada Healthcare of Ontario Pension Plan Full time

    Why you’ll love working here:high-performance, people-focused cultureour commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selvesmembership in HOOPP’s world class defined benefit pension plan, which can serve as an important...

  • Business Process Analyst

    Found in: JG CA C2 - 3 days ago


    Toronto, Canada Procom Full time

    Business Process Analyst - Capital Markets On behalf of our client in the Banking Sector, PROCOM is looking for a Business Process Analyst - Capital Markets. Business Process Analyst - Capital Markets - Job DescriptionThis junior-level role is perfect for individuals keen on developing their career within the financial services sector, particularly in...

  • Business Analyst IV

    Found in: beBee jobs CA - 7 days ago


    Toronto, Ontario, Canada IFG International Financial Group Ltd Full time

    Our client, a large financial institution, is looking for a Business Analyst IV to fill a 7-month contract located in Toronto. This is an excellent opportunity for a business analyst with a financial services background. Please note this position is currently a hybrid work arrangement requiring 3 days in office. As a Business Analyst IV your duties will...

  • Business Analyst

    4 days ago


    Toronto, Canada Risus Talent Partners Full time

    Position: Business Analyst Location: Brampton, ON, CA Hours: 8:00 - 4:30 (4 days in, 1 day WFH) Educational/Training Requirements/Experience (What your background should look like) Bachelor's Degree, certification, or equivalent experience in computer science, finance, or business administration. 1-2 years of direct experience as a business...