About Caxton Associates:
Caxton Associates, founded in 1983, is a global trading and investment firm with offices in New York, London, Bengaluru, Monaco, Singapore and Dubai. Caxton Associates’ primary business is to manage client and proprietary capital through a suite of products designed to fit the specific needs of investors. Employing a multi-portfolio manager framework, Caxton excels in discretionary global macro investing, leveraging its diversified expertise across asset classes and markets.
About the role:
We are seeking a Database Engineer to join our London-based technology team. This is a hands-on role focused on design, development, and optimisation of the firm’s core data platforms.
You will play a key role in shaping and scaling the firm’s data platform, directly supporting trading and investment decision-making. The role requires strong technical expertise, attention to data quality, and the ability to operate in a fast-paced, business-critical environment.
Responsibilities:
*Collaborate with Technology, Quant, and Risk teams to deliver data solutions for reporting and analytics
*Design and implement scalable database schemas, tables, indexes, and stored procedures
*Develop and maintain Python ETL pipelines for trade, position, and pricing data
*Build and support reporting and visualization solutions using Tableau
*Ensure data integrity, security, and high availability across production and non-production environments
*Monitor and optimize database performance (query tuning, indexing, execution plans)
*Work with AWS services (RDS, Aurora, S3) to build scalable, resilient data platforms
*Perform database maintenance, including backups, recovery, and integrity checks
*Implement database security best practices, including user permissions and roles
*Create and maintain detailed documentation of database structures, processes, and best practices
Experience:
*At least 5 years experience working with relational databases
*Strong SQL skills, including T-SQL, stored procedures, views, and functions
*Proven experience in database design (normalisation, optimisation, indexing strategies)
*Solid experience in performance tuning and troubleshooting database issues
*Experience with data visualisation tools (e.g. Tableau or similar)
*Experience using Python for data processing, automation, and ETL workflows
*Familiarity with CI/CD pipelines and version control (Git)
*Practical experience with database administration (backups, restores, security, DR)
*Experience with AWS cloud services (RDS, Aurora, S3)
*Familiarity with financial services environments is a plus
*Displays and operates at the highest degree of ethics and integrity.