Junior Data Analyst (Sales Analysis)

HKT; Hong Kong; On-site; HKD 380,000 - 560,000; Full time

Job summary

HKT is seeking a data professional to conduct data mining, cleaning, and exploration of both structured and unstructured data. The role involves ETL, data mapping, and maintaining local and cloud databases to ensure data integrity.

You will analyze sales performance across lines of business to maximize revenue and support cross-selling. The candidate should be proficient in SQL, Python, BigQuery, Redshift, SQL Server, Excel, and Tableau.

Qualifications

• Experience in SQL is a must; Python, GCP BigQuery, AWS Redshift, SQL Server, Excel.
• Practical experience with visualization tools such as Tableau is a plus.
• Proactive, passionate about data, and a strong team player.
• Proficient in written and spoken English and Chinese.

Responsibilities

• Conduct data mining, cleaning, and exploration of structured and unstructured data.
• Perform ETL processes, and data mapping activities.
• Develop and maintain databases locally and in the cloud to ensure data integrity.
• Analyze sales performance across lines of business to maximize revenue and cross-sell.
• Design and enhance reports and dashboards using visualization tools for stakeholders across the group.
• Create data models, glossary creation, and evaluate AI performance.

Skills

SQL

Python

Tableau

Data analysis

Team player

Bilingual English/Chinese

Education

Bachelor's degree in CS/DS

Tools

GCP BigQuery

AWS Redshift

Microsoft SQL Server

Excel

Job description

• Conduct data mining, cleaning, and exploration of structured and unstructured data.
• Perform ETL processes, and data mapping activities.
• Develop and maintain both local and cloud databases platforms to ensure the data integrity.
• Analyze sales performance across various lines of business to maximize revenue and leverage cross-selling.
• Design and enhance reports and dashboards using visualization tools for stakeholders across the group.
• Create data models, customize instructions, create a glossary, and evaluate AI performance.

To succeed in this role:

• Bachelor's degree in Computer Science, Data Science or other relevant disciplines.
• Experience in SQL is a must, Python, GCP BigQuery, AWS Redshift, Microsoft SQL Server, Excel.
• Practical experience in working with visualization tools particularly Tableau is an advantage.
• Proactive and passionate about data.
• Great team player and willing to learn.
• Proficient in both written and spoken English & Chinese.