Data Warehouse Analyst Programmer

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

Job summary

A consulting firm in Hong Kong is seeking a Data Warehouse Analyst Programmer to conduct user requirement analysis, design data layers, and implement efficient data pipelines. The ideal candidate will have at least 4 years of IT experience, with 2 years in data warehousing/ETL development, and solid programming skills in Python or Java. Familiarity with cloud platforms like AWS or GCP, and experience with ETL tools such as Informatica PowerCenter and SSIS are preferred. Competitive salary offered.

Qualifications

• Minimum 4 years of IT experience with at least 2 years in data warehousing/ETL development.
• Hands-on experience with ETL tools such as Informatica PowerCenter and SSIS.
• Experience in cloud platforms like AWS or GCP is a plus.

Responsibilities

• Conduct user requirement analysis, design and implement data layer for analysis and reporting.
• Implement efficient data pipelines to transform data from multiple sources.
• Support user acceptance testing.
• Provide ongoing user support on the data warehouse.

Skills

Data warehousing

ETL development

Python

Java

Oracle PL/SQL

Education

Degree in Computer Science or equivalent

Tools

Informatica PowerCenter

SSIS

AWS

GCP

Tableau

Google Data Studio

QlikView

Job description

SW8335 |28 Jun 2022 Data Warehouse Analyst Programmer

• Conduct user requirement analysis, design and implement data layer for analysis and reporting
• Implement efficient data pipelines to transform data from multiple data sources (i.e. ETLs)
• Support user acceptance testing
• Provide ongoing user support on data warehouse

• Degree in Computer Science or equivalent
• Minimum 4 years of IT experience with at least 2 years in data warehousing/ ETL development
• Hands on experience with ETL tools such as Informatica PowerCenter, SSIS
• Solid programming skills in Python/Java and Oracle PL/SQL
• Experience in cloud platform would be an added advantage, e.g. AWS, GCP
• Experience in visualization tools would be an added advantage, e.g. Tableau, Google data studio, QlikView