Database and Reporting Lead
Caxton Associates
Full-time|On-site|Bengaluru, Karnataka, India About Caxton Associates:Established in 1983, Caxton Associates is a prestigious global trading and investment firm with a presence in major financial hubs including New York, London, Singapore, Monaco, and Dubai, and is set to launch an office in Bangalore in 2026. Our primary focus is on managing client and proprietary capital through innovative global macro hedge fund strategies. Our new Bangalore office will be pivotal in enhancing our trading, research, and operational capabilities across the globe.About the Role:We are on the lookout for a seasoned Database and Reporting Lead to spearhead our database development function in Bangalore. This role requires an individual who is not only adept at managing a small team of database specialists but is also hands-on in database design, development, and optimization.The ideal candidate will be instrumental in ensuring the robustness, scalability, and alignment of our data infrastructure with business objectives. You will oversee the delivery of reporting and analytics via Tableau, driving enhancements in data quality, performance, and usability. Familiarity with cloud technologies, particularly AWS RDS, is essential.Key Responsibilities:Serve as the technical lead for database and reporting development in Bangalore.Collaborate closely with the Technology, Quant, and Risk teams to design and refine database, reporting, and analytics solutions.Design, build, and optimize PostgreSQL and Microsoft SQL Server databases, focusing on schemas, stored procedures, functions, and indexing.Utilize Amazon RDS, Aurora PostgreSQL, and S3 to establish scalable, resilient data platforms.Create and maintain ETL pipelines for trades, positions, pricing, and reference data using Python and SQL.Develop and sustain database-driven reports, dashboards, and analytics through Tableau.Ensure the integrity, security, and high availability of data across all environments.Monitor and enhance database performance, identifying slow queries and optimizing indexing strategies.Manage and mentor a small team of database developers and reporting specialists.Implement and oversee database maintenance processes including backups, restores, disaster recovery, and access controls.Document database structures, processes, and best practices comprehensively. Required Experience:Over 10 years of extensive hands-on experience with relational databases.Deep expertise in PostgreSQL, alongside solid experience in Microsoft SQL Server.Proficient in performance tuning, query optimization, indexing strategies, and troubleshooting database performance issues.Hands-on experience with Python for database automation, ETL processes, and data transformation....
Jan 29, 2026