Murex Datamart Architect
Job Description
· 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)"