Role Summary
We are seeking a Senior Murex Developer (Datamart Reporting) to design, develop, and optimize Murex Datamart reporting solutions across Risk, P&L, Accounting, FO, and BO streams. This role requires deep hands-on expertise in Datamart configuration, SQL performance tuning, and end-to-end reporting workflows, with L3 ownership for production support and enhancements.
You will partner closely with business stakeholders, report owners, and technical teams to deliver scalable, high-quality reporting solutions in a complex treasury environment.
Key Responsibilities
- Design, develop, and enhance Murex Datamart components including:
- Reporting cubes
- Batches and extractors
- Dynamic tables and transformations
- Build and maintain reporting workflows for FO, BO, Risk, P&L, and Accounting.
- Optimize Datamart performance through:
- SQL tuning and indexing
- Extraction logic optimization
- Efficient cube and job scheduling
- Develop custom ETL-style extractions and transformations for downstream systems.
- Provide L3 production support, including:
- Datamart job and cube failures
- Data quality issues
- Performance bottlenecks
- Collaborate with business users to gather reporting requirements and translate them into efficient Datamart designs.
- Support SIT, UAT, regression testing, and environment migrations.
- Ensure proper job orchestration, monitoring, logging, and alerting.
- Maintain high-quality technical documentation (mappings, architecture, deployment).
- Mentor junior developers on Datamart best practices.
Required Skills & Experience
- 69 years of hands-on Murex Datamart development experience.
- Strong expertise in:
- Datamart cubes, batches, extractors, dynamic tables
- Murex reporting frameworks (Risk, P&L, Accounting, Trades, Positions)
- Advanced SQL skills (Oracle, SQL Server 2012):
- Complex queries
- Indexing strategies
- Performance tuning
- Experience using Java or Python for automation, scripting, or pre/post-processing.
- Comfortable working in Linux and Windows Server 2012 environments.
- Strong understanding of Treasury products and Murex valuation data structures.
- Proven experience supporting large-volume reporting pipelines.
Nice-to-Have
- Regulatory reporting exposure (e.g. IFRS, MiFID, LCR/NSFR).
- FO/BO workflow knowledge supporting trade lifecycle and P&L reporting.
- Datamart publishing to BI tools (Power BI, Tableau, Qlik).
- Knowledge of MxML, EOD batch orchestration, shell scripting, APIs, or CI/CD pipelines.
