Datamart Architect

Job Description:

• Responsible for the analysis, design, configuration, and delivery of MX.3 Datamart reporting solutions covering the Back Office (BO) and Finance reporting domains within a corporate banking transformation programme.
• The role sits at the intersection of business analysis and technical Datamart delivery, requiring the candidate to bridge the requirements of Operations, Settlements, and Finance Controller teams with the capabilities of the MX.3 Datamart reporting engine.
• The incumbent will engage directly with BO and Finance stakeholders to capture and formalise reporting requirements, translate them into Datamart object designs and report specifications, and work within the Datamart team to configure, test, and validate report outputs.
• The role operates within the broader Datamart workstream under the direction of the Murex Datamart Lead, while taking individual ownership of the BO and Finance reporting catalogue from requirements through to UAT sign-off.

KEY 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.
• Develop and maintain the following core Finance reporting outputs within Datamart: daily P&L attribution reports, mark-to-market valuation extracts, accruals and amortisation schedules, accounting entry validation reports, ledger reconciliation extracts, and balance sheet position feeds.
• Segregate and catalogue reports by business stream, product, creation class, required fields, complexity, and execution frequency to maintain a clean and auditable BO and Finance reporting inventory.
• Develop a report-level data model mapping business reporting fields to MX.3 Datamart dynamic table columns and the Murex FIN schema, ensuring accurate data lineage documentation for each BO and Finance report.
• Execute processing scripts and batches manually or via Control-M, and participate in EOD report scheduling configuration, dependency setting, and batch performance monitoring for the BO and Finance reporting scope.

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.
• Validate that SWIFT-related reporting outputs (settlement instruction extracts, confirmation reports) correctly reflect the trade population and message statuses managed within the MX.3 BO workflow.
• Document and maintain a report reconciliation log for all BO and Finance Datamart reports, tracking sign-off status, outstanding issues, and resolution actions through to UAT acceptance.

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.
• Ensure all test documentation, defect resolutions, and report sign-off artefacts for BO and Finance scope are filed accurately and consistently with the programme's quality management framework.

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.
• Contribute to programme governance forums by providing BO and Finance Datamart workstream status updates and flagging risks or issues to the Datamart Lead in a timely manner with proposed resolution actions.
• Support knowledge transfer activities at the end of the implementation phase, including documentation of report configurations, operational procedures, and user guides for the BO and Finance reporting suite.

Collaboration Within the Datamart Workstream:

• Work within the Murex Datamart workstream under the direction of the Datamart Lead, taking individual ownership of the BO and Finance reporting scope while collaborating effectively with peers covering FO, Risk, and other reporting streams.
• Participate in daily stand-ups, design reviews, and workstream planning sessions; proactively flag dependencies on FO trade booking, BO workflow configuration, and Finance accounting engine setup that may affect Datamart report development.
• Coordinate with the MxML / Integration BA to ensure that downstream report consumers (GL systems, regulatory reporting platforms, finance consolidation tools) receive correctly structured and timed Datamart extracts from the BO and Finance reporting scope.
• Support and mentor less experienced Datamart analysts within the team on BO and Finance domain knowledge, report design principles, and MX.3 Datamart configuration best practices.

Requirements:

PRIMARY REPORTING STREAMS:

• Back Office (BO) Reporting -> Settlement Instructions & Confirmations · Nostro & Position Reconciliation · Cash & Payment Reporting · Failed Trades & Breaks · Trade Lifecycle BO Views · SWIFT Message Reporting.
• Finance Reporting -> P&L Attribution & Explain · Accruals & Amortisation · Mark-to-Market Valuations · Ledger Reconciliation · Accounting Entry Validation · Balance Sheet & Income Statement Reporting.

KEY SKILLS AT A GLANCE:

• MX.3 Datamart Configuration: Accruals, MTM & Ledger Reconciliation.
• Dynamic Tables (PL, CS, DT, MV, LRB): MX.3 Reporting Architecture & Data Model.
• Feeders, Extractions & Processing Scripts: SQL (Sybase / Oracle) — Intermediate to Advanced.
• BO Settlement & Confirmation Reporting: Unix / Shell Scripting / Control-M.
• Nostro & Position Reconciliation Reports: Requirements Gathering & BRS Writing.
• P&L Attribution & Finance Reporting: SIT / UAT Support & Defect Management.

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.

PERSONAL ATTRIBUTES:

• Detail-oriented and data-driven; committed to producing accurate, reconciled, and fully validated report outputs before releasing to UAT or production.
• Strong analytical and problem-solving skills; able to trace data discrepancies from Datamart report output back to source trade booking, BO event processing, or Finance accounting entry configuration.
• Good written and verbal communication skills; able to write clear, professional BRS and FDD documents and present findings to BO and Finance stakeholders at business review meetings.
• Proactive and self-directed within the assigned BO and Finance reporting scope; able to manage individual workstreams independently while escalating blockers clearly to the Datamart Lead.
• Collaborative team player; works effectively within the Datamart workstream and across adjoining streams (FO, BO, Finance, Integration) in a complex multi-team programme environment.
• Motivated to grow both technical Datamart skills and capital markets domain knowledge within the Back Office and Finance reporting space.