Database and Analytics Developer

Global trading and investment firm founded in 1983, specializing in discretionary global macro investing with offices worldwide.
Data
Mid-Level Software Engineer
Hybrid
5+ years of experience
Finance

Description For Database and Analytics Developer

Caxton Associates, a prestigious global trading and investment firm established in 1983, is seeking a Database and Analytics Developer to join their technology team. With offices spanning New York, London, Monaco, Singapore, and Dubai, Caxton Associates specializes in managing client and proprietary capital through discretionary global macro investing across diverse asset classes and markets.

The role focuses on designing, developing, and maintaining the firm's primary Risk database and workflows. The successful candidate will be responsible for ensuring robust database structures, maintaining referential integrity, and optimizing performance. A key aspect of the position involves creating Tableau reports and dashboards to transform complex data into clear visualizations that support the Risk team's decision-making processes.

The ideal candidate should bring at least 5 years of extensive experience with SQL Server databases, strong Python scripting capabilities, and proven expertise in database optimization and ETL processes. They should be proficient in designing normalized database schemas, implementing security best practices, and maintaining comprehensive documentation. Experience with Tableau or similar visualization tools is essential for creating impactful reports and dashboards.

This hybrid role offers an opportunity to work with a leading investment firm, contributing to critical risk management infrastructure while collaborating with various stakeholders across the organization. The position requires someone who can maintain the highest standards of ethics and integrity while delivering robust database solutions that support the firm's global operations.

Last updated 24 days ago

Responsibilities For Database and Analytics Developer

  • Work closely with Risk team to develop and refine reporting and analytics requirements
  • Design and implement efficient database schemas, tables, indexes, and stored procedures
  • Develop, optimize, and maintain SQL queries, stored procedures, views, and functions
  • Identify and resolve data integrity issues
  • Manage reporting and analytics platforms
  • Monitor and optimize database performance
  • Build and maintain database-driven reports and dashboards using Tableau
  • Design, maintain, enhance ETL processes
  • Ensure regular database maintenance and backups
  • Implement database security best practices
  • Create and maintain detailed documentation
  • Industrialise and maintain risk system feeds and workflows
  • Take ownership of raw data reporting requirements to external stakeholders

Requirements For Database and Analytics Developer

Python
  • At least 5 years working extensively with SQL Server databases
  • Experience using Python for scripting database tasks
  • Proven experience designing normalised and optimised relational database schemas
  • Experience in performance tuning, query optimization, and indexing strategies
  • Experience building and optimizing ETL processes using SSIS or custom scripts
  • Familiarity with Tableau or similar tools for reporting and data visualisation
  • Experience in database maintenance tasks, backups, and security management
  • Demonstrated ability to collaborate with stakeholders
  • Displays and operates at the highest degree of ethics and integrity

Interested in this job?

Jobs Related To Caxton Associates Database and Analytics Developer

Business Intelligence Engineer

Business Intelligence Engineer role at Amazon, focusing on data analysis, BI solutions, and machine learning implementation using AWS services.

Data Engineer, Alexa Enterprise Data

Lead data engineering role at Amazon's Alexa Enterprise team, building scalable data infrastructure and analytics solutions using AWS technologies.

Data Engineer

Data Engineer position at Diamond Foundry focusing on developing and maintaining data pipelines for manufacturing and business data analysis.

Data Engineer II

Microsoft is hiring a Data Engineer II to join their Security Customer Experience team, focusing on data platform development and analytics for security products.

Research Engineer, Societal Impacts

Research Engineer role at Anthropic focusing on building infrastructure to study AI societal impacts