Data Mapper

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. The group wide solution is to be rolled out to all entities under the Group in Singapore, Malaysia and Indonesia.

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

Our Requirements:

a) 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

. Strong proficiency 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.