Datamart Architect

### Job Description 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. ### 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. - Translate business requirements into detailed Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and Datamart report specifications. - Understand the Murex system setup including EOD process, report delivery schedule, and BO/Finance accounting entry flows. - Work closely with the Murex Datamart Lead to align 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, extractions, and filter conditions. - Develop core BO reporting outputs: settlement instructions, nostro reconciliation, confirmation status, failed trade reports, and cash management blotters. - Develop core Finance reporting outputs: P&L attribution, mark-to-market valuation, accruals, accounting entry validation, and ledger reconciliation. - Manage report-level data model mapping and ensure accurate data lineage documentation. - Execute and monitor processing scripts and batch scheduling. **Report Validation & Reconciliation:** - Reconcile Datamart report outputs against MX.3 views and source system data to validate accuracy. - Analyse and resolve discrepancies arising from feeder configurations or data enrichment issues. - Perform quality checks on Finance reporting outputs (P&L, accruals, MTM values). - Document report reconciliation logs and track issues through to UAT acceptance. **Testing & UAT Support:** - Define test cases covering positive scenarios and edge cases. - Execute SIT-level testing and triage defects. - Support business users during UAT, providing root-cause analysis and configuration fixes. ### Requirements: - 5–8 years of hands-on experience in Murex MX.3 Datamart reporting (BO/Finance domains). - Proficiency in MX.3 architecture, dynamic tables, feeders, and processing scripts. - Solid knowledge of capital markets products and trade lifecycle (FX, Money Markets, Interest Rate Derivatives, Fixed Income, Equity). - Intermediate to advanced SQL skills (Sybase/Oracle) and Unix/Shell scripting proficiency. - Experience with report scheduling tools (Control-M) and BI/reporting tools. - Bachelor’s degree in Finance, Accounting, IT, or related discipline.