Database and Analytics Developer

Caxton Associates; London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading investment firm in London is seeking a Database Developer to design and maintain their Risk database and workflows. The role involves optimizing database performance and creating visual reports using Tableau. Candidates should have extensive experience with SQL Server and Python, along with a strong focus on data integrity and security.

Qualifications

• At least 5 years working with SQL Server databases.
• Experience using Python for scripting database tasks.
• Familiarity with Tableau or similar tools.

Responsibilities

• Design and implement efficient database schemas and stored procedures.
• Develop and maintain SQL queries and ETL processes.
• Build and maintain database-driven reports and dashboards.

Skills

SQL

Python

Data Visualization

Tools

SQL Server

Tableau

SSIS

Job description

1 month ago Be among the first 25 applicants

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.

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.

About the role:

This role involves designing, developing, and maintaining our main Risk database and workflows—ensuring robust structures, referential integrity, and optimal performance. Additionally, the role includes building Tableau reports and dashboards, translating data into clear visualisations to support the Risk team.

Responsibilities:

• Working closely with the 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
• Identifying and resolve data integrity issues
• Managing the reporting and analytics platforms to ensure that reporting jobs are successfully run
• Monitor and optimize database performance, identifying slow queries, indexing strategies, and query plans.
• Build and maintain database-driven reports, dashboards, and analytics using Tableau
• Design, maintain, enhance ETL processes for all aspects of the firm's positions, trades and pricing information
• Ensure regular database maintenance, including backups, recovery processes, and routine integrity checks
• Implement database security best practices, including user permissions and roles
• Create and maintain detailed documentation of code, database structures, processes, and best practices
• Industrialise and maintain risk system feeds and workflows
• Take ownership of a small subset of raw data reporting requirements to external stakeholders
  
  
  

Requirements

• At least 5 years working extensively with SQL Server databases (T-SQL queries, stored procedures, views, functions)
• Experience using Python for scripting database tasks, automating workflows, data extraction, and transformation processes
• Proven experience designing normalised and optimised relational database schemas
• Experience in performance tuning, query optimization, indexing strategies, and troubleshooting database performance issues
• Experience building, maintaining, and optimizing ETL processes using tools such as SQL Server Integration Services (SSIS) or custom scripts
• Familiarity with Tableau or similar tools for reporting and data visualisation
• Experience in database maintenance tasks, backups, restores, security management, and disaster recovery
• Demonstrated ability to effectively collaborate with stakeholders, including developers, analysts, and business teams, to gather requirements and deliver database solutions
• Displays and operates at the highest degree of ethics and integrity

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Caxton Associates by 2x

Sign in to set job alerts for “Database Developer” roles.

London, England, United Kingdom 2 months ago

SQL Database Developer - Up to £80k Base Salary + Bonus

JUNIOR DATABASE ADMINISTRATOR LONDON HEDGEFUND

London, England, United Kingdom 4 days ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom $100,000.00-$180,000.00 1 month ago

Croydon, England, United Kingdom 1 day ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 3 days ago

Hedge Fund - Risk Database and Analytics Developer

London, England, United Kingdom 2 weeks ago

City Of London, England, United Kingdom 1 month ago

London, England, United Kingdom 3 months ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 16 hours ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 3 days ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 2 days ago

Database Infrastructure Engineer - Engine by Starling

London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 month ago

Greater London, England, United Kingdom 2 days ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 day ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 day ago

Teddington, England, United Kingdom 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.