Counterparty Risk Reporting Analyst - London, United Kingdom - eFinancialCareers

eFinancialCareers

Verified Company

London, United Kingdom

5 days ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

You'll be taking on the production and increasing automation of multiple counterparty-risk monitoring reports and dashboards, and helping to strengthen our data ETL processes and capabilities.

In particular, you will be

Overseeing the daily extraction and transformation of data from multiple sources (including relational databases, flat files, xml files etc.), dealing with any errors or issues that arise.
Preparing daily earlywarningindicator and thresholdmonitoring Excel reports; refreshing data in Qlikview and PowerBI dashboards and other tools used by the team for risk analysis.
Improving reporting and dashboarding as new requirements emerge, automating the final preparation of Excel reports where possible.
Helping with increasing the robustness and automation of our Alteryx data pipeline and with the migration to a more robust Python solution. This will include improving data validation and completion checks, automated testing, fixing bugs, improving documentation,and increasing parallelisation.
Helping to specify requirements for a cloudbased strategic platform and working with development teams to ensure success.

Person Spec
Technical Skills

Experienced using Alteryx for data extraction, transformation, and analysis
Excellent Excel skills (preferably with some VBA knowledge, but not essential)
Experience with Python, in particular for dealing with data: (pandas, numpy etc)
Experience querying relational database using SQL
Preferably experience with Qlikview and/or Power BI

Job Experience

Reporting and data analysis experience in a financial function, preferably in credit or market risk on derivatives products
Experience with ETL in Alteryx and preferably Python.