Trade Reporting Exe, VBA Required (Banking, West, Contract ) UID:2269

PERSOL SINGAPORE PTE. LTD.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

PERSOL SINGAPORE PTE. LTD. seeks a data/reporting specialist to support end-to-end OTC transaction reporting for T&M derivatives, ensuring data accuracy and timely submissions.

The role focuses on risk controls, process optimization, and building data-driven dashboards to support regulatory obligations. Experience in banking/finance is preferred; proficiency in VBA and Microsoft Office is required, with Python as a plus.

Qualifications

• Qualification or experience in related field.
• Experience in banking and financial sector preferred.
• Proficient in Microsoft Office (VBA).
• Python proficiency is a plus.

Responsibilities

• Provide end to end OTC transaction life-cycle reporting support for T&M derivatives products to fulfill regulatory reporting obligation.
• Ensure data accuracy and timely reporting.
• Ensure risk control, risk architecture and completeness are adhered to.
• Build and measure TMO performance, service, quality and data analysis via dashboards.
• Review legacy processes and exception handling to reduce toil.

Skills

VBA

Python

Microsoft Office

Job description

Essential Job Functions

1. Provide end to end OTC transaction life-cycle reporting support for T&M derivatives products to fulfil regulatory reporting obligation

2. Ensure Data accuracy and timely reporting

3. Ensure Risk Control, risk architecture and completeness are adhered to

4. Be Data driven, build and measure TMO Performance Service, Quality and Data Analysis via DDOM (Data Driven Operating Model) Dashboards

5. Review legacy processes and exception handling to eliminate toil in processes and cultivate FO & L&C changing behavior

Trade Repository (TR) Reporting

1. Validate on the daily TR reports being House and or Client Delegation.

2. Investigate on any discrepancies and investigation on root cause

3. Monitor the report acknowledgement and investigate for any rejected trades.

4. Review the successfully submitted report in DTCC-GTR and EOD completeness

5. Engage on the build of TR Reporting (new, revise, update)

6. Keep abreast of regulatory updates

7. Support NPA (New Product Agreement) & Lite (inclusive of PIR), review all NPAs related to TR, raise any deviations for execution, monitor till launch & signoffs

8. Support on Delegate Reporting of CFTC end to end from issuing of SLA to tagging of system and reporting obligation

Requirements:

-Qualification or experience in related field.

-Experienced in banking and financial sector preferred.

-Proficient in Microsoft Office (VBA)

-Python proficiency is a plus.

EA License No. 01C4394 RCB No. 200007268E Lim Jia Jie EA Registration No. R22108969