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.