LiftmyCVLiftmyCV
CA

Database and Reporting Lead

Caxton AssociatesOn-siteBengaluru, Karnataka, India

Job description

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.

Job details

Published
January 29, 2026
Job source
jworkable
Workplace
On-site · Bengaluru, Karnataka, India
First seen
January 29, 2026
AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Caxton Associates

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.