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.
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
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.
Internal Number: 18944007
eFinancialCareers is a career site specializing in financial services.