Lead Murex Datamart Consultant
Successfully
Req. VR-125666
Our client, a prominent bank in Singapore, is seeking a Lead Datamart reporting consultant for an ongoing project. The project scope includes development and enhancements such as account automation, futures price correction, and prime brokerage.
Understand the Murex system setup at the client, organization of the support teams, end of day procedures and the report delivery process
Collect and provide detailed technical specifications / business requirement specifications
Participates in peer review of requirements elicitation, technical and/or testing documentation and assists mentors junior members with same
Analyze DataMart setup and the table structures for the purpose of identifying redundant objects, to minimize execution time of batches, and to seek possibility of reuse of objects
Segregate reports by users, products, creation classes, fields needed, complexity and frequency of execution
Develop a generic data model and then create DataMart objects as required for the reports
Execute processing scripts and batches manually or through the use of a scheduling tool like Control-M
Analyze differences caused by adding or removing some filter conditions / dynamic table flags / launcher flags
Create and suggest processes, templates and tools to streamline the development, testing and implementation phases
Analyses issues during planning and test execution phases
Provide relevant and accurate information about defects and help the business reproduce errors
Prepare and send effective periodic and timely status reports
Track the testing progress and escalate the issue well in advance
Assists in the preparation and execution of test plans
Identifies the conditions that create errors to occur and escalates outstanding issues for clarification and resolution
Escalates identified issues/risks in a timely fashion to the PM
Assist PM with effort estimation related to the development and UAT
Coordinate with development and infrastructure team for availability of Mx environments and database
Create and maintain report delivery plan with relevant traceability
Must have
At least 10+ years of experience on MX3.1 Datamart
Understanding of the Murex system as a whole
Good understanding of capital market products
In-depth understanding of MX reporting architecture, MX data model, and MX Datamart configuration
Familiarity with mxres configuration files, and launcher flags
Thorough knowledge of Datamart objects
dynamic tables, feeders, batch of feeders, scanner templates etc.
Experience with Simulation and Risk Matrices
Experience with Market risk and credit risk report development
Experience with RDBMS, e.g. Oracle, Sybase
Excellent SQL programming skills
Unix experience necessary; shell programming experience highly desirable; awk, sed, and Perl scripting experience would be a bonus
Experience with at least one reporting tool, preferably Actuate eRD Pro
Other programming experience a plus, esp MS Excel VBA
Product knowledge (Any one or more, FX mandatory)
FX, IRD, FI, EQD, CRD
Very good knowledge of SQL (Sybase and Oracle), Atleast one reporting tool (Actuate, Crystal reports, Micro Strategy), Basic unix commands
Understanding of Trade Life Cycle
Should possess an understanding of financial markets
Basic knowledge on financial instruments such as Interest Rate Derivatives, Credit Derivatives, Currency Derivatives, Swaps, Futures, Options, FRA, etc.
Murex upgrade related report development & reconciliation experience.
Nice to have
Any reconciliation tools experience
Murex MxML experience
Languages
English: C1 Advanced
Seniority
Senior
Singapore, Singapore
Req. VR-125666
Murex Datamart
BCM Industry
20/10/2026
Req. VR-125666
Apply for Lead Murex Datamart Consultant in Singapore
*Indicates a required field