Job Description: Securitized Products Data Analyst (Associate)

Division Overview: Global Markets

Experience 2+ years in Securitisation Market covering ABS/RMBS/CMBS in European or US markets

The Global Markets Division is a front-office team delivering pricing, modelling, and risk management expertise to the Global Markets business. Established as a center of excellence, the group leads in price discovery and portfolio optimization techniques and is integral to achieving aggressive revenue targets. The team plays a key role in structuring, pricing, risk management, and new idea generation.

Business Overview: Securitized Products

The Securitized Products team provides clients with a range of services including flow trading liquidity, financing, bespoke solutions, in-depth market analysis, and unrivalled analytics. The team works directly with counterpart teams in EMEA and US. As a member of the team, you will be responsible for analysis and research to support the desk, helping to identify and value bond-specific opportunities in the Securitization market. The team also prepares reports and presentations on macroeconomic and regulatory themes impacting the market. We are seeking a Data Analyst to assist with deal setup in our firm-wide collateral management system (ProMerit) across multiple asset classes.

Role & Responsibilities:

- Work closely with Asset Management and Global Middle Office to perform customer and deal structure setup, configuration, and maintenance in ProMerit, including:

1. Lending account structure with pricing, billing, invoicing

2. Account rules setup

3. Collateral group rule for limits and eligibility

4. Collateral valuation rules for borrowing base calculations

5. Collateral pledge rule for feeding account balance to ledger

6. Dataset to map client's funding tape to standardized fields for data normalization

7. Edit check setup for data integrity and validation

- Perform ongoing maintenance of customer and deal setup to ensure alignment with latest legal documents

- Produce regular and ad-hoc reports for senior management

- Collaborate with IT application support team on system enhancements, issue resolution, and software upgrades

- Work with Asset Management to prepare collateral data for monthly pricing exercises

- Self-starter able to multi-task under pressure and meet deadlines; strong team player and quick learner

Key Skills & Competencies:

Essential:

- Prior experience in US or EU Securitization markets (ABS/RMBS/CMBS)

- Strong understanding of financial markets and investment concepts

- Strong analytical and problem-solving skills

- Excellent communication and collaboration skills

- 2+ years of experience as a data analyst or programmer

- 2+ years of SQL knowledge (queries, stored procedures)

- 2+ years of Python/R

- Experience handling large datasets including data cleansing, ingestion, validation, and normalization

- Strong data presentation and visualization skills

Preferred:

- Knowledge of Tableau or similar visual analytics platform