Murex Datamart Reporting Consultant
Job Summary
The Murex Datamart Reporting Business Analyst is responsible for the analysis, design, and configuration of MX.3 Datamart reporting solutions. The role focuses on Back Office and Finance domains, bridging requirements between operations/finance teams and technical delivery. The incumbent will own the reporting catalogue from requirements gathering through to UAT sign-off.
Responsibilities
- Gather and document BO/Finance reporting requirements
- Configure MX.3 Datamart objects and dynamic tables
- Develop and validate Back Office and Finance report outputs
- Perform end-to-end UAT support and defect management
- Reconcile report data against source system records
Required Skills
- 5-8 years Murex MX.3 Datamart experience
- Advanced SQL (Sybase/Oracle) skills
- Deep knowledge of BO and Finance reporting domains
- Experience with MX.3 data model and FIN schema
- Knowledge of Unix/Shell scripting and Control-M
Job Details
### ROLE OVERVIEW
The Murex Datamart Reporting Business Analyst (Back Office & Finance) is a mid-to-senior functional specialist responsible for the analysis, design, configuration, and delivery of MX.3 Datamart reporting solutions covering the Back Office (BO) and Finance reporting domains within a corporate banking transformation programme.
### PRIMARY REPORTING STREAMS
- **Back Office (BO) Reporting**: Settlement Instructions & Confirmations, Nostro & Position Reconciliation, Cash & Payment Reporting, Failed Trades & Breaks, Trade Lifecycle BO Views, SWIFT Message Reporting.
- **Finance Reporting**: P&L Attribution & Explain, Accruals & Amortisation, Mark-to-Market Valuations, Ledger Reconciliation, Accounting Entry Validation, Balance Sheet & Income Statement Reporting.
### KEY RESPONSIBILITIES
**Requirements Analysis**
- Engage with Back Office and Finance stakeholders to gather, analyse, and document reporting requirements.
- Translate business requirements into detailed Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and report specifications.
- Align report designs with the broader Datamart data model strategy.
**Datamart Configuration & Report Development**
- Configure MX.3 Datamart objects: dynamic tables (PL, CS, DT, LRB), feeders, processing scripts, and extractions.
- Develop core BO reporting outputs (settlement instructions, reconciliation extracts, confirmation status, trade lifecycle views).
- Develop core Finance reporting outputs (P&L attribution, MTM valuations, accruals schedules, ledger reconciliation).
- Maintain accurate data lineage documentation mapping business fields to MX.3 Datamart columns.
**Report Validation & Reconciliation**
- Reconcile Datamart outputs against onscreen MX.3 views and source system data to ensure accuracy.
- Analyse and resolve discrepancies in report outputs, including filter conditions, missing data enrichment, or configuration errors.
- Perform data quality checks on Finance outputs (P&L, accruals, MTM values, accounting entries).
**Testing & UAT Support**
- Define and execute test cases for report outputs.
- Execute SIT-level testing and manage defects through to resolution.
- Support business users during UAT, providing root-cause analysis for failed validations.
### REQUIRED EXPERIENCE & QUALIFICATIONS
- 5–8 years of hands-on experience in Murex MX.3 Datamart reporting.
- Expert knowledge of MX.3 Datamart architecture: dynamic tables, feeders, and processing scripts.
- Solid knowledge of capital markets products and their trade lifecycle (FX, Money Markets, Interest Rate Derivatives, Fixed Income, Equity).
- Proficiency in SQL (Sybase/Oracle) for data validation and reconciliation.
- Familiarity with Unix/Linux command-line and Shell scripting for batch monitoring.
- Knowledge of BI tools (e.g., Tableau, Power BI, Crystal Reports) and Excel VBA.