Role & Responsibilities:
- Actively involved in PSAK 117 / IFRS 17 project for financial and actuarial data processing
- Design and develop efficient and scalable Database Systems (Oracle ODA)
- Develop Stored Procedures, ETL processes, Data Mapping, and Transformation
- Collaborate with Business Analysts, Actuary, Developers, and Finance for data preparation and reporting needs
- Conduct database performance tuning and query optimization
- Ensure data security, integrity, and compliance with regulatory requirements (OJK, PSAK)
Technical Requirements:
- Proficient in SQL Server (SSMS, SSIS, SSRS) and/or Oracle Database
- Experience in Data Warehouse, Data Mart, Reporting Database design
- Strong in writing Stored Procedures, Views, Functions, Triggers, ETL Pipelines
- Exposure to financial or insurance data (IFRS/PSAK) is a plus
- Knowledge in data security, encryption, and disaster recovery
Non-Technical Requirements:
- Detail-oriented, logical, and independent
- Good teamwork and communication
- Responsive to feedback and issues
Minimum Qualifications:
- Bachelor's Degree in IT/Engineering
- Minimum 3 years of experience as a Database Engineer / Developer / Data Analyst
- Having experience in Insurance core applications would be point plus