·      
Job Description

·      The Datamart Architect is responsible for the analysis, design, development, and delivery of Murex MX.3 Datamart reporting solutions across Back Office and Finance domains within a banking transformation programme. 

·      The role involves working closely with Operations, Settlements, Finance Controllers, and Technology teams to gather reporting requirements, configure Datamart solutions, develop reports, perform reconciliations, and support testing activities. 

Key Responsibilities:: 

·       Requirements & Solution Design 

·      Gather and analyse reporting requirements from Back Office and Finance stakeholders. 

·      Prepare Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and report specifications. 

·      Design reporting solutions aligned with the Murex MX.3 Datamart architecture and reporting framework.

·      Datamart Development & Configuration 

·      Configure Datamart components including Dynamic Tables, Feeders, Processing Scripts, Extractions, and Filters. 

·      Develop and support reports covering: Settlement & Confirmation Reporting Nostro & Position Reconciliation Cash & Payment Reporting P&L Attribution & Explain MTM Valuation Reporting Accruals & Amortisation Ledger Reconciliation & Accounting Validation 

·      Maintain report mappings, data lineage, and reporting inventories. 

·      Testing & Validation 

·      Perform data reconciliation and report validation against MX.3 and source systems. 

·      Support SIT, UAT, defect analysis, and production deployment activities. 

·       Investigate and resolve reporting discrepancies and data quality issues. 

·       Stakeholder Management 

·      Work closely with Operations, Finance, Product Control, and Technology teams. 

·      Provide reporting status updates and support business users during testing and implementation. 

·      Contribute to knowledge transfer and documentation activities. 

Required Experience 

·      5–8 years of Murex MX.3 Datamart experience within Corporate Banking, Treasury, or Capital Markets environments. 

·       Hands-on experience with: Dynamic Tables (PL, CS, DT, MV, LRB) Feeders & Batch of Feeders Processing Scripts Extractions Datamart Reporting Objects 

·       Experience delivering Back Office and Finance reports within Murex. 

·       Strong understanding of: Murex Reporting Architecture Murex Data Model & FIN Schema Trade Lifecycle Processing Settlements, Accounting, P&L, and Valuation Reporting 

·       Knowledge of capital markets products including FX, Money Markets, Interest Rate Derivatives, Fixed Income, and Equities. 

Technical Skills:: 

·      Murex MX.3 Datamart Reporting 

·      SQL (Oracle / Sybase) 

·      Data Reconciliation & Validation 

·      Control-M / Batch Scheduling 

 Unix/Linux & Shell Scripting 

·      Excel & Reporting Analysis 

·      BI Tools (Power BI, Tableau, Crystal Reports, MicroStrategy) 

·       SWIFT Messaging Knowledge (Preferred)"