Senior Investment Data Specialist

Location: Edinburgh

Job Title

Department

Investment Projects and Improvements-BG-UK

Overview of Department

The Investment Projects and Improvements team support colleagues in the Investment Department to improve efficiency, reduce risk, and implement changes to cope with changing client or regulatory requirements. A key part of this is supporting the development of our investment strategies and the capabilities we offer clients. The team's main focus is to reduce the burden on investment staff from excessive non-investment related activities such as project work or committee membership.

Purpose of Role

As a Senior Investment Data Specialist, you'll play a key role in developing our Investment Data capability, combining investment domain knowledge with data engineering, data modelling and analytical expertise. You'll work closely with investors, analysts, risk colleagues and technical teams to translate business requirements into trusted, reusable and well-designed data products, with Snowflake as our primary investment data platform.

This is a hands-on, individual-contributor role with a high degree of autonomy. It is deliberately neither a pure data-engineering role nor a quantitative-research role; it sits between the two and is valued for exactly that.

You'll bring an understanding of how investment data is created and consumed, alongside strong technical and analytical capability. You'll work with large and complex datasets, develop effective data-quality controls and automate the detection and resolution of data issues, helping ensure investment data is accurate, reliable and ready to support decision making.

Alongside hands-on delivery, you'll contribute to the future direction of our Investment Data strategy and platform, including how trusted data is made available through Power BI, Streamlit, SQL, Python, APIs, MCP-based services and increasingly LLM and AI-enabled applications.

Responsibilities

• Drive the design and delivery of high-quality Investment Data products and act as domain owner for those products in line with our data governance framework, sharing detailed, investment-specific data knowledge.
• Work closely with investment teams to understand how data is consumed and translate their requirements into appropriate data products and features.
• Design practical, reusable data models and semantic structures that support multiple consumption patterns.
• Ensure data products have clear definitions, appropriate data-quality controls, lineage and documentation.
• Contribute to the evolution of the Investment Data platform, including engineering standards, modelling patterns and target architecture.
• Help define how trusted investment data is exposed through BI, analytical, application and AI-enabled channels.
• Work collaboratively with Data Engineers, Data Analysts, Data Solutions Analysts, architecture colleagues and other technology specialists.
• Identify, evaluate and help onboard new traditional and alternative datasets, assessing quality, coverage, methodology, long-term value, cost and compliance considerations.