Murex Datamart Lead

Job Description

· We are looking for an experienced Murex Datamart Lead / Data SME to lead the end-to-end design, architecture, configuration, optimisation, and delivery of Murex MX.3 Datamart Reporting within a large-scale banking transformation programme.

· You will serve as the Datamart Workstream Lead & Subject Matter Expert (SME), managing both hands-on technical delivery and a team of Datamart consultants/developers, while partnering with business stakeholders across Front Office, Back Office, Market Risk, Credit Risk, and Finance.

Key Responsibilities::

· Datamart Architecture & Reporting

· Lead the MX.3 Datamart Reporting Workstream across: Front Office Back Office Market Risk Credit Risk Finance

· Gather business requirements and prepare BRS & TDD documentation.

· Design and build Datamart Data Models, including: Dynamic Tables (PL, CS, DT, MV, LRB, PLVAR) Feeders Processing Scripts Scanner Templates Extractions Reporting Tables

· Build scalable reporting catalogues based on users, products, report complexity, and execution frequency.

· Development & Optimisation

· Configure and optimise Datamart architecture for performance, scalability, and batch efficiency.

· Develop: Simulation-Based Reports Risk Matrix Reports SQL Stored Procedures Reporting Objects

· Optimise: EOD Processing Batch Execution Parallel Feeding Query Performance Control-M Scheduling

· Implement historisation for regulatory and management reporting.

· Validation & Quality Assurance

· Execute and reconcile Datamart reports against MX.3 and MReport outputs.

· Resolve reporting discrepancies and support SIT/UAT.

· Prepare test cases, perform peer reviews, estimate effort, and manage delivery risks.

· Migration & Integration

· Lead MReport → MX.3 Datamart migration projects.

· Support integration with: NeoXam Data Hub Market Data (FX, Curves, Volatility, Credit Spreads) MDCS MXRes Downstream BI & Regulatory Platforms

· Leadership

· Lead and mentor a team of Datamart Developers & Consultants.

· Provide regular status updates, risk management, and governance reporting to programme stakeholders.

Required Experience::

· 10+ years of experience as a Murex Datamart Developer / Consultant / Reporting Lead in Corporate or Investment Banking.

· Strong expertise in: MX.3 Datamart Architecture Dynamic Tables Feeders Processing Scripts Scanner Templates Reporting Tables Murex FIN Schema MX Reporting Framework

· Experience developing: Market Risk Reports Credit Risk Reports VaR PFE CVA Sensitivities Simulation & Risk Matrix Reports

· Proven experience leading Datamart workstreams through multiple SDLC implementations.

· Strong understanding of Capital Markets products: FX (Mandatory) Money Markets Interest Rate Derivatives Fixed Income Equity & Credit Derivatives

Technical Skills::

· SQL (Sybase & Oracle)

· PL/SQL

· Unix / Linux

· Shell Scripting (Bash, Perl, awk, sed)

· Python

· Control-M / AutoSys

Preferred

· NeoXam Data Hub

· Actuate eRD Pro / Crystal Reports / MicroStrategy

· Excel VBA

· Java, Apache Camel & Maven

· MRA/MRE, MLC, MDCS, MxML Exchange

· Bachelor's Degree in Computer Science, IT, Finance, Financial Engineering, or a related field.

· Murex Datamart Certification and a Master's Degree are advantageous.