Database and Reporting Lead
full-time•Bengaluru
About this role
About Caxton Associates:
Caxton Associates, founded in 1983, is a global trading and investment firm with offices in New York, London, Singapore, Monaco and Dubai, and launching Bangalore in 2026. Caxton Associates’ primary business is to manage client and proprietary capital through global macro hedge fund strategies. As part of our continued growth, we are establishing a new office in Bangalore, India. This office will play a critical role in supporting our trading, research, and operations globally.
About the role:
We are seeking an experienced hands-on Database and Reporting Lead to build and lead our Bangalore database development function. This individual will both manage a small team of database specialists and remain hands-on in database design, development, and optimization.
The successful candidate will play a critical role in ensuring the fund’s data infrastructure is robust, scalable, and aligned with business needs. They will also oversee reporting and analytics delivery in Tableau, while driving improvements in data quality, performance, and usability. Some experience with cloud technologies (AWS RDS) is essential.
Responsibilities:
- Act as the hands-on technical lead for database and reporting development in Bangalore.
- Partner closely with the Technology team, Quant and Risk teams to develop and refine database, reporting and analytics solutions.
- Design, build, and optimize PostgreSQL and Microsoft SQL Server databases, including schemas, stored procedures, functions, and indexing.
- Work with Amazon RDS, Aurora PostgreSQL and S3 to build scalable, resilient data platforms.
- Design and maintain ETL pipelines for trades, positions, pricing, and reference data using Python and SQL.
- Build and maintain database-driven reports, dashboards, and analytics using Tableau.
- Ensure data integrity, security, and high availability across environments.
- Monitor and optimize database performance, identifying slow queries, indexing strategies, and query plans.
- 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.
- Create and maintain detailed documentation of database structures, processes, and best practices.
Experience:
- 10+ years of experience working extensively with relational databases in a hands-on capacity.
- Strong expertise in PostgreSQL, with solid experience in Microsoft SQL Server.
- Expertise in performance tuning, query optimization, indexing strategies, and troubleshooting database performance issues.
- Practical experience using Python for database automation, ETL, and data transformation.
- Experience building reports and dashboards using Tableau.
- Experience working with AWS RDS, Aurora PostgreSQL, and Amazon S3.
- Proven experience in leading / managing teams in a high-performance environment.
- Experience with Iceberg table architectures (AWS-managed or open-source) is a strong advantage.
- Familiarity with Parquet based data formats is a plus.
- Proven ability to lead technically, mentor others, and collaborate with senior stakeholders.
- Experience in database maintenance tasks, backups, restores, security management, and disaster recovery.
- Experience in financial services environments is preferred.
What you'll do
- The Database and Reporting Lead will act as the hands-on technical lead for database and reporting development, managing a small team while ensuring robust data infrastructure. They will also oversee reporting and analytics delivery in Tableau and drive improvements in data quality and performance.
About Caxton Associates
Caxton Associates, founded in 1983, is a global trading and investment firm with offices in New York, London, 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.
Ready to join Caxton Associates?
Take the next step in your career journey
Frequently Asked Questions
What does a Database and Reporting Lead do at Caxton Associates?
As a Database and Reporting Lead at Caxton Associates, you will: the Database and Reporting Lead will act as the hands-on technical lead for database and reporting development, managing a small team while ensuring robust data infrastructure. They will also oversee reporting and analytics delivery in Tableau and drive improvements in data quality and performance..
Is the Database and Reporting Lead position at Caxton Associates remote?
The Database and Reporting Lead position at Caxton Associates is based in Bengaluru, India. Contact the company through Clera for specific work arrangement details.
How do I apply for the Database and Reporting Lead position at Caxton Associates?
You can apply for the Database and Reporting Lead position at Caxton Associatesdirectly through Clera. Click the "Apply Now" button above to start your application. Clera's AI-powered platform will help match your profile with this opportunity and guide you through the application process.