Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and maintain our Risk database, build Tableau reports, and ensure data integrity.
- Company: Join Caxton Associates, a global trading firm with a rich history in investment management.
- Benefits: Enjoy a full-time role with competitive salary and opportunities for professional growth.
- Why this job: Be part of a dynamic team, enhancing your skills in data analytics and visualisation.
- Qualifications: 5+ years of SQL Server experience, Python scripting, and familiarity with Tableau required.
- Other info: Work in a collaborative environment with a focus on ethics and integrity.
The predicted salary is between 28800 - 42000 £ per year.
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
Database and Analytics Developer employer: Caxton Associates
Contact Detail:
Caxton Associates Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database and Analytics Developer
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as SQL Server, T-SQL, and Tableau. Having hands-on experience or projects that showcase your skills in these areas can set you apart from other candidates.
✨Tip Number 2
Network with professionals in the finance and analytics sectors, especially those who work at Caxton Associates or similar firms. Engaging with them on platforms like LinkedIn can provide insights into the company culture and potentially lead to referrals.
✨Tip Number 3
Prepare to discuss your previous experiences with database performance tuning and ETL processes in detail during interviews. Be ready to share specific examples of challenges you've faced and how you resolved them, as this will demonstrate your problem-solving abilities.
✨Tip Number 4
Stay updated on the latest trends in data analytics and database management. Being knowledgeable about new tools and techniques can help you impress interviewers and show that you're committed to continuous learning in your field.
We think you need these skills to ace Database and Analytics Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server databases, Python scripting, and ETL processes. Use specific examples that demonstrate your skills in database design, performance tuning, and collaboration with stakeholders.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role at Caxton Associates. Mention how your background aligns with their needs, particularly in developing and maintaining risk databases and creating Tableau reports.
Showcase Relevant Projects: If you have worked on projects involving database management or analytics, include them in your application. Describe your role, the technologies used, and the impact of your work on the project's success.
Highlight Soft Skills: Caxton Associates values collaboration and integrity. Make sure to mention your ability to work effectively with teams and your commitment to ethical practices in your application.
How to prepare for a job interview at Caxton Associates
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL Server databases in detail. Highlight specific projects where you designed schemas, optimised queries, or resolved performance issues. This will demonstrate your technical proficiency and problem-solving skills.
✨Demonstrate Your Data Visualisation Skills
Since the role involves building Tableau reports, be ready to showcase any relevant work you've done with data visualisation tools. Bring examples of dashboards you've created and explain how they helped stakeholders make informed decisions.
✨Understand the Risk Team's Needs
Research Caxton Associates and their Risk team's objectives. Be prepared to discuss how your skills can directly support their reporting and analytics requirements. Showing that you understand their business will set you apart from other candidates.
✨Prepare for Technical Questions
Expect technical questions related to database design, ETL processes, and performance tuning. Brush up on your knowledge of T-SQL, Python scripting, and best practices for database security. Being well-prepared will help you answer confidently.
