Murex Datamart Lead in Penarth

We are seeking an experienced Murex Datamart Lead to lead the end-to-end design, architecture, configuration, optimization, and delivery of Murex MX.3 Datamart reporting solutions for a large-scale corporate banking transformation program. The successful candidate will act as the Datamart Subject Matter Expert (SME) and workstream lead, driving reporting solutions across Front Office, Back Office, Market Risk, Credit Risk, and Finance domains while leading a team of Datamart consultants and developers.

Key Responsibilities

• Datamart Architecture & Reporting Design
  • Lead the MX.3 Datamart reporting workstream across Front Office, Back Office, Market Risk, Credit Risk, and Finance functions.
  • Gather and analyze business reporting requirements from traders, risk managers, finance controllers, and operations teams.
  • Design scalable Datamart architectures, data models, reporting structures, and reporting catalogues.
  • Produce Business Requirement Specifications (BRS), Technical Design Documents (TDDs), and reporting solution designs.
  • Define reporting strategies and ensure alignment with enterprise reporting standards.
• Datamart Development & Configuration
  • Configure and develop Murex Datamart components including: Dynamic Tables (PL, CS, DT, MV, LRB, PLVAR), Feeders and Batch Feeders, Processing Scripts, Scanner Templates, Extraction Reporting Tables.
  • Design and implement Simulation-Based Reports and Risk Matrix Reports.
  • Develop SQL-based reporting solutions and complex data processing logic.
  • Implement historization and time-series reporting capabilities.
• Performance Optimization & EOD Processing
  • Optimize Datamart batch execution and End-of-Day (EOD) processing performance.
  • Implement parallel processing strategies and resolve batch bottlenecks.
  • Tune database queries and processing scripts for maximum efficiency.
  • Configure Control-M or equivalent schedulers for automated reporting execution.
• Testing, Validation & Reconciliation
  • Perform report validation and reconciliation against MX.3 screens and Mreport outputs.
  • Define and execute SIT and UAT test scenarios.
  • Analyze and resolve reporting discrepancies and data quality issues.
  • Support migration from legacy Mreport frameworks to MX.3 Datamart.
• Integration & Market Data
  • Support integration of Datamart outputs with downstream BI, Finance, Regulatory Reporting, and Risk platforms.
  • Manage market data integration including: Yield Curves, FX Rates, Volatility Surfaces, Credit Spreads.
  • Collaborate with enterprise integration teams to maintain data lineage and consistency.
  • Support NeoXam Data Hub integrations and reporting pipelines.
• Leadership & Stakeholder Management
  • Lead and mentor a team of Datamart developers and reporting consultants.
  • Manage work allocation, quality assurance, and delivery timelines.
  • Provide regular status updates, risk assessments, and milestone reporting to program leadership.
  • Engage with business and technology stakeholders throughout the project lifecycle.

Required Qualifications & Experience

• 10+ years of experience working with Murex MX.3 Datamart and Reporting solutions.
• Proven experience leading Datamart reporting workstreams within corporate or investment banking environments.
• Experience across at least two full SDLC cycles of Murex implementation, upgrade, or transformation programs.
• Strong experience supporting Front Office, Risk, Finance, and Operations reporting requirements.

Murex Expertise

• Deep expertise in: MX.3 Datamart Architecture, Dynamic Tables (PL, CS, DT, MV, LRB, PLVAR), Feeders and Batch Feeders, Processing Scripts, Scanner Templates, Extraction and Reporting Tables.
• Strong knowledge of: Murex FIN Schema, MX Reporting Framework, MXRes Configuration, Launcher Flags, Datamart Batch Processing.

Capital Markets Knowledge

• Strong understanding of: Foreign Exchange (FX), Money Markets, Interest Rate Derivatives, Fixed Income, Equity Derivatives, Credit Derivatives.

Technical Skills

• Advanced SQL development (Sybase and Oracle).
• PL/SQL programming and query optimization.
• Unix/Linux administration.
• Shell Scripting (Bash, Perl, awk, sed).
• Python scripting for automation and reconciliation.
• Control-M or equivalent scheduling tools.
• Experience with reporting tools such as: Actuate eRD Pro (Preferred), Crystal Reports, MicroStrategy.
• Knowledge of Java, Apache Camel, and Maven is advantageous.