Job Purpose

The candidate is expected to work on the Regional IFRS17 Programme as a Data Mapper cum Business Analyst. The Programme is implementing solutions for compliance with the International Financial Reporting Standards for Insurance Industry which the Company targets to go live in January 2023 for Singapore & Malaysia entities and 2 years later for Indonesia entities.

The candidate’s key role is to:

• Work with business stakeholders to gather business requirements / rules
• Gather data requirements and perform data analysis from source system SMEs
• Conduct thorough data analysis by writing SQL queries
• Apply business requirements / rules to source system data, taking into account how systems generate / update data, to produce mapping documents for ETL / ELT developers
• Assist project manager by leading prioritization and implementation of change requests / defect fixes in BAU

The candidate is also expected to follow our Group IT Application Processes, Standards & Procedures.

The Job
Key responsibilities and duties:

• Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies in order to understand the risk and better safeguard the company.
• Highlights any potential concerns /risks and proactively shares best risk management practices

• Facilitate / conduct workshops with business stakeholders to identify project requirements, gather, analyse and document requirements.

• Facilitate / conduct workshops with source system and other technical stakeholders to identify data elements and understand source system behavior

• Produce mapping rules from source system data to target system tables based on workshops with business and technical stakeholders.

• Perform thorough data analysis to verify mapping rules correctly transform data from source to target to meet business requirements / rules by writing SQL queries.

• Publish ETL / ELT mapping documents that contain mapping rules for developers to build jobs as well as other artifacts e.g. Data Mapping specification, integration/interface specifications, site-map and page-flow, and the usage of UML diagram to detail process and data flows.

• Support IT and business stakeholders throughout the SDLC: Unit testing, System Integration Testing (SIT), User Acceptance Testing (UAT) and Production.

• Develop IFRS17 and contribute towards insurance-specific SME knowledge for group-wide knowledge management.

• During project implementation phase, lead implementation of change requests / defect fixes

• During BAU, leading prioritization and implementation of change requests / defect fixes

• People management – leading the team in identifying, developing, motivating the team of data mappers, setting goals and holding the team accountable

• Form good working relationship with business stakeholders and source systems SMEs

• Engage with solution architect and business stakeholders with clear communication, appropriate levels of context and explanation, using visual and data representations when needed, to effect decisions and direction of strategy, and bridge the gap between business and IT

Desired Skills and Experience

Our Requirements

1. Qualifications

• Degree in Computer Science, Business Information Systems or Finance / Insurance degree
• Certified Business Analysis (CBAP or equivalent)
• Certified Agile / Scrum practitioner will be an added advantage

b) Working Experience

• Minimum 4-5 years working experience in IT preferably in Insurance industry and experience implementing data warehousing projects for Insurance or Finance
• Minimum 3 years data mapping experience in Insurance domain and Financial reporting systems
• Ability to translate business requirements / rules documentation into data requirements and source-to-target ETL / ELT mappings for developers
• Strong understanding of AS400 / Oracle legacy insurance systems
• Proficient in SQL for data analysis of RDBMS and Hadoop
• Understanding of data models and ETL / ELT processing
• Familiarity with data model design processes
• Must be able to provide sample data mapping documents
• Experience in Data Warehouse a plus
• Good understanding of IFRS4 or IFRS17 is an advantage
• Good Insurance domain knowledge and knowledge of insurance products is preferred

c) Competencies

• Must possess excellent business oriented analytical skills
• Strong oral and written communication skills
• Organized with an eye for detail
• Team player and must be able work with cross IT and business teams
• Ability to multitask across different assigned tasks
• Fast learner to quickly understand new concepts

• High level of integrity takes accountability of work and good attitude over teamwork.
• Takes initiative to improve current state of things and adaptable to embrace new changes.