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