Murex Data Track Lead (Ref 26462)

Responsibilities 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 formalise reporting requirements into detailed Business Requirement Specifications (BRS) and Technical Design Documents (TDDs). • Understand the Murex system setup at the client: the organisation 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 categorise 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, minimise batch execution time, and maximise 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 optimise 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 historisation 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. Requirements • Bachelor's degree or higher in Finance, Computer Science, Information Technology, Financial Engineering, or a related discipline. • Formal Murex training or certification in Datamart and Reporting modules is advantageous. Master's degree in a quantitative or technical field is a plus. 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. • 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. Shortlisted candidates will be offered a 1 Year Agency employment contract.