*THIS IS A FREELANCING ROLE*
Project: Credit Risk Data – Phase 2. The objective of this project is to create a data repository that will enable the Credit Risk monitoring of the leveraged finance transactions portfolio.
Role and Task Descriptions:
Technical Business Analyst who is expert in MS Excel, Visual Basic and/or Python to work with Leveraged Finance Underwriting team to:
Prepare “MIRA” and “LevFin Plus”, which are internal financial analysis tools built in MS Excel, to deliver the Client’s Financial Statements related data to feed the new Credit Risk Data repository.
There will be a master excel file “MIRA” and a master excel file “LevFin Plus”. There will be at least one “MIRA” excel and one “LevFinPlus” excel per client. The Technical Business Analyst must update each of those excel files to secure they are able to generate the desired output. Which will require development in Visual Basic or Prython.
The Technical Business Analyst will then execute the initial data load, which implies executing the macro for each client and securing that the file generated flows to the designated folders and validating that the data sent coincides with the data stored in an internal application called ADS.
Candidate Must-Have Skills, Requirements and Nice-to -Have Skills:
Expert use of Microsoft Excel including Visual Basic
Python nice to have
Basic understanding of Financial Analysis