Skip to content

Open nowPosted 8 days ago

Murex Datamart Lead/Data SME

MyCareersFuture94,028 open roles

Pay
SGD 9,000 – SGD 12,000 a month
Where
Central, Singapore
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowMurex Datamart Lead/Data SMEMyCareersFuture · Central, Singapore
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on MyCareersFuture's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.7% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.6%1 day
  2. 3.3%3 days
  3. 7.7%7 days
  4. 14.0%14 days
  5. 33.7%30 days
This job: posted 8 days ago

The posting

We are now looking for Murex Datamart Lead/Data SME who will be a senior technical and functional expert responsible for the end-to-end ownership of Murex MX.3 Datamart reporting design, architecture, configuration, and delivery within a corporate banking transformation programme in Singapore.

The incumbent will act as the primary Datamart workstream lead and Subject Matter Expert (SME), responsible for both hands-on technical delivery and the leadership of a team of Datamart reporting consultants and developers. The role requires deep expertise in MX.3 Datamart architecture, the Murex reporting engine, SQL optimisation, and capital markets reporting domains, combined with the team management and stakeholder engagement capabilities expected at a senior Lead level within a Tier 1 bank transformation programme.

Reporting Requirements & Architecture Design

• Own and lead the Datamart reporting workstream for the MX.3 transformation programme, covering all user streams: Front Office (PnL, positions, trading blotters), Back Office (settlements, confirmations, nostro), Market Risk (VaR, stress testing, sensitivities), Credit Risk (PFE, CVA, CCR), and Finance (accruals, mark-to-market, P&L attribution).

• Engage directly with business stakeholders — including traders, risk managers, finance controllers, and operations heads — to gather, analyse, and formalize reporting requirements into detailed Business Requirement Specifications (BRS) and Technical Design Documents (TDDs).

• Understand the Murex system setup at the client: the organization of support teams, EOD procedures, report delivery processes, and the interdependencies between Datamart and other MX.3 modules (FO, BO, Risk, Finance, Integration).

• Design a generic Datamart data model aligned to the bank's reporting taxonomy, then create the required Datamart objects (dynamic tables, feeders, extractions, scanner templates, processing scripts) to support all reporting use cases.

• Segregate and categories reports by users, products, creation classes, fields required, complexity, and execution frequency to build a scalable and maintainable reporting catalogue.

• Communicate regularly with business Team Leads and programme stakeholders to ensure all Datamart deliverables are progressing as planned and expectations are actively managed.

Datamart Configuration, Development & Optimisation

• Perform in-depth analysis of the Datamart setup and table structures to identify redundant objects, minimize batch execution time, and maximize reuse of existing Datamart components.

• Develop and configure all Murex

Datamart objects: dynamic tables (PL, CS, DT, MV, LRB, PLVAR), feeders, batch of feeders, processing scripts, scanner templates, extractions, reporting tables, and pre/post filter conditions.

• Design and implement Simulation-based Reports and Risk Matrix-based reports for market risk and credit risk reporting consumers within the MX.3 platform.

• Configure and optimize EOD batch execution: implement parallel feeding strategies, resolve batch bottlenecks, tune query performance, and manage processing script sequencing within Control-M or equivalent job schedulers.

• Implement dataset historization techniques within the Datamart to support time-series reporting, regulatory lookback requirements, and management information (MI) aggregation.

• Develop and maintain stored procedures, extractions, and complex SQL logic (Sybase/Oracle) for data processing, report population, and cross-module data joins leveraging the Murex FIN schema.

• Develop simulation views and scenario analysis reporting objects to support pre-trade and risk management reporting requirements for Front Office and Risk users.

Report Validation, Reconciliation & Quality Assurance

• Execute processing scripts and batch jobs manually or via scheduling tools (Control-M), and reconcile Datamart report extraction output against onscreen MX.3 views and Mreport output to validate data accuracy.

• Analyse and resolve discrepancies arising from filter condition changes, feeder configuration differences, or data model modifications between Datamart report runs.

• Define and execute Datamart-specific test cases for SIT and UAT; ensure all test documentation and deliverables are consistent with programme testing standards and acceptance criteria.

• Assist in effort estimation for Datamart development and UAT scope; maintain accurate delivery tracking and escalate issues or risks to the Programme Manager in a timely manner.

• Participate in structured peer reviews of requirements, technical specifications, and testing documentation; provide constructive feedback and maintain quality standards across the Datamart workstream.

Migration, Integration & Market Data

• Lead the migration of legacy Mreport-based reports to MX.3 Datamart equivalents, including gap analysis, mapping documentation, configuration build, and parallel run reconciliation.

• Manage market data integration and validation within the Datamart, ensuring rate curves, volatility surfaces, FX rates, and credit spread data are correctly sourced and represented in Datamart report calculations.

• Leverage NeoXam Data Hub scripting or equivalent data hub capabilities for data pipeline integration between MX.3 Datamart and downstream BI, regulatory reporting, or finance consolidation platforms.

• Coordinate with the Integration Lead to align Datamart extraction design with the broader enterprise data flow architecture, ensuring consistency of data lineage from trade booking through to report output.

• Configure MDCS (Market Data Curve Server), mxres configuration files, and launcher flags to support Datamart batch execution and reporting server performance requirements.

Team Leadership & General Management

• Lead, manage, and mentor a team of Datamart reporting consultants and developers; delegate work effectively, review team output, and maintain delivery quality across all Datamart stream deliverables.

• Responsible for end-to-end ownership of Datamart reporting deliverables: from requirements intake through design, development, testing, UAT support, and post-deployment production validation.

• Ensure all team members are guided on best practices for Datamart configuration, object reuse strategies, batch optimisation, and coding standards within the MX.3 reporting framework.

• Demonstrate the ability to work proactively and independently where required, displaying strong initiative in identifying reporting gaps, performance issues, or data quality risks before they impact programme delivery.

• Contribute to programme governance forums by providing Datamart workstream status updates, risk and issue logs, and delivery milestone tracking to the Programme Manager and Steering Committee.

REQUIRED EXPERIENCE & QUALIFICATIONS

• 10+ years of hands-on experience as a Murex

Datamart Developer, Consultant, or Reporting Lead on MX.3 programmes within corporate or investment banking environments.

• Mandatory in-depth expertise in MX.3 Datamart architecture and configuration: Datamart management, dynamic tables (PL, CS, DT, MV, LRB, PLVAR), feeders, batch of feeders, processing scripts, scanner templates, extractions, and reporting tables.

• Thorough understanding of MX reporting architecture, the MX.3 data model, the Murex

FIN schema, and MXRes configuration files and launcher flags as they relate to Datamart reporting execution.

• Strong experience in Market Risk and Credit Risk report development within MX.3 Datamart, including Simulation-based Reports, Risk Matrix reports, VaR attribution, sensitivities, and PFE reporting.

• Proven experience with Mreport framework and Mreport to Datamart migration projects — including gap analysis, mapping, and parallel reconciliation — is highly desirable.

• Demonstrated track record of leading a Datamart reporting workstream or team across at least two full SDLC cycles within a capital markets platform implementation or upgrade programme.

• Good understanding of capital markets products and trade lifecycle across: FX (mandatory), Money Markets, Interest Rate Derivatives, Fixed Income, Equity Derivatives, and Credit Derivatives.

• Experience in NeoXam Data Hub scripting or equivalent data integration platforms for connecting MX.3 Datamart outputs to downstream systems is advantageous.

• Proven ability to gather, document, and validate complex reporting requirements from diverse business stakeholders (traders, risk managers, finance controllers, operations).

Murex training or certification in Datamart and Reporting modules is advantageous.

Technical Skills

• Excellent SQL programming skills (Sybase and Oracle); proficiency in PL/SQL for stored procedures, complex joins, and performance-optimised query design across the

Murex

FIN schema.

• Unix / Linux experience is necessary; Shell scripting (awk, sed, Perl, Bash) is highly desirable for batch automation, data processing, and monitoring script development.

• Python scripting for data processing, reconciliation automation, and Datamart batch management; experience with Python in NeoXam Data Hub or similar environments is advantageous.

• Experience with at least one reporting / BI tool: Actuate eRD Pro (preferred), Crystal Reports, MicroStrategy, or equivalent; Excel VBA for report automation and data validation is a plus.

• Familiarity with scheduling tools: Control-M (preferred), AutoSys, or equivalent for Datamart batch job management, dependency configuration, and execution monitoring.

• Desirable: knowledge of MRA/MRE or MLC module configuration; familiarity with

Murex

Pricing, Trade Repository, Trade Validation, MDCS, and MxML Exchange workflows.

• Java knowledge (especially Apache Camel, Maven) for integration touchpoints between Datamart and downstream systems is an advantage.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against MyCareersFuture's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on MyCareersFuture's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    MyCareersFuture's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.