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.