#44 - NYB - SPG ARDA PSI DB Single Instance

Overview del rol

We are looking for a senior Architect with hands-on expertise with the INTEX platform, including structured finance analytics, deal modeling, cash flow analysis, and integration with enterprise applications. The candidate will assess and redesign the current INTEX architecture, gaining a deep understanding of the existing implementation and identifying opportunities to improve scalability, performance, maintainability, and operational efficiency. This includes leading an architecture review of the current INTEX ecosystem, documenting data flows, dependencies, integration patterns, and technical debt, while recommending a target-state architecture aligned with business objectives.

The role also involves leading the segregation of the PSI database from the ARDA platform, including analysis of existing database dependencies, data models, stored procedures, and application integrations to establish an independent PSI data architecture, and providing technical leadership on PSI architecture modernization.

Skills

• Hands-on expertise with the INTEX platform, including structured finance analytics, deal modeling, cash flow analysis, and integration with enterprise applications
• Strong understanding of structured finance data models (ABS, RMBS, CMBS, CLO, CDO, MBS) and how INTEX data supports pricing, analytics, reporting, and risk management
• Experience designing and implementing INTEX integrations with upstream and downstream systems, including market data providers, security master data, databases, APIs, and analytics platforms
• Experience working with enterprise architecture and integration patterns, including API-based integrations, ETL processes, messaging, and database synchronization in complex financial environments
• Experience with database dependencies, data models, stored procedures, and application integrations for database segregation

Must-haves

• Hands-on expertise with the INTEX platform, including structured finance analytics, deal modeling, cash flow analysis, and integration with enterprise applications
• Strong understanding of structured finance data models (ABS, RMBS, CMBS, CLO, CDO, MBS)
• Ability to lead an architecture review of the current INTEX ecosystem, documenting data flows, dependencies, integration patterns, and technical debt, while recommending a target-state architecture
• Experience leading the segregation of a database (PSI) from a shared platform (ARDA), including analysis of dependencies, data models, stored procedures, and application integrations
• Experience designing and executing database separation strategy ensuring data integrity, minimal business disruption, and successful migration of schemas, ETL processes, interfaces, and reporting components

Nice-to-haves

• Experience working with enterprise architecture and integration patterns, including API-based integrations, ETL processes, messaging, and database synchronization in complex financial environments
• Ability to collaborate with business, architecture, and engineering teams to define the future-state INTEX roadmap
• Experience ensuring knowledge transfer of the current implementation while driving modernization initiatives
• Knowledge of Santander's (or similar banks') application landscape to identify integration impacts and optimize data flows

Originally posted on Himalayas