The Client
My client is a market leading macro focused hedge fund with offices across EMEA, USA, UAE and APAC.
The are looking for a Database Developer to join their technology team, working closely with Risk on their main database and workflows.
What You'll Get
* An opportunity to work in one of the most exciting and successful buy-side businesses in the City.
* An opportunity to join a strong team with a very high talent density presenting lots of opportunity for learning and development.
* Incredible career progression opportunities with potential access to all areas of the business.
* A market leading compensation package including basic salary and annual bonus.
* Benefits including a non-contributory pension, private healthcare, life assurance and 25 days annual leave.
What You'll Do
This role involves designing, developing, and maintaining the 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. Your responsibilities will include:
* Working closely with the Risk team to develop and refine reporting and analytics requirements.
* Designing and implementing efficient database schemas, tables, indexes, and stored procedures.
* Developing, optimising, and maintaining 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.
* Monitoring and optimising database performance, identifying slow queries, indexing strategies, and query plans.
* Building and maintaining database-driven reports, dashboards, and analytics using Tableau.
* Designing, maintaining, enhancing ETL processes for all aspects of the firm’s positions, trades and pricing information.
What You'll Need
* 3+ 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 optimisation, indexing strategies, and troubleshooting database performance issues.
* Experience building, maintaining, and optimising 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.