Counterparty Risk Reporting Analyst
2 days left
- Recruiter
- Finance Network
- Location
- London, United Kingdom
- Salary
- Negotiable
- Posted
- 04 Mar 2023
- Closes
- 03 Apr 2023
- Ref
- 18944007
- Job Function
- Accounting/Audit/Tax
- Industry Sector
- Finance - General
- Employment Type
- Full Time
- Education
- Bachelors
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
Person Spec
Technical Skills
Job Experience
- 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.