Analyst Programmer (Data Management)

Hong Kong Genome Institute; Hong Kong; On-site; HKD 420,000 - 660,000; Full time

Job summary

Hong Kong Genome Institute is seeking an Analyst Programmer (Data Management) to support a new data warehouse for genomic data. You will help design, develop, and maintain scalable data storage and processing pipelines in a bilingual environment.

The role requires 4+ years of experience, strong ETL and data modelling skills, plus proficiency in Java or Python. Office location is Hong Kong Science Park, Shatin, with a two‑year contract and attractive remuneration.

Qualifications

• A bachelor’s degree in Computer Science or a related field.
• At least 4 years of relevant working experience.
• Strong understanding of data warehouse principles, data modelling, ETL processes.
• Experience with Linux, shell scripting, system monitoring and performance tuning.
• Proficiency in Java or Python.

Responsibilities

• Assist in building a robust, scalable, high‑performance data storage and management system for genomic data.
• Develop and document architecture, data models, data flows, and system interfaces.
• Identify and fix performance bottlenecks in data storage and retrieval.
• Create a scalability plan to handle rapid genomic data growth.
• Prepare docs and perform SDLC testing (unit, SIT, UAT, load, regression).
• Support routine ops to maintain system efficiency and reliability.
• Perform other duties as assigned by senior officers.

Skills

Data warehousing

ETL processes

CI/CD DevOps

Java

Python

Linux administration

Docker

Kubernetes

English & Cantonese

Security & access control

Education

Bachelor's degree in Computer Science

Tools

Clickhouse

MySQL

PostgreSQL

AWS RDS

S3

Docker

Kubernetes

Job description

The Analyst Programmer (Data Management) supports the System Analyst (Data Management) in HKGI’s data warehouse project, focusing on the design, development and maintenance of a new data warehouse platform for managing bioinformatic and genomic data, which aims to consolidate data from various existing platforms. The incumbent will assist in refining platform architecture, optimising performance, and ensuring scalability.

Key Responsibilities

• Assist in implementing a robust, scalable and high-performance data storage and management system for genomic data
• Assist in developing and documenting system architecture, data models, data flow diagrams, and system interfaces
• Contribute to identifying and addressing performance bottlenecks within the data storage and retrieval pipeline
• Assist in developing and implementing a scalability plan to accommodate the rapid growth of genomic data
• Prepare documentation and conduct various testing activities throughout the whole SDLC cycle (e.g. unit tests, SIT, UAT, load tests, regression tests) to ensure all functional and operational requirements are met
• Support routine operational activities to maintain system efficiency and reliability
• Perform any other duties assigned by senior officers

Requirements

We are seeking a high-calibre candidate for the post of Analyst Programmer (Data Management) who possesses:

• A bachelor’s degree in Computer Science or a related field, with at least 4 years of relevant working experience
• Strong understanding of data warehouse principles, data modelling, ETL (Extract, Transform, Load) processes
• Experience with various storage technologies, including object storage (e.g., S3), parallel file systems, and databases (e.g., Clickhouse, MySQL, PostgreSQL, AWS RDS)
• Experience with cloud-based data technologies, as well as data security and access control mechanisms
• Familiarity with Linux system administration, including shell scripting, system monitoring, and performance tuning
• Knowledge of containerisation using Docker and deploying on the Kubernetes platform
• Knowledge of CI/CD pipeline and related DevOps technologies
• Proficiency in at least one of these programming languages: Java, Python
• A keen focus on platform-level optimisation to enhance performance and scalability
• Good command of written and spoken English and Cantonese; proficiency in Mandarin is an advantage

Preferred Attributes

• Experience with genomic data analysis and bioinformatics tools
• Experience with healthcare interoperability standards, particularly FHIR and HL7
• Experience with on-premises storage or systems is a plus

Office Location:

Hong Kong Science Park, Shatin

Remuneration

Successful candidate will be offered attractive remuneration and be appointed on an initial two-year contract (subject to mutual agreement for contract renewal).

Data collected will be used for recruitment purpose only.