Overview
We are a leading provider of collateral management and regulatory compliance software solutions to banks and financial institutions on a worldwide basis. We are currently seeking a Consultant, to be based in our Singapore office to be responsible for providing consultancy to our clients in relation to their regulatory reporting requirements and their digital journey for the Monetary Authority of Singapore.
Main Role & Responsibilities
· Be part of the specialist team which provide regulatory subject matter expertise to clients across VERMEG’s portfolio of Regulatory Reports.
· Support the Senior Consultant at client workshops to identify data requirements and how they map to the AgileREPORTER Data Model.
· Use ETL tool to map and transform client data such as to satisfy the project scope and specification within the timetable set by and agreed with the Project Manager/Senior Consultant.
· Report to the Project Manager/Senior Consultant any delays or expected delays to a project, whether due to internal or customer delays, and in particular to highlight any potential scheduling conflicts that could result in such a delay.
· Deliver and implement VERMEG digital product solution for client
· Report to the Project Manager/Senior Consultant any changes of project scope whether initiated by the client, identified by the consultant or caused by regulatory change over the course of the project. Complete a Change Request document specifying the change and the cost/time impact of the change for client approval.
· Maintain good relations with the client through regular written and verbal communication.
· Maintain good relations with other departments and ensure that all documentation for other departments, particularly regarding project work (e.g. Job Requests, T&M timesheets, etc.), is completed in a timely and efficient manner.
· The candidate is expected to perform ETL developer role for a regulatory reporting project
· Transform data mapping logic into ETL jobs to produce reports aligned with expected results
· Perform unit testing and reconciliation by writing SQL queries and/or using Microsoft Excel
· Support SIT, UAT and Regression Testing
· Troubleshoot any issues that may arise
· Prepare necessary documents such as deployment guides, DR recovery guides, etc
Qualifications and Requirements
Education
· Basic Requirements (Essential):
- Degree level
Work Experience
· Basic Requirements (Essential):
- Minimum 5-7 years of working experience on building ETL-based system
· Ideal Requirements (Advantageous):
- Knowledge of the VERMEG Regulatory Software would be a significant advantage
- Previous experience of the implementation of major regulatory changes
- Basic knowledge of HKMA, MAS or APRA reporting
- Experience using the Hitachi Pentaho ETL tool
- Strong knowledge of SQL Server or Oracle and database management
- Experience with Windows Server infrastructure and configuration (i.e. ODBC setup, JAVA setup)
Languages
· Basic Requirements (Essential):
- English
Capabilities and Other Qualities
· Basic Requirements (Essential):
- Experience using the Hitachi Pentaho ETL tool or any industry standard ETL Tool
- Highly analytical
- Very strong Excel
- Strong client communication and inter-personal skills
- Capability to write SQL queries
- Team player
- Adaptability on rapid change condition
