Software Consultant - Murex Datamart Reporting

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 f

Additional Information

SUMMARY DETAILS Experience: 5-8 Years Platform: Murex MX.3 Module Focus: MX.3 Datamart - Back Office & Finance Reporting Project Context: Transformation - Analysis, Design & Report Development Phase 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 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 formalize 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

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at ARISTON SERVICES PTE. LTD.? Share your experience