Database Engineer

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:

1. Collaborate with Technology, Quant, and Risk teams to deliver data solutions for reporting and analytics
2. Design and implement scalable database schemas, tables, indexes, and stored procedures
3. Develop and maintain Python ETL pipelines for trade, position, and pricing data
4. Build and support reporting and visualization solutions using Tableau
5. Ensure data integrity, security, and high availability across production and non-production environments
6. Monitor and optimize database performance (query tuning, indexing, execution plans)
7. Work with AWS services (RDS, Aurora, S3) to build scalable, resilient data platforms
8. Perform database maintenance, including backups, recovery, and integrity checks
9. Implement database security best practices, including user permissions and roles
10. Create and maintain detailed documentation of database structures, processes, and best practices

Experience:

1. At least 5 years experience working with relational databases
2. Strong SQL skills, including T-SQL, stored procedures, views, and functions
3. Proven experience in database design (normalisation, optimisation, indexing strategies)
4. Solid experience in performance tuning and troubleshooting database issues
5. Experience with data visualisation tools (e.g. Tableau or similar)
6. Experience using Python for data processing, automation, and ETL workflows
7. Familiarity with CI/CD pipelines and version control (Git)
8. Practical experience with database administration (backups, restores, security, DR)
9. Experience with AWS cloud services (RDS, Aurora, S3)
10. Familiarity with financial services environments is a plus
11. Displays and operates at the highest degree of ethics and integrity.