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
English

Job 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

Apply for this position