Freelance : Technical Business Analyst

TEKsystems; Carballedo; Presencial; EUR 30.000 - 50.000; A tiempo parcial

Descripción de la vacante

A leading technology firm is seeking a Technical Business Analyst for a project focused on Credit Risk Data in Carballedo, Spain. The role involves preparing financial analysis tools using Microsoft Excel and Visual Basic, updating Excel files for client data management, and executing initial data loads while ensuring data integrity. Expert use of Excel and understanding of financial analysis are crucial, with Python being a nice-to-have skill.

Formación

• Expert use of Microsoft Excel required.
• Experience with Visual Basic for financial analysis tools.
• Basic understanding of financial analysis is a plus.

Responsabilidades

• Prepare internal financial analysis tools for client data management.
• Update master Excel files to generate the required outputs.
• Execute initial data load and validate data integrity.

Conocimientos

Expert use of Microsoft Excel

Visual Basic

Python

Basic understanding of Financial Analysis

Descripción del empleo

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 Python.
• 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