ANALYST PROGRAMMER

UNISON CONSULTING PTE. LTD.; Singapore; On-site; SGD 100,000 - 130,000; Full time

Job summary

A leading company in consulting is seeking a Regulatory Reporting Specialist with over 10 years of experience in financial institutions. The role involves analyzing user requirements for regulatory reporting, leading data sourcing discussions, and ensuring compliance with project standards. The ideal candidate will possess strong SQL skills and a deep understanding of core banking products, thriving in a fast-paced environment.

Qualifications

• 10+ years of experience in financial institutions for regulatory reporting.
• Strong knowledge of MAS610, HKMA, and relevant reporting platforms.
• Ability to lead requirement analysis and functional design discussions.

Responsibilities

• Understand business functions and analyze user requirements for MAS610 and HKMA Reporting.
• Lead analysis and scoping of data sourcing and functional requirements.
• Prepare functional documentation and facilitate project delivery.

Skills

Regulatory & Finance Domain knowledge

SQL Query

SDLC delivery

Project management methodologies

Education

Certifications such as CBAP, CCBA, ECBA, CFA

Tools

MS SQL Developer

ETL

Data Warehouse

Job description

Key Skills: Regulatory & Finance Domain knowledge, experienced in SDLC delivery, MAS610/HKM Reporting, SQL Query

Key Requirements

The candidate must have 10+ years of working experience in the following areas:

1. Relevant experience in a Financial Institution for Regulatory Reporting like MAS610, HKMA, BOT, Top20/100 etc., using reporting platforms such as WKFS-OneSumX, Axiom CV, Moody's, Lombard Risk, Vermag, Bloomberg, etc.
2. End-to-end data mapping specification experience is mandatory.
3. Understanding of balance sheet reporting is preferred.
4. Certifications such as CBAP, CCBA, ECBA, CFA, or equivalent are preferred.
5. Good understanding of core banking and treasury products and data requirements for management accounting or regulatory reporting.
6. Solid understanding of SDLC phases.
7. Strong requirement analysis and functional design skills.
8. Ability to self-learn and adapt quickly.
9. Flexible and able to thrive in a challenging, fast-paced environment of a growing organization.
10. Experience with project management methodologies and lifecycle.
11. Ability to develop and maintain productive relationships with colleagues across global locations.
12. Very strong knowledge of MS SQL Developer and advanced skills in writing complex SQL queries.
13. Experience with ETL and Data Warehouse is desirable.

Key Responsibilities

Candidates are expected to:

1. Understand business functions and analyze user requirements to define project scope, especially for MAS610 and HKMA Reporting.
2. Lead analysis and scoping of data sourcing, functional requirements/enhancements, and design discussions, obtaining user agreement.
3. Prepare functional, non-functional, and other necessary documentation in compliance with SDM and obtain sign-off from users.
4. Develop SIT test schedules, create test cases, and conduct SIT testing.
5. Coordinate with users for User Acceptance Testing and with the development team to prepare test environments and support testing.
6. Ensure that the design and build are in line with standards, with all deviations clearly documented and agreed upon, covering from data sourcing to final report generation.
7. Review code to prevent performance issues.
8. Prepare documentation such as release checklists and UAT results to facilitate project delivery.