Counterparty Risk Reporting Analyst

2 days left

London, United Kingdom
04 Mar 2023
03 Apr 2023
Job Function
Industry Sector
Finance - General
Employment Type
Full Time
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 early-warning-indicator and threshold-monitoring 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 cloud-based 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.