OFSAA ERM Technical Consultant

About the Role

The role is critical in ensuring that Unison Consulting Pte Ltd stays ahead of the curve in terms of regulatory compliance, given the ever-evolving landscape of financial regulations. The ability to work in a fast-paced, data-intensive environment is key, as the consultant will be responsible for troubleshooting and resolving data, performance, and application issues.

The OFSAA ERM Technical Consultant will be part of a team that values strong analytical and troubleshooting skills, alongside the ability to work independently and manage deliverables effectively. Good communication and collaboration skills are essential, as the consultant will be working closely with various stakeholders to ensure that solutions are designed and implemented effectively.

What You Will Do

• Design, develop, and maintain OFSAA ERM solutions (Basel / LRM) to support regulatory and risk management requirements.
• Perform data integration, ETL development, and data mapping into OFSAA (FSDF) to ensure data consistency and integrity.
• Develop and optimize T2T (Table-to-Table) transformations to improve data processing efficiency.
• Configure and support Basel computations (Credit Risk, Market Risk, Operational Risk) to comply with regulatory requirements.
• Implement and support Liquidity Risk Management (LRM) processes to mitigate liquidity risks.
• Write and optimize complex SQL, PL/SQL scripts to improve database performance and efficiency.
• Troubleshoot and resolve data, performance, and application issues to minimize downtime.
• Support regulatory reporting and compliance requirements by ensuring that all solutions are compliant with relevant regulations.
• Work closely with functional teams for requirement clarification and solution design to ensure that solutions meet business needs.
• Participate in UAT, deployment, and production support to ensure smooth transition of solutions to production.

What We Are Looking For

• Strong hands-on experience in OFSAA ERM (Basel / LRM) is required, with a deep understanding of risk management principles and regulatory requirements.
• Expertise in FSDF (Financial Services Data Foundation) and data modeling and data lineage within OFSAA is necessary.
• Proficiency in T2T, Data Mapping, and OFSAA metadata configuration is essential for data integration and management.
• Strong proficiency in Oracle SQL / PL-SQL is required for database management and optimization.
• Experience with Basel regulatory frameworks (Basel II / III / IV) and a solid understanding of Liquidity Risk Management concepts are crucial.
• Banking / Financial Services domain experience is mandatory, with a good understanding of regulatory reporting and risk and finance data flows.
• Strong analytical and troubleshooting skills, with the ability to work in a fast-paced, data-intensive environment.
• Good communication and collaboration skills, with the ability to work independently and manage deliverables effectively.

Nice to Have

• Exposure to other OFSAA modules (ALM, FTP, PFT) can be beneficial for a holistic understanding of the OFSAA suite.
• Experience with OFSAA Infrastructure (OFSAAI) can provide insight into the technical infrastructure supporting OFSAA solutions.
• Familiarity with Unix/Shell scripting can be useful for automation and optimization tasks.

Benefits and Perks

• The opportunity to work with a leading company in the financial services sector, leveraging the latest technologies in risk management.
• A competitive compensation package, reflecting the importance of the role in supporting regulatory compliance and risk management.
• Opportunities for professional growth and development, including training and certifications in OFSAA and related technologies.
• Flexible working hours and remote work arrangements, allowing for a better work-life balance.
• Access to cutting-edge tools and technologies, ensuring that the consultant stays up-to-date with industry trends and best practices.
• A collaborative and dynamic work environment, with a team of experienced professionals passionate about delivering high-quality solutions.
• Health and wellness programs, recognizing the importance of mental and physical health in achieving professional success.
• A stipend for professional development, supporting ongoing learning and skill enhancement.

• Ensure your resume highlights specific examples of OFSAA ERM experience, particularly in Basel and Liquidity Risk Management, to stand out from other applicants.
• Prepare to discuss your understanding of regulatory frameworks and how you have applied them in previous roles to demonstrate your expertise.
• Practice troubleshooting scenarios related to data integration and performance issues to show your problem-solving skills.
• Be ready to provide examples of complex SQL scripts you have optimized and explain your approach to query optimization.
• Consider creating a portfolio of your work, including any relevant certifications or training in OFSAA and risk management, to demonstrate your capabilities to potential employers.
• During salary negotiations, be prepared to discuss your expectations based on industry standards and your unique skill set.
• Look for red flags such as lack of clarity on job expectations or unrealistic deadlines, which could indicate a poorly managed project or unrealistic expectations.