·     Â
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)"