Database developer/ Architect with PostgreSQL, INTEX and ETL

Project Details

Senior Developer will refactor ARDA application code to use a dedicated instance of PSI DB (PostgreSQL DB). Currently, PSI DB is shared between multiple applications. The goal is to avoid issues associated with a shared instance. Enhance and create application-level documentation. Review updated PSI DB integration and documentation with the CTO.

The Senior Developer is on their way to becoming an Architect.

Responsibilities

• Hands-on expertise with the INTEX platform, including structured finance analytics, deal modeling, cash flow analysis, and integration with enterprise applications.
• Able to 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.
• Experience designing and implementing INTEX integrations with upstream and downstream systems, including market data providers, security master data, databases, APIs, and analytics platforms.
• Lead 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.
• Optimize the current INTEX implementation by improving automation, reducing manual processes, streamlining data ingestion, and enhancing overall platform reliability and performance.
• 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 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 and ensure knowledge transfer of the current implementation while driving modernization initiatives.