Index Data Specialist: Market Data & Validation

Hong Kong Exchanges and Clearing Limited; Hong Kong; On-site; HKD 420,000 - 720,000; Full time

Job summary

HKEX in Hong Kong is seeking a Data Specialist for the Data Business department to act as the key data partner for index ideation, back-testing and regular review and rebalancing activities.

You will collect, cleanse and transform market data from internal and external sources, ensuring timely availability and accuracy. Strong collaboration with IT, Research and Operations is essential, with proficiency in Python, SQL, VBA and Excel.

Qualifications

• 3+ years of experience in market/financial data, index/data business, or related fields.
• Proficiency in Python, SQL, VBA and Excel formulas.
• Exposure to Hong Kong and China equity markets is a plus.
• Strong analytical, problem-solving and collaboration skills.

Responsibilities

• Ensure timely, accurate market and financial data to support index ideation, back-testing and rebalancing.
• Collect, cleanse, classify and transform data from internal and external sources.
• Collaborate with IT, Research, Sales and Operations to deliver data solutions.
• Maintain well-structured datasets and supporting documentation for easy consumption.
• Perform data quality checks and reconciliations to identify and resolve issues.

Skills

Python

SQL

VBA

Excel

Data analysis

Collaboration

Education

Bachelor's degree or equivalent

Job description

HKEX in Hong Kong is seeking a Data Specialist for the Data Business department to act as the key data partner for index ideation, back-testing and regular review and rebalancing activities.

You will collect, cleanse and transform market data from internal and external sources, ensuring timely availability and accuracy. Strong collaboration with IT, Research and Operations is essential, with proficiency in Python, SQL, VBA and Excel.