Database and Analytics Developer

TN United Kingdom; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

An established industry player is seeking a Database and Analytics Developer to enhance their Risk database and analytics capabilities. This role involves designing efficient database schemas, optimizing SQL queries, and building insightful Tableau dashboards. You will collaborate closely with the Risk team to ensure data integrity and performance while implementing best practices for database security and maintenance. Join a dynamic team where your contributions will directly impact decision-making processes and support a robust trading environment. If you are passionate about data and analytics, this opportunity is perfect for you.

Qualifications

• 5+ years of experience with SQL Server databases, including T-SQL queries and stored procedures.
• Experience using Python for automating workflows and data transformation.

Responsibilities

• Design and maintain the Risk database and ensure optimal performance.
• Build and maintain database-driven reports and dashboards using Tableau.

Skills

SQL Server (T-SQL)

Python

Database Performance Tuning

ETL Processes

Tableau

Tools

SQL Server Integration Services (SSIS)

Tableau

Job description

Social network you want to login/join with:

Database and Analytics Developer, London

col-narrow-left

Client:

Caxton Associates

Location:

London, United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Reference:

a9dff385f515

Job Views:

7

Posted:

26.04.2025

Expiry Date:

10.06.2025

col-wide

Job Description:

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.