Qualifications
Key Responsibilities:Collaborate closely with Technology, Quant, and Risk teams to create data-driven solutions for reporting and analytics.Design and implement scalable database architectures, including 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 both production and non-production environments.Monitor and enhance database performance through query optimization, indexing, and execution plans.Utilize AWS services (RDS, Aurora, S3) to construct scalable and resilient data platforms.Perform essential database maintenance operations such as backups, recovery, and integrity checks.Implement best practices for database security, including user permissions and roles management.Create and maintain comprehensive documentation on database structures, processes, and best practices.Experience Required:A minimum of 5 years working with relational databases.Exceptional SQL skills, including T-SQL, stored procedures, views, and functions.Demonstrated experience in database design (normalization, optimization, indexing strategies).Proven expertise in performance tuning and database issue troubleshooting.Experience with data visualization tools, such as Tableau or equivalent.Proficiency in Python for data processing, automation, and ETL workflows.Familiarity with CI/CD pipelines and version control systems (Git).Practical experience in database administration tasks (backups, restores, security, DR).Experience with AWS cloud services (RDS, Aurora, S3).Familiarity with financial services environments is advantageous.Exhibit the highest standards of ethics and integrity.
About the job
About Caxton Associates:
Founded in 1983, Caxton Associates is a premier global trading and investment firm, with a presence in key financial hubs including New York, London, Bengaluru, Monaco, Singapore, and Dubai. Our firm is dedicated to managing client and proprietary capital, offering a diverse range of products specifically tailored to meet the unique needs of our investors. By employing a multi-portfolio manager framework, we excel in discretionary global macro investing, leveraging extensive expertise across various asset classes and markets.
About the Role:
We are on the lookout for a skilled Database Engineer to enhance our London-based technology team. This hands-on position is pivotal in the design, development, and optimization of the company's core data platforms. You will be instrumental in shaping and scaling our data architecture, directly influencing trading and investment decisions. Candidates must possess strong technical skills, a keen eye for data quality, and the ability to thrive in a dynamic, high-stakes environment.
About Caxton Associates
Caxton Associates is a leading global trading and investment firm established in 1983, known for its innovative approach to managing diverse portfolios across various asset classes. With offices in major financial centers worldwide, we are committed to delivering exceptional investment solutions tailored to our clients' specific needs.