Technical Operations Analyst
TEKsystems
Municipality of Madrid, Spain
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Municipality of Madrid, Spain
Tech stack
Microsoft Excel
Python
Vba Programming Language
Job description
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.
- Update each of the master files (MIRA and LevFin Plus) for each client and develop required VBA or Python to ensure desired outputs are generated.
- Execute the initial data load by running macros for each client, ensuring the generated files flow to designated folders and that data matches the internal ADS application.
Requirements
- Expert use of Microsoft Excel including Visual Basic
- Python nice to have
- Basic understanding of Financial Analysis