- Visual Basic
- Microsoft Access
Job ID: 3193302 Full/Part-Time: Full-time
Regular/Temporary: Regular Listed: 2019-06-15
Location: New York, London, United States of America
Corporate & Investment Bank
The Corporate & Investment Bank (CIB) combines Deutsche Bank’s Corporate Finance, Equities, Fixed Income & Currencies, Institutional and Treasury Coverage and Global Transaction Banking businesses as well as Deutsche Bank Research.
As one of the world's leading investment banks, our Corporate Finance business provides the full range of investment banking products and services for large-cap and mid-cap corporates, financial institutions, governments, government agencies, hedge funds and financial sponsors.
Our offering consists of comprehensive financial advisory and capital raising services - including buyside and sellside Mergers & Acquisitions (M&A) and restructuring advice, underpinned by one of the world's largest and most successful debt and equity capital markets platforms, strong risk management systems and a global distribution network. Our range of services and strong presence across the globe enables us to complete large, multi-dimensional cross-border and regional transactions.
Global Equities is a market-leading provider of equity and equity-linked products to institutional, corporate and retail clients worldwide. The equities platform is built on four product lines – Equity Trading, Equity Derivatives, Global Investment Solutions and Prime Finance – setting the standard in trading, origination, financing and distribution.
Fixed Income & Currencies brings together a top-ranked institutional sales force, world-class research with trading and structuring expertise across Foreign Exchange, Rates, Credit and Emerging Markets. The Fixed Income & Currencies business enables us to respond to increasing automation, regulatory expectations and client demand for standardisation and transparency in execution.
Institutional and Treasury Coverage (ITC) works closely with product partners in Fixed Income & Currencies, Equities, Corporate Finance and Global Transaction Banking to ensure alignment and coordination of interaction across the numerous entry points through which we engage our clients. ITC includes Corporate Banking Coverage (CBC), Corporate Banking Germany (CBG), the Financing & Solutions Group (FSG) and the Institutional Client Group (ICG).
Global Transaction Banking (GTB) is a leading global provider of cash management, trade finance and securities services, delivering the full range of commercial banking products and services for both corporates and institutions worldwide.
Deutsche Bank Research is responsible for macro and microanalysis within Deutsche Bank Group and acts as consultant for the bank, its clients and stakeholders. We analyse relevant trends for the bank in financial markets, the economy and society and highlight risks and opportunities. Deutsche Bank Research delivers high-quality, independent analysis and actively promotes public debate on economic, fiscal, labour market and social policy issues.
Job Title: Loan Portfolio Risk Strat
Corporate Title: Assistant Vice President
Location: New York, NY or London, UK
About Deutsche Bank
We are Germany’s leading bank with strong positions in Europe and significant presence in the Americas and Asia Pacific. We’re driving growth through our strong client franchise, investing heavily in digital technologies, prioritizing long-term success over short-term gains, and serving society with ambition and integrity. We serve our clients’ real economic needs in commercial and investment banking, retail banking and transaction banking, and provide ground-breaking products and services in asset and wealth management. That means a career packed with opportunities to grow and the chance to shape the future of our clients.
Duties & Responsibilities:
Development, configuration and testing of CPSG Front Office owned tools (MS Access, MS Excel, Python) used for CLO maintenance, including developing new features, simplification, scenario analysis and on-boarding of new CLOs
Defining detailed CPSG business requirements related to Pricing and Risk for implementation into tools or the core CPSG technology stack. Building ‘prototypes/mock ups’ in order to ensure functionality or/and articulate the detailed requirements to COO IT
Identifying weaknesses or areas of improvements in systems and processes to enable automation of CPSG pricing and risk activities
Working with COO IT, Offshore CPSG teams, Loan execution and Loan operation teams to improve systems, controls and accuracy of data around pricing and risk management
Monthly CLO replenishment activities, including verification of Asset events, identifying data issues, verifying CLO replenishment eligibility and generating investor reports
Defining and Developing suite of tests to ensure correct functionality of tools post system releases and tool updates
Developing or improving existing reports and reconciliation tools to ensure accurate data essential for new CLO portfolio construction, monthly CLO replenishments and day to day tasks
Working closely with COO IT to migrate functionality from Front Office owned tools into the CPSG COO IT core systems
CLO documentation review, including assistance in CLO payment calculations
Assist in CLO origination related tasks including portfolio checks to ensure it complies with CLO documentation, obtaining internal approvals and assist in preparing data or analysis requested by potential investors
Experience & Skills:
Pricing and risk expertise, including implementation with Libraries such as DBAnalytics
Good working knowledge of Microsoft Access database, basic VBA, python or/and other programming skills
Able to converse with technology focused teams and understand key components of systems
Excellent Excel skills including extensive use of formulas – comfortable in building ad-hoc excel based tools to assist in day to day tasks
Familiarity with the market for structured credit products and particularly synthetic securitizations of loans
Excellent communication skills and initiative to engage with other teams
Significant attention to detail
Demonstrable problem solving ability; organized with an ability to manage multiple issues
For candidates applying for positions in the US:
Deutsche Bank is an Equal Opportunity Employer - Veterans/Disabled and other protected categories. Click these links to view the “ EEO is the Law ” poster and pay transparency statement.