Database and Analytics Developer
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 in a hybrid role based in London. This position sits at the intersection of database management and analytics, focusing on the firm's critical Risk infrastructure.
The role offers an exciting opportunity to work with a leading investment firm that excels in discretionary global macro investing. As the Database and Analytics Developer, you'll be responsible for designing, developing, and maintaining the firm's main Risk database and workflows, while also creating impactful visualizations through Tableau to support the Risk team's decision-making processes.
The ideal candidate will bring at least 5 years of extensive experience with SQL Server databases, combined with Python programming skills and a strong background in database optimization and ETL processes. You'll be working with complex financial data, requiring both technical expertise and business acumen to deliver effective solutions.
Key aspects of the role include designing efficient database schemas, implementing robust security measures, optimizing performance, and creating comprehensive documentation. You'll also be responsible for building and maintaining Tableau dashboards, ensuring data integrity, and managing reporting workflows.
This position offers the opportunity to work in a dynamic financial environment, collaborating with various stakeholders while contributing to the firm's risk management capabilities. The hybrid work arrangement provides flexibility while maintaining direct collaboration with the team.
For someone passionate about database development, analytics, and financial technology, this role presents an excellent opportunity to make a significant impact at a well-established global investment firm. The position combines technical challenges with business-critical responsibilities, making it an ideal next step for an experienced database professional looking to advance their career in the financial sector.
Responsibilities For Database and Analytics Developer
- Design, develop, and maintain main Risk database and workflows
- Work closely with Risk team to develop and refine reporting and analytics requirements
- Design and implement database schemas, tables, indexes, and stored procedures
- Develop and optimize 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 and maintain ETL processes
- Ensure database maintenance, backups, and recovery processes
- Implement database security best practices
- Create and maintain documentation
- Industrialize and maintain risk system feeds and workflows
- Handle raw data reporting requirements to external stakeholders
Requirements For Database and Analytics Developer
- At least 5 years working extensively with SQL Server databases
- Experience using Python for scripting database tasks
- Proven experience designing normalized and optimized relational database schemas
- Experience in performance tuning, query optimization, and indexing strategies
- Experience building and optimizing ETL processes
- Familiarity with Tableau or similar tools
- Experience in database maintenance tasks
- Demonstrated ability to collaborate with stakeholders
- Displays and operates at the highest degree of ethics and integrity
Jobs Related To Caxton Associates Database and Analytics Developer
