Database Engineer - Hedge Fund

Tempestvanepartners; London; On-site; GBP 75,000 - 100,000; Full time

Job summary

A leading investment firm based in London seeks a Database & Analytics Engineer to enhance their Risk team's data architecture. This role involves designing a central Risk database, optimizing performance, and creating insightful visualizations to support high-stakes decisions. The position offers career growth, competitive compensation, and a chance to work with a talented team in a dynamic environment.

Benefits

Non-contributory pension

Private healthcare

Life assurance

25 days annual leave

Career progression opportunities

Qualifications

• 5+ years of in-depth experience with Microsoft SQL Server.
• Proficient in Python for database automation and transformations.
• Expertise in relational database design and performance tuning.

Responsibilities

• Partner with the Risk team to define reporting needs.
• Maintain data integrity and build Tableau dashboards.
• Oversee ETL processes for trades and pricing data.

Skills

SQL

Python

Data analysis

Database design

ETL processes

Business Intelligence

Performance tuning

Tools

Tableau

SQL Server Integration Services (SSIS)

Job description

3 weeks ago Be among the first 25 applicants

Direct message the job poster from Tempest Vane Partners

My client is a market-leading macro hedge fund with offices across EMEA, USA, UAE and APAC.

They are seeking a Database & Analytics Engineer who is passionate about data architecture and turning complex datasets into meaningful insights. This role will involve working within their Risk team and play a key role in shaping how they manage, analyse, and visualise critical risk data.

In this role, you'll be the go-to expert for designing and maintaining our central Risk database, ensuring performance, data integrity, and scalability. You'll also create clear, compelling visualisation dashboards that inform business decisions and help the Risk team thrive.

What You'll Get

• An opportunity to work in one of the most exciting and successful buy-side businesses in the City.
• End-to-end ownership: Architect, build, optimize, and visualize—it’s all yours
• Visible impact: Your insights and infrastructure support real-time, high-stakes decisions
• Cross-functional exposure: Work closely with both technical teams and risk leaders
• Opportunity to build, not just maintenance: They’re investing in scalable, modern systems.
• 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 include a non-contributory pension, private healthcare, life assurance and 25 days annual leave.

What You’ll Do:

• Partner with the Risk team to define and refine reporting needs.
• Write, optimize, and maintain SQL queries and data views.
• Resolve data integrity issues and ensure clean, reliable datasets.
• Build and manage Tableau dashboards and analytics tools.
• Oversee ETL processes for trades, positions, and pricing data.
• Monitor and fine-tune database performance (query plans, indexing, etc.)
• Maintain robust documentation and enforce best practices for security and maintenance.
• Support external reporting by owning a subset of raw data feeds.

What You Bring:

• Detail-oriented with a proactive approach to problem-solving.
• 5+ years of in-depth experience with Microsoft SQL Server, including advanced T-SQL development (queries, stored procedures, views, user-defined functions) and schema design.
• Proficient in Python for automating database operations, developing data transformation scripts, and integrating with external systems via APIs or file-based workflows.
• Expertise in relational database design, with a strong understanding of normalization, data integrity enforcement, and modelling for high-performance transactional and analytical workloads.
• Demonstrated skill in performance tuning, including query plan analysis, indexing strategy design, partitioning, and resolving concurrency and locking issues.
• Hands-on experience with ETL development, using tools like SQL Server Integration Services (SSIS) or custom Python-based ETL pipelines for large-scale data processing.
• Working knowledge of BI tools, preferably Tableau, for creating parameterized dashboards, calculated fields, and integrating data from multiple sources.
• Proven ability to translate business requirements into scalable data solutions.
• Committed to engineering best practices, including documentation, version control for database code, and secure handling of sensitive data.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology and Engineering

Referrals increase your chances of interviewing at Tempest Vane Partners by 2x

Get notified about new Database Engineer jobs in London Area, United Kingdom.

London, England, United Kingdom 7 hours ago

London, England, United Kingdom 2 weeks ago

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

London, England, United Kingdom $40,000.00-$50,000.00 2 weeks ago

London, England, United Kingdom 1 week ago

City Of London, England, United Kingdom £75,000.00-£85,000.00 4 days ago

London, England, United Kingdom 4 days ago

London Area, United Kingdom £250,000.00-£450,000.00 13 hours ago

London, England, United Kingdom 4 days ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 3 days ago

London, England, United Kingdom 11 hours ago

London Area, United Kingdom £90,000.00-£90,000.00 7 hours ago

London Area, United Kingdom £70,000.00-£75,200.00 12 hours ago

London, England, United Kingdom 5 days ago

City Of London, England, United Kingdom £60,000.00-£70,000.00 2 weeks ago

London, England, United Kingdom 12 hours ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

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