Murex Datamart Architect in Penarth

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 AnalysisBI Tools (Power BI, Tableau, Crystal Reports, MicroStrategy)
• SWIFT Messaging Knowledge (Preferred)