Datamart Architect (Ref 26462)

Responsibilities

Requirements Analysis — Back Office & Finance

• Engage directly with Back Office (settlements, confirmations, nostro reconciliation, payments) and Finance (P&L controllers, accounting, financial reporting) stakeholders to gather, analyse, and document reporting requirements through structured workshops and interviews.
• Translate BO and Finance business requirements into detailed Business Requirement Specifications (BRS), Functional Design Documents (FDDs), and Datamart report specifications covering data sources, fields, filters, aggregations, and output formats.
• Understand the Murex system setup at the client — including the EOD process, report delivery schedule, BO workflow structure (settlement instructions, confirmation generation, event processing), and Finance accounting entry flows — to ensure report designs are grounded in platform reality.
• Work closely with the Murex Datamart Lead to align BO and Finance report designs with the broader Datamart data model strategy, ensuring consistency of dynamic table usage, feeder dependencies, and object reuse principles.
• Participate in peer reviews of requirements and design documentation, incorporating feedback from the Datamart Lead, Integration Lead, and business stakeholders to refine report specifications before build commences.

Datamart Configuration & Report Development

• Configure MX.3 Datamart objects required for BO and Finance reporting: dynamic tables (including PL, CS, DT, LRB), feeders, batch of feeders, processing scripts, extractions, and pre/post filter conditions.
• Develop and maintain the following core BO reporting outputs within Datamart: settlement instruction reports, nostro balance and position reconciliation extracts, confirmation status reports, failed trade and breaks reports, cash management blotters, and trade lifecycle BO views.

Report Validation & Reconciliation

• Reconcile Datamart report extraction outputs for BO and Finance reports against onscreen MX.3 views, Mreport equivalents, and source system data (e.g. settlement systems, GL, nostro statements) to validate data accuracy and completeness.
• Analyse and resolve discrepancies in BO and Finance report outputs arising from filter condition changes, feeder configuration issues, missing data enrichment, or dynamic table population errors.
• Perform data quality checks on Finance reporting outputs — including P&L figures, accrual amounts, MTM values, and accounting entries — against expected results provided by Finance Controllers and Product Control teams.

Testing & UAT Support

• Define and write test cases for BO and Finance Datamart reports, covering positive scenarios, edge cases, and reconciliation validations; ensure test documentation is consistent with programme testing standards.
• Execute SIT-level testing of Datamart report configurations within the test environment; log, triage, and track defects through to resolution in coordination with the Datamart Lead and technical team.
• Support business users (BO operations staff, finance controllers, product control analysts) during UAT — responding to queries, investigating data discrepancies, performing configuration fixes, and providing root-cause analysis for failed report validations.
• Assist the Datamart Lead with effort estimation for BO and Finance report development and UAT scope; maintain delivery tracking logs for all assigned report items.

Stakeholder Engagement & Communication

• Communicate regularly with BO Operations Team Leads, Finance Controllers, and Product Control managers to provide status updates on report delivery, surface open issues, and align on prioritisation decisions.
• Act as the primary point of contact for BO and Finance reporting queries throughout the transformation programme, maintaining clear and professional communication with both business and technology stakeholders.

Requirements Experience

• 5–8 years of hands-on experience in Murex MX.3 Datamart reporting within Back Office and/or Finance reporting domains in a corporate or investment banking environment.
• Solid working knowledge of MX.3 Datamart architecture and configuration: dynamic tables, feeders, batch of feeders, processing scripts, extractions, reporting tables, and pre/post filter conditions.
• Demonstrated experience developing BO Datamart reports: settlement instruction extracts, nostro reconciliation reports, confirmation status reports, failed trade blotters, and cash position reports.
• Demonstrated experience developing Finance Datamart reports: P&L attribution, MTM valuation extracts, accruals/amortisation schedules, accounting entry validation reports, and GL reconciliation feeds.
• Good understanding of the MX.3 reporting architecture, MX data model, and the Murex FIN schema as they relate to BO and Finance report data sourcing and field mapping.
• Solid knowledge of capital markets products and their trade lifecycle within MX.3, with particular emphasis on the Back Office and Finance dimensions: settlement workflows, event processing, accounting entries, and P&L generation for FX (mandatory), Money Markets, Interest Rate Derivatives, Fixed Income, and Equity products.
• Good understanding of the Murex Back Office module: settlement instructions, confirmation workflows, nostro management, and the interaction between BO event processing and Datamart report population.
• Good understanding of the Murex Finance / Accounting Engine: P&L explain, accruals, MTM calculations, accounting templates, and how Finance accounting entries are represented in Datamart dynamic tables.
• Experience in MXRes configuration file familiarity and launcher flags as they affect Datamart batch report execution is an advantage.
• Exposure to Mreport framework and experience participating in Mreport-to-Datamart migration projects is desirable but not mandatory.
• Proven ability to gather, document, and validate reporting requirements from BO and Finance stakeholders in a structured BA capacity.

Education

• Bachelor's degree in Finance, Accounting, Information Technology, Computer Science, Business Analytics, or a related discipline.
• Formal Murex training in Datamart and Reporting modules is advantageous. A professional accounting qualification (ACCA, CPA, or equivalent) or finance credential is a plus for the Finance reporting dimension of this role.

Technical Skills

• Intermediate to advanced SQL skills (Sybase and/or Oracle) for Datamart report data validation, reconciliation querying, and diagnostic analysis across the Murex FIN schema.
• Basic to intermediate Unix / Linux command-line proficiency; Shell scripting experience for batch monitoring and simple data processing tasks is advantageous.
• Familiarity with Control-M or equivalent job scheduling tools for monitoring and executing Datamart batch jobs and processing scripts in a Murex EOD context.
• Exposure to at least one BI or reporting tool (Actuate eRD Pro, Crystal Reports, MicroStrategy, Tableau, or Power BI) used to present Datamart report outputs to BO and Finance consumers.
• Excel and Excel VBA skills for report validation, reconciliation, and ad-hoc Finance/BO data analysis tasks.
• Familiarity with SWIFT messaging types relevant to BO reporting (MT300, MT320, MT202, MT199 settlement and confirmation series) is beneficial for report scope understanding.

Licence no: 12C6060