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.
