SQL Developer

PSD Group; Greater London; Sur place; GBP 45 000 - 65 000; Plein temps

Résumé du poste

PSD Group is seeking a Data Analyst / Database Developer to enhance a proprietary climate modelling toolkit and deliver scalable data solutions for climate-related investments.

The role involves building and optimizing SQL databases, developing data pipelines, and creating reporting tools to support portfolio analysis and decision-making. Strong SQL and coding skills, plus an interest in climate modelling, are key.

Qualifications

• Strong SQL development skills, including stored procedures, views and queries.
• Experience with Python and willingness to expand skills across modern technologies.
• Knowledge of database design, indexing and performance optimization.
• Familiarity with version control tools (GitHub) and code review practices.
• Analytical mindset with ability to handle large datasets and derive insights.

Responsabilités

• Support development and enhancement of climate scenarios and risk analytics within the platform.
• Collaborate with investment, ESG and climate specialists to deliver reporting solutions.
• Develop, optimise and maintain SQL databases, stored procedures, functions and data pipelines.
• Build automated processes to ingest and manage large datasets from internal and external sources.
• Create reporting and visualization tools to support portfolio analysis and decision-making.
• Analyse climate and portfolio data to identify trends and actionable insights.
• Embed AI-enabled solutions into workflows and explore future innovations.

Connaissances

SQL development

Python

R

AI

Data analysis

Formation

Degree in Computer Science

Degree in Mathematics/Statistics/Finance/Data Science

Outils

GitHub

Description du poste

Our client is a leading Investment Management company who committed to helping build a more sustainable future. Their Climate Solutions team develops and implements climate response strategies for clients while supporting the integration of climate considerations across their investment capabilities. Working closely with colleagues across Investments, ESG, Stewardship and Distribution, the team plays a key role in developing innovative climate analytics, identifying energy transition opportunities, and supporting climate-focused investment strategies.

The team are looking for a Data Analyst / Database Developer to help enhance their proprietary climate modelling toolkit and deliver scalable data solutions that enable better decision-making across the investment business. This is an exciting opportunity to combine technical expertise with meaningful work that supports the transition to a low-carbon economy.

The role would suite someone who has good SQL skills (including Stored Procedures) together with some other coding experience (Python, R, AI). The role does not require Investment Management or ESG / Climate related experience but this is a great opportunity for someone who is interested in getting into this field / environment.

Key Responsibilities:

• Supporting the development and enhancement of climate scenarios, climate risk analytics, temperature alignment measures and related metrics within their existing platform.
• Collaborating with investment, ESG and climate specialists to deliver reporting and analytical solutions.
• Developing, optimising and maintaining SQL databases, stored procedures, functions and data pipelines.
• Building automated processes to ingest and manage large datasets from internal and external sources.
• Creating reporting and visualisation tools that support portfolio analysis and investment decision-making.
• Analysing climate and portfolio data to identify trends, patterns and actionable insights.
• Embedding AI-enabled solutions into existing workflows and exploring opportunities for future innovation.

Experience Required:

• Degree qualified in Computer Science, Mathematics, Statistics, Finance, Data Science or a related discipline.
• Strong SQL development skills, including experience creating efficient stored procedures, functions and views.
• Knowledge of database design principles and performance optimisation techniques.
• Experience working with Python and a willingness to further develop technical skills across modern technologies.
• Understanding of concepts such as window functions, CTEs, indexing, transactions, source control and job scheduling.
• Experience using GitHub or similar version control tools, including code review and collaboration practices.
• Strong analytical and problem-solving skills with the ability to work with complex datasets.
• Interest in climate change, sustainable investing or climate modelling, alongside the ability to communicate technical concepts clearly to a range of audiences.