Associate - Index
Core
Key data partner ensuring accurate market and financial data availability for index ideation, back-testing, review, and rebalancing.
Role type
Associate - Index Data Specialist
Builds
Well-structured datasets, data processing tools, and supporting documentation for index products.
Domain
Financial markets / Index products
Required skills
Data collection, Data cleansing, Data classification, Data transformation, Data validation, Data reconciliation, Python, SQL, VBA, Excel formulas, Market data understanding, Index business knowledge
Preferred skills
Hong Kong equity market exposure, China equity market exposure
Technologies
Python, SQL, VBA, Excel
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. 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. Work closely with internal teams to understand their data needs and existing challenges, and deliver practical data solutions.
Seniority
Associate, hands-on IC
