Murex Datamart Reporting Business Analyst

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. The role sits at the intersection of business analysis and technical Datamart delivery, requiring the candidate to bridge the requirements of Operations, Settlements, and Finance Controller teams with the capabilities of the MX.3 Datamart reporting engine. The incumbent will engage directly with BO and Finance stakeholders to capture and formalise reporting requirements, translate them into Datamart object designs and report specifications, and work within the Datamart team to configure, test, and validate report outputs. The role operates within the broader Datamart workstream under the direction of the Murex Datamart Lead, while taking individual ownership of the BO and Finance reporting catalogue from requirements through to UAT sign-off. KEY SKILLS AT A GLANCE MX.3 Datamart Configuration: Accruals, MTM & Ledger Reconciliation Dynamic Tables (PL, CS, DT, MV, LRB): MX.3 Reporting Architecture & Data Model Feeders, Extractions & Processing Scripts: SQL (Sybase / Oracle) — Intermediate to Advanced BO Settlement & Confirmation Reporting: Unix / Shell Scripting / Control-M Nostro & Position Reconciliation Reports: Requirements Gathering & BRS Writing P&L Attribution & Finance Reporting: SIT / UAT Support & Defect Management KEY RESPONSIBILITIES Requirements Analysis — Back Office & Finance • Engage directly with Back Office (settlements, confirmations, nostro reconciliation, payments) and Finance (P&L controllers, accounting, financial reporting) stakeholders to gather, analyse, and document reporting requirements through structured workshops and interviews. • Translate BO and Finance business requirements into detailed Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and Datamart report specifications covering data sources, fields, filters, aggregations, and output formats. • Understand the Murex system setup at the client — including the EOD process, report delivery schedule, BO workflow structure (settlement instructions, confirmation generation, event processing), and Finance accounting entry flows — to ensure report designs are grounded in platform reality. • Work closely with the Murex Datamart Lead to align BO and Finance report designs with the broader Datamart data model strategy, ensuring consistency of dynamic table usage, feeder dependencies, and object reuse principles. • Participate in peer reviews of requirements and design documentation, incorporating feedback from the Datamart Lead, Integration Lead, and business stakeholders to refine report specifications before build commences. Datamart Configuration & Report Development • Configure MX.3 Datamart objects required for BO and Finance reporting: dynamic tables (including PL, CS, DT, LRB), feeders, batch of feeders, processing scripts, extractions, and pre/post filter conditions. • Develop and maintain the following core BO reporting outputs within Datamart: settlement instruction reports, nostro balance and position reconciliation extracts, confirmation status reports, failed trade and breaks reports, cash management blotters, and trade lifecycle BO views. • Develop and maintain the following core Finance reporting outputs within Datamart: daily P&L attribution reports, mark-to-market valuation extracts, accruals and amortisation schedules, accounting entry validation reports, ledger reconciliation extracts, and balance sheet position feeds. • Segregate and catalogue reports by business stream, product, creation class, required fields, complexity, and execution frequency to maintain a clean and auditable BO and Finance reporting inventory. • Develop a report-level data model mapping business reporting fields to MX.3 Datamart dynamic table columns and the Murex FIN schema, ensuring accurate data lineage documentation for each BO and Finance report. • Execute processing scripts and batches manually or via Control-M, and participate in EOD report scheduling configuration, dependency setting, and batch performance monitoring for the BO and Finance reporting scope. Report Validation & Reconciliation • Reconcile Datamart report extraction outputs for BO and Finance reports against onscreen MX.3 views, Mreport equivalents, and source system data (e.g. settlement systems, GL, nostro statements) to validate data accuracy and completeness. • Analyse and resolve discrepancies in BO and Finance report outputs arising from filter condition changes, feeder configuration issues, missing data enrichment, or dynamic table population errors. • Perform data quality checks on Finance reporting outputs — including P&L figures, accrual amounts, MTM values, and accounting entries — against expected results provided by Finance Controllers and Product Control teams. • Validate that SWIFT-related reporting outputs (settlement instruction extracts, confirmation reports) correctly reflect the trade population and message statuses managed within the MX.3 BO workflow. • Document and maintain a report reconciliation log for all BO and Finance Datamart reports, tracking sign-off status, outstanding issues, and resolution actions through to UAT acceptance. Testing & UAT Support • Define and write test cases for BO and Finance Datamart reports, covering positive scenarios, edge cases, and reconciliation validations; ensure test documentation is consistent with programme testing standards. • Execute SIT-level testing of Datamart report configurations within the test environment; log, triage, and track defects through to resolution in coordination with the Datamart Lead and technical team. • Support business users (BO operations staff, finance controllers, product control analysts) during UAT…