Risk Reporting / Analytics Manager

Sterling Williams are supporting an International Bank based in the City of London in their search for a Risk Manager - this role sits in their 2nd line of defence, Risk Management department with a particular focus on developing and enhancing the risk calculation tools and reporting using tools such as Python, Power BI, VBA and SQL.

Risk Reporting/Analytics Manager - Python/Power BI

City of London based (Hybrid)

Permanent; full-time

Salary circa £80 - 105,000 pa plus competitive benefits.

The role is responsible for supporting the Risk Management function through the development and enhancement of risk calculation tools and reporting capabilities, including the migration of selected Excel-based VBA and SQL functionality to Python and Power BI. The role focuses on improving the efficiency, accuracy and reliability of risk analysis and reporting across market, Liquidity and Credit Risk, while supporting new products, business initiatives and continued development of the department’s technical capabilities. The bank is preparing to introduce Power BI into its Risk Management Reporting environment. As such, extensive hands-on Power BI experience is a key requirement for this role. The successful candidate will play a key role in developing and implementing Power BI reporting solutions, including migrating selected existing reporting functionality and ensuring the accuracy, consistency and reliability of reporting outputs.

Risk Management Operations:

• Maintain and document RM databases used across Market, Liquidity and Credit Risk, as well as Product Control.
• Perform data integrity checks and data cleansing on RM databases, investigating discrepancies and implementing appropriate corrective actions to improve data quality and reporting accuracy.

Risk Systems Development and Enhancement:

• Develop and enhance Risk Management databases to enhance and expand on risk metrics used by the team for monitoring and reporting within the branch and externally.
• Migrate selected functionality from Excel-based VBA and SQL into Python, verifying results against existing outputs to ensure accuracy and consistency and documenting the functionality.
• Convert selected reporting from Excel-based VBA and SQL into Power BI, verifying results to ensure consistency and accuracy with existing reporting outputs, and documenting the functionality.
• Test systems and reporting for new products and new business initiatives across all business lines to ensure appropriate capture, valuation and calculation of risk metrics, and develop existing branch databases as required to support these changes.
• Test functionality relating to branch system projects, including new systems and system upgrades, to ensure that changes operate as intended and produce accurate and consistent outputs.

The successful candidate will have:

• Degree-level qualification in Computer Science, Information Technology, Data Analytics, Mathematics, Statistics, Finance or another relevant quantitative or technical discipline, or equivalent relevant professional experience.
• Relevant professional certifications in data analytics, database management, programming or business intelligence, such as Microsoft Power BI certifications, Microsoft Azure data certifications, Oracle database certifications or other relevant technical qualifications are desirable.
• Minimum of 5 years relevant experience in banking or financial services environment, covering Risk Management, risk systems, database development and maintenance, programming, data analytics and reporting.
• Hands on experience with Python, VBA, SQL and Power BI is required.
• Working knowledge of relevant financial services regulatory requirements and their implications for risk reporting, data quality and controls.
• Strong working knowledge of treasury products, across multiple asset classes, principally linear products.
• Strong working knowledge of Market Risk Management processes within the branch, including methodologies, reporting and information flows.
• Strong working knowledge of risk controls, limits, Value at Risk (VaR), pricing and Profit and Loss (P&L), including their application in risk monitoring and reporting.
• Strong numeral and analytical skills, with the ability to interpret complex data, investigate discrepancies, identify root causes and draw sound conclusions.
• Proficient in Microsoft Word and Excel, including advance Excel functionality and the ability to work with complex spreadsheets and existing VBA-based processes.
• Proven practical experience in Python and VBA, including independently developing, maintaining, enhancing and troubleshooting calculations, analytical tools and automated processes.
• Proven practical and hands-on experience in Power BI and DAX, including developing, enhancing and maintaining reports, dashboards and data visualisations.
• Strong practical knowledge and experience in relational database development, maintenance and documentation, including data extraction and manipulation using SQL.
• Practical experience with Oracle OL/SQL and R-SQL.
• Ability to develop, implement and maintain data validation, integrity and reconciliation controls, investigate discrepancies, and implement corrective actions to improve data quality and reporting accuracy.
• Demonstrated experience enhancing or migrating legacy Excel/VBA and SQL functionality to more robust solutions, including validating outputs, documenting functionality and resolving implementation issues.
• Strong organisational and time management skills, with the ability to prioritise competing demands, manage deliverables independently and meet agreed deadlines.
• Ability to take ownership of technical deliverables, work independently, coordinate activities and support the effective delivery of team objectives.
• Ability to establish objectives, plan and prioritise activities, manage competing requirements and implement solutions within agreed timescales.