OFSAA ERM Technical Consultant

Role Overview

We are looking for a highly skilled OFSAA ERM Technical Consultant with hands-on expertise in Basel and Liquidity Risk Management (LRM) modules. The role focuses on technical development, data integration, and customization within OFSAA to support regulatory and risk management requirements.

Key Responsibilities

• Design, develop, and maintain OFSAA ERM solutions (Basel / LRM)
• Perform data integration, ETL development, and data mapping into OFSAA (FSDF)
• Develop and optimize T2T (Table-to-Table) transformations
• Configure and support Basel computations (Credit Risk, Market Risk, Operational Risk)
• Implement and support Liquidity Risk Management (LRM) processes
• Write and optimize complex SQL, PL/SQL scripts
• Troubleshoot and resolve data, performance, and application issues
• Support regulatory reporting and compliance requirements
• Work closely with functional teams for requirement clarification and solution design
• Participate in UAT, deployment, and production support

Requirements

Required Skills & Experience

• Strong hands-on experience in OFSAA ERM (Basel / LRM)
• Expertise in:
• FSDF (Financial Services Data Foundation)
• Data modeling and data lineage within OFSAA
• T2T, Data Mapping, and OFSAA metadata configuration
• Strong proficiency in:
• Oracle SQL / PL-SQL
• Performance tuning and query optimization
• Experience with Basel regulatory frameworks (Basel II / III / IV)
• Solid understanding of Liquidity Risk Management concepts

Domain Experience

• Banking / Financial Services domain experience is mandatory
• Good understanding of:
• Regulatory reporting
• Risk and finance data flows

Soft Skills

• Strong analytical and troubleshooting skills
• Ability to work in a fast-paced, data-intensive environment
• Good communication and collaboration skills
• Ability to work independently and manage deliverables

Nice to Have

• Exposure to other OFSAA modules (ALM, FTP, PFT)
• Experience with OFSAA Infrastructure (OFSAAI)
• Familiarity with Unix/Shell scripting