This job has expired

You will need to login before you can apply for a job.

Counterparty Risk Reporting Analyst

Finance Network
London, United Kingdom
Closing date
Apr 5, 2023

View more

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.

Sign in to create job alerts

Sign in or create an account to start creating job alerts and receive personalised job recommendations straight to your inbox.

Create alert