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.
Requirements
- 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
Top Skills
Caxton Associates London, England Office
40 Berkeley Square, , England , London, United Kingdom, W1J 5AL
