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.

• 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