Build and optimise SQL Server logic that supports investment performance calculations and reporting
Improve query performance and resolve bottlenecks across large and complex datasets
Translate investment data from custodians and market sources into structured, analytics ready models
Work closely with engineering and product teams to ensure outputs are accurate, reliable and aligned to client needs
Requirements
Deep experience with SQL Server
Strong experience writing and optimising complex SQL and T SQL queries
Proven ability to troubleshoot and improve performance at scale
Experience building database logic for analytics or reporting environments
Experience working with investment performance, performance reporting, or closely related financial systems within an investment management environment
Practical exposure to asset classes such as fixed income, equities, or multi asset portfolios, and how these are represented in performance and portfolio data
Confident understanding of returns, benchmarks and portfolio structures, with the ability to validate outputs in a real world context
Familiarity with custodial, market or portfolio accounting data and how it feeds performance reporting
Comfortable identifying when results do not look right and investigating data or calculation issues
Python experience (Nice to have)
Exposure to modern development tooling including AI assisted tools (Nice to have)
Experience working with asset managers, fund administrators or investment data vendors (Nice to have)
Exposure to concepts such as composites or attribution is beneficial (Nice to have)
Tech Stack
Python
SQL
Benefits
Generous Time Off packages including additional half days with each public holiday in your location.