• Skip to primary navigation
  • Skip to main content
  • Skip to footer

1.844.822.0541

info@nexusgroup.ca

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

Business Analyst- Power BI

May 31, 2022 by

Business Analyst- Power BI

Story Behind the Need
Converting loan documents, credit agreements, from LIBOR (London Interbank Offered Rate) rates to SOFR (Secured Overnight Financing Rate) as per regulator’s guidance to decommission the LIBOR rates.

Typical Day in Role:
• Monitor conversions to ARR loans to ensure they are correctly processed – Review ACBS reports daily to identify any incorrectly booked RFR loans, Follow up with LOB to correct any issues identified
• Assist with review of credit agreements to ensure they comply with industry guidelines: Read credit agreement to verify that all reference to terminated LIBOR loans have been removed or appropriate fallback language is included and that all required information for booking RFR loans are included
• Investigate escalated BRR related inquiries such as accrual issues, booking issues, GL mapping issues and Issues which identify gap in system requirements and require system enhancement
• Perform UAT for monthly code change projects in ACBS related to BRR functionality; Liaise with Technology to coordinate UAT, Prepare test plan and test scripts, Conduct UAT in accordance with test plan
• Liaise with banking partners on BRR related issues – Technology, Product Control, Regulatory Initiatives
•Investigate Audit Inquiries – Investigate and follow up with LOB with regards to questions raised by Audit on a monthly basis, Provide data to audit team to assist with review of RFR data, Provide data to audit team to assist with review of outstanding LIBOR loans
•Assist GWO teams with booking ARR loans and creating/ restricting loan templates – Provide guidance and assist GWO Loan Ops teams with creating ARR loan templates and booking ARR loans as needed
•Track all loans outstanding under LIBOR templates and verify that the credit agreement has the appropriate amended language – Monitor and investigate that existing LIBOR loans are being actively reviewed and will transition in the given timeline
•Liaison with Regulatory Initiatives team for the creation of macro calculator – Provide requirements to enable assigned Reg. Initiatives team member to build macro calculator to assist with verification of accruals; Conduct testing to identify issues
•Update and maintain BRR SOP – Ensure BRR SOP is updated monthly with fixes and new processes
•Assist in ongoing projects related to Benchmark Rate Reform

Candidate Requirements/Must Have Skills:
1) 2-3 years Business Analyst experience
2) Entry level knowledge of lending corporate services and credit agreements
3) Power BI experience – Proven ability to develop matrices ideally in Power BI, if not with strong Excel skills, to be able to analyze and present data in a concise way

Nice-To-Have Skills:
1) Experience with ACBS
2) Experience with Loan IQ

Soft Skills Required:
• A high level of interpersonal and verbal communication skills
• Strong self-starter, quick learner
• Ability to analyze and manipulate data and translate to stakeholders
• Strong presentation skills

Education:
Undergraduate degree

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Procurement Consultant – Senior August 18, 2022
  • Jr. Software Engineer/ Python- Linux August 18, 2022
  • Software Engineer August 18, 2022
  • Accessibility Program Manager August 18, 2022

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy