Job Description

Caxton Associates, founded in 1983, is a global trading and investment firm with offices in New York, London, Singapore, Monaco, Bangalore and Dubai. Our primary business is to manage client and proprietary capital through global macro hedge fund strategies.

The role

We are seeking a Database Engineer to join our Bangalore-based technology team. This is a hands-on role with significant ownership of core data platform components, focused on their design, development, and optimization.

You will work closely with global teams across London and New York. You will also play a key role in shaping and scaling the firm’s data platform, directly supporting trading and investment decision-making globally. The role requires strong technical expertise, attention to data quality, and the ability to operate in a fast-paced, business-critical environment.

Key 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
• Support and improve global data platform operations across multiple regions
• Create and maintain detailed documentation of database structures, processes, and best practices

Requirements

• Degree in Computer Science, Physics, Mathematics or a related field
• Minimum 5 years of 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
• Experience in a bank, hedge fund, broker, or trading environment is preferred