Murex Specialist (Extractions) needed at Rand Merchant Bank

Job Description

• As a Murex Extractions specialist, your primary responsibility is to ensure that the extractions component of our Murex trading system is meticulously maintained and improved. You’ll play a critical role in troubleshooting Murex data extractions, collaborating with internal and external teams, resolving issues promptly, and ensuring data output is ready for our business users and systems. 
• The team is currently split between support and build roles. You will need to be flexible and may be required to work in either of these roles depending on the team setup and rotation.

Support role:

• The support role is rotated among two or three team members.

Core responsibilities: 

• Ensure the Murex trading system extractions are meticulously prepared and ready for business trading by 7:00 AM.
• Rotate on a weekly roster for overnight support and early morning checks.
• On your week of early morning support, you will be required to perform early morning checks starting at 06:00. There are times when you may get called for overnight support, and this would happen where the overnight team is unable to resolve the issue and they require your expertise. On average, you might get called once a week. In these cases, team members can end their working day early to get rest.
• Monitor and resolve incidents and requests logged by users. Making changes to the Murex reporting module will be required to resolve these.
• Monitor and respond to user support emails.
• Continually improve support processes.
• Track the performance of our EOD and propose enhancements.
• Handle end-of-day rerun requests. If there are significant risk breaches, you will need to manage extraction reruns when requested by business.

Build role: 

• Your primary function is to build file extracts using the Murex reporting module. These files are used by users and systems.
• This role provides more focus time to ensure a more consistent delivery path for our stakeholders.
• At times, you will be required to contribute in the Support role. There may also be times when you will need to be assigned to the support role for longer periods of time. We try our best to ensure the support and build roles don’t overlap but this does happen from time to time.

General Responsibilities: 

Design and Development:

• Collaborate with the Murex extractions team to design and develop new Murex reporting requirements.
• Create and enhance Murex reports to meet evolving business needs.
• Apply fixes and modifications to existing Murex reports as necessary.
• Propose new designs that will drive efficiencies into the existing end of day setup.
• Enhance alerts and monitoring to bring about more swift resolution to issues. Datamart Management:
• Maintain Datamart tables, feeders, and associated scripts.
• Ensure data integrity and accuracy within the Datamart.
• Investigate and analyze data generation failures and anomalies.

Optimization and Performance:

• Regularly optimize the execution of Murex reports (MX reports).
• Identify bottlenecks and inefficiencies in the extraction process.
• Implement best practices to enhance performance.

Documentation and Knowledge Transfer:

• Contribute to documentation related to the Murex Reporting Module.
• Facilitate knowledge transfer within the team.

Required Expertise:

Control-M:

• In-depth understanding of Control-M functionality.
• Proficiency in debugging job failures.
• Knowledge of job dependencies and scheduling.
• Ability to swiftly resolve overnight failures that impact service level agreements (SLAs).

MX Datamart Modules:

• Familiarity with dynamic table configurations.
• Differentiation between Transactional and Datamart tables.
• Understanding of Datamart management, including SQL-based and dynamically generated tables.

Understanding Batch of table feeders and Batch of table feeder jobs recovery. Skill in identifying errors within Murex (view execution jobs and view produced data by table).

1SQL (Oracle):

• Proficiency in troubleshooting using SQL queries.
• Understanding of temporary tables and their usage.
• Ability to leverage SQL for Murex Datamart Extractions.

Simulation Views, MRA Views, and Market Data Views:

• Identification of simulation view-based reporting tables.
• Loading different types of simulation views.
• Understanding of market data views.
• Loading virtual sources in MRA views.
• Utilizing Trade Query effectively.

Qualifications: 

• Bachelor’s degree in Finance, or a related field.
• Proven experience in Murex reporting and data extraction.
• Strong analytical skills and attention to detail.
• Excellent communication and collaboration abilities.