Data & Index Specialist: Market Data & Validation

Hong Kong Exchanges & Clearing Ltd; Hong Kong; On-site; HKD 600,000 - 1,200,000; Full time

Job summary

Hong Kong Exchanges & Clearing Ltd in Hong Kong is seeking a data professional to join the Data Business department and serve as the key data partner for index ideation, back-testing and rebalancing. You will collect, cleanse, and transform market and financial data from internal and external sources, and work with IT, Research, Sales and Operations to deliver scalable data solutions.

The role requires 3+ years of relevant experience, proficiency in Python, SQL, VBA and Excel formulas, and

Qualifications

• 3+ years of experience in market/financial data or index data.
• Good understanding of market and financial data.
• Hands-on experience in data collection, cleansing, classification and transformation.
• Proficiency in Python, SQL, VBA and Excel formulas.

Responsibilities

• Ensure sufficient, accurate and timely market and financial data to support index ideation, back-testing, and regular index review and rebalancing activities.
• Collect, cleanse, classify and transform market, reference and financial data from internal and external sources.
• Work closely with internal teams to understand their data needs and existing challenges, and deliver practical data solutions.
• Organize and maintain well-structured datasets and supporting documentation to ensure data can be consumed effectively.
• Perform data quality control, including validation checks and reconciliations, to ensure timely identification and resolution of data issues.
• Develop data processing and validation tools to make data operations more efficient and scalable.
• Leverage strengths as a team player to collaborate across various functions including IT, Research, Sales and Operations to ensure execution of index development projects.

Skills

Attention to detail

Analytical thinking

Collaboration and communication

Languages: English Cantonese Mandarin

Education

Relevant university degree or equivalent

Tools

Python

SQL

VBA

Excel formulas

Job description

Hong Kong Exchanges & Clearing Ltd in Hong Kong is seeking a data professional to join the Data Business department and serve as the key data partner for index ideation, back-testing and rebalancing. You will collect, cleanse, and transform market and financial data from internal and external sources, and work with IT, Research, Sales and Operations to deliver scalable data solutions.

The role requires 3+ years of relevant experience, proficiency in Python, SQL, VBA and Excel formulas, and