Data Warehouse Management Specialist

Day-to-day activities

• Responsible for design, model and implementation of data warehousing activities like understanding all sources, getting data from the sources to the warehouse etc.
• Program and configure database information and provide support to warehouse users
• Work with ETL Architect to define standards and procedures; refine methods and techniques for data extraction, transformation and loading (ETL).
• Define robust well documented ETL design which is easy to understand and performs well
• Design an efficient ETL job scheduling mechanism
• Evaluate, determine root cause and resolve production issues
• Adopt usage of change and issue management tools such as Jira.
• Work closely with other IT development groups to deliver coordinated software solutions
• Identify and automate ETL processes to achieve high efficiency such as data re-conciliation, data availability alerts publication etc.
• Undertake other tasks assigned by Unit Head of Data Warehouse Management

Background

• University Graduate, major: Computer Science, IT or Business Management
• At least  2+ years’ experience working in Data mart/warehousing project, preferably working in Financial Services sector

Competencies (skills & abilities)

• Good understanding of ETL & DW processes
• Hands on experience with database and ETL technologies (IBM Netezza, Oracle, IBM Data Stage and SAS Enterprise Guide)
• Expert command on PL-SQL & UNIX scripting
• Basic understanding of the normalized and dimensional data modeling skills
• Good communication skills
• Ability to work under pressure