Murex Datamart Business Analyst

About the CompanyWe are a premium financial technology and enterprise systems transformation partner embedded within tier-1 corporate and investment banking institutions. By combining deep capital markets domain expertise, high-throughput data warehousing architecture, and rigorous delivery governance, we orchestrate high-performance platform migrations that power global financial networks. We focus on engineering mastery, data pipeline modernization, and cultivating top-tier technical advisory talent in Singapore. About the JobWe are seeking a mid-to-senior Murex Datamart Business Analyst specializing in Back Office and Finance Reporting for a major corporate banking transformation programme. This role stands at the critical nexus of business analysis and technical data warehouse delivery. Operating under the guidance of the Murex Datamart Lead during the Analysis, Design & Report Development Phase, you will take individual ownership of the Back Office (BO) and Finance reporting catalogues. Your mission will be to interface directly with Operations, Settlements, and Financial Controllers, translating complex regulatory and operational accounting needs into high-performance, fully reconciled MX.3 Datamart reporting layers. Key Skills at a Glance• Experience Tier: 5–8 Years Hands-On Murex MX.3 Datamart Engineering • Datamart Objects: Dynamic Tables (PL, CS, DT, MV, LRB, PLVAR), Feeders, Filters, and Extractions • Back Office Domain: Settlement Instructions, Confirmations, Nostro/Position Reconciliations, SWIFT Messaging • Finance Domain: P&L Attribution/Explain, Accruals & Amortisation, Mark-to-Market (MTM) Valuations, Ledger Mapping • Technical Stack: SQL (Sybase / Oracle), Unix/Linux Shell Scripting, Control-M Batch Processing • Core Schema: Murex FIN Schema, MXRes Configurations, Launcher Flags • Methodology: Requirements Elicitation, Business Requirement Specifications (BRS), Functional Design Documents (FDD) • Quality Gate: SIT/UAT Test Case Engineering, Data Lineage Traceability, Defect Triage Key Responsibilities1. Requirements Architecture & Functional Design • Stakeholder Elicitation: Lead structured workshops and interviews with Back Office operations staff and Finance controllers to elicit, analyze, and map complex reporting needs. • Specification Engineering: Author detailed Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and report-level data models mapping fields against the Murex FIN Schema. • Platform Alignment: Ensure report designs reflect platform reality by aligning them with target End-of-Day (EOD) schedules, accounting engine flows, and cross-module dependencies (FO → MO → BO → Finance). • Object Reuse Governance: Collaborate with the Datamart Lead to align design blueprints with the broader enterprise data warehouse strategy, driving dynamic table standardization and feeder asset reuse. 2. Datamart Configuration & Report Development • Object Building: Configure core MX.3 Datamart layers, including dynamic tables (PL, CS, DT, LRB), processing scripts, batches of feeders, and complex pre/post-filter conditions. • BO Delivery: Build and maintain operational reports tracking settlement instructions, nostro/position reconciliations, failed trade blotters, and SWIFT message delivery paths. • Finance Delivery: Build and maintain financial reporting pipelines tracking daily P&L attributions, MTM valuations, accrual/amortisation schedules, and General Ledger (GL) feed validations. • Batch Integration: Manually execute processing scripts or coordinate via Control-M to monitor batch runtimes, configure job dependencies, and tune query performance inside EOD cycles. 3. Report Validation, Reconciliation & Testing • Data Lineage Auditing: Reconcile Datamart extraction output files directly against onscreen MX.3 simulation views, Mreport baselines, and downstream accounting ledgers to guarantee 100% data completeness. • Discrepancy Triage: Trace, debug, and fix report output anomalies resulting from faulty feeder logic, filter conflicts, or unmapped master data attributes. • Quantitative Validation: Audit high-value financial metrics (P&L explain figures, accrual balances) against control sheets provided by Product Control analysts. • Test Track Execution: Author and execute SIT and UAT test scripts covering edge-case trade populations. Provide dedicated hypercare to business testers during UAT, delivering swift root-cause analysis for failed validations. 4. Workstream Collaboration & Interface Management • Integration Alignment: Partner with the MxML/Integration team to ensure downstream report consumers (GL ledger engines, regulatory platforms) receive timely, structurally sound extracts. • Knowledge Optimization: Catalogue the reporting inventory neatly by product class and frequency, and deliver clean documentation to support operational handovers at project closure. Required Experience & QualificationsProfessional Experience • Platform Tenure: 5–8 years of hands-on experience as a Functional Consultant or Business Analyst on Murex MX.3 Datamart reporting platforms, operating heavily within BO or Finance domains. • Asset Class Literacy: Solid understanding of capital markets product life cycles within MX.3, with mandatory coverage of FX, alongside Money Markets, Interest Rate Derivatives, Fixed Income, and Equity structures. • Domain Competency (BO): Strong functional grasp of settlement workflows, confirmation routing, and SWIFT series messaging layouts (MT300, MT320, MT202, MT199). • Domain Competency (Finance): Clear comprehension of the Murex Accounting Engine, including how P&L entries, templates, and accrual types are mapped into Datamart tables. Technical Skills • Advanced Database Querying: Intermediate to advanced SQL skills (Oracle and/or Sybase) for running data validation queries and structural joins across the FIN schema. • Environments & Scripts: Basic to intermediate Unix/Linux command-line familiarity; Shell scripting (Bash, awk, sed) for automated file parsing or batch tracking is highly advantageous. • Batch Orchestration: Practical exposure to Control-M or an equivalent enterprise job scheduler within a Murex EOD context. • Reporting Extensions: Familiarity with launcher flags and MXRes files. Exposure to legacy Mreport migrations or downstream BI systems (Power BI, Tableau, Crystal Reports) is an advantage. Education & Credentials • Bachelor’s degree in Finance, Accounting, Computer Science, Information Technology, Business Analytics, or a related discipline. • Formal vendor training in Murex Datamart modules is an advantage. • Professional accounting credentials (CPA, ACCA, or equivalent) are considered a strong plus for the Finance track of this role. How to ApplyPlease click on the 'apply' button to apply online. For more information, please reach out to Vievien Nathan. EA License Number: 94C3609