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