Analyst Programmer (Data Warehouse/ ETL)

Swing Consulting Ltd.; Hong Kong; On-site; HKD 400,000 - 600,000; Full time

Job summary

A consulting firm in Hong Kong is looking for an experienced Analyst Programmer to contribute to data warehouse design and administration. The ideal candidate will have over 5 years of IT experience, including at least 3 years in data warehouse administration, possess strong technical skills in ETL processes, and be proficient in both English and Chinese. This role includes responsibilities such as providing support to maintenance teams and delivering training sessions.

Qualifications

• Degree holder in Computer Science or related discipline.
• Minimum 5 years of IT experience, including minimum 3 years of data warehouse administration.
• Good command of both written and spoken English and Chinese, preferably can speak Mandarin.

Responsibilities

• Perform all activities related to the data warehouse overall design, administration, maintenance, and enhancement.
• Provide advice and technical support to the maintenance teams.
• Design and implement business intelligence applications including data mining.
• Produce and maintain relevant documentation.
• Establish and maintain policies and procedures for data warehouse management.
• Deliver training sessions.

Skills

Data warehouse design and administration

ETL processes

Business intelligence applications

Good attitude

Team player

Fluent in English and Chinese

Education

Degree in Computer Science or related discipline

Tools

Cognos

Crystal Report

SAS

Job description

SW9987 |22 Jun 2020 Analyst Programmer (Data Warehouse/ ETL)

Responsibilities

• Perform all activities related to the data warehouse overall design, administration, maintenance, enhancement, testing, performance tuning, etc.
• Provide advice and technical supports to the maintenance teams
• Design and implement business intelligence applications including data mining
• Produce and maintain relevant documentation
• Establish and maintain policies and procedures pertaining to the management, security, and use of the data warehouse/database
• Deliver training sessions

Qualifications

• Degree holder in Computer Science or related discipline
• Minimum 5 years of IT experience, including minimum 3 years of data warehouse administration experience
• Good attitude and self-motivated
• Able to work independently also a good team player
• Good command of both written and spoken English and Chinese, preferable can speak Mandarin

Preferred Experience

• Extract Transform Load (ETL)
• BI reporting (e.g.: "Cognos, Crystal Report, SAS, etc.")