Associate, Execution Consulting Group

COMPANY OVERVIEW: CLSA is an Asia’s leading capital markets and investment group, connecting global investors to insights, liquidity and capital to drive their investment strategies. Award-winning research, an extensive Asia footprint, direct links to China and highly experienced finance professionals differentiate our innovative products and services in asset management, alternative investment, corporate finance, capital markets, securities and wealth management. As the international platform of CITIC Securities, China’s largest investment bank, CLSA is uniquely positioned to facilitate cross border capital flows and bridge China to the world and the world to China. Founded in 1986 and headquartered in Hong Kong, CLSA operates from 20 cities across Asia, Australia, the Americas and Europe. For further information, please visit www.clsa.com. Department Summary: The Execution Consulting Group (ECG) is a part of the Equities Division of CLSA. It has a cross-region (APAC, EMEA and Americas) and cross-channel (DSA, PT and Cash) mandate to provide execution consultancy services to equity sales traders and CLSA’s clients. The primary areas of ECG’s work include market microstructure, optimal execution, pre-trade and post-trade analysis, and bespoke research and consultancy. Position Description / Job Responsibilities: Sourcing, processing and aggregating tick data, order data, and execution data from ECG’s various sources (Bloomberg, Reuters, OneTick, internal databases, vendors, etc.) managing large datasets (currently organized as flat files and data objects) data processing and data mining to drive publications and execution analysis for clients building, organizing, maintaining, and enhancing the group’s infrastructure in R producing graphics and interactive exhibits using ggplot and Quarto in R generating periodic and ad-hoc publications for CLSA’s sales traders and clients providing consultancy services to ECG’s internal and external clients actively contributing to ECG’s brand and the group’s publications on market microstructure, index events, and optimal execution Essential Skills and Experience: Required: Strong programming skills with demonstrable experience in (or ability to learn) R or Python Required: Ability to work with large datasets involving millions of observations Required: Basic knowledge of SQL or a similar query language Required: Strong oral and written communication skills for client interaction Desired: Statistical modelling skills Desired: Ability to organize data in simple databases Desired: Advanced knowledge of Excel and shell scripting Desired: Working knowledge of finance and equities trading Educational / Professional Qualifications: The ideal hire will have an engineering degree and 3-5 years of professional experience in equity quantitative analysis or big data analysis with hands-on experience in R or Python