Climate Data Engineer: SQL, Python & AI for Analytics

Banner-Life-Family-of-Companies; Greater London; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Annual bonus

Share schemes

Pension contributions

Life assurance

Healthcare plan

25 days holiday

Electric car scheme

Job summary

Legal & General (L&G) in the UK is seeking a Database Developer to strengthen our climate modelling toolkit, Destination@Risk, and deliver scalable data solutions for investment decision‑making.

You’ll work with Investments, ESG and climate specialists to develop climate scenarios, analytics and reporting, while building robust SQL databases, data pipelines and AI-enabled workflows. Join a team driving a low‑carbon transition.

Qualifications

• Degree-qualified in Computer Science, Mathematics, Statistics, Finance, Data Science or related discipline.
• Strong SQL development skills with efficient stored procedures, functions, and views.
• Knowledge of database design principles and performance optimisation techniques.
• Experience with Python and willingness to expand tech skills.
• Understanding of window functions, CTEs, indexing, transactions, source control and job scheduling.
• Experience using GitHub or similar version control tools and code reviews.

Responsibilities

• Support the development and enhancement of climate scenarios, climate risk analytics, temperature alignment measures and related metrics within Destination@Risk.
• Collaborate with investment, ESG and climate specialists to deliver reporting and analytical 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 visualisation tools that support portfolio analysis and investment decision‑making.
• Analyse climate and portfolio data to identify trends, patterns and actionable insights.
• Embed AI-enabled solutions into workflows and explore opportunities for future innovation.
• Support colleagues across the business in using climate data tools for reporting, research and analysis.

Skills

SQL development

Python

Data analysis

Git/GitHub

Climate interest

Problem solving

Communication

Education

Computer Science

Mathematics

Statistics

Data Science

Finance

Tools

GitHub

Job description

Legal & General (L&G) in the UK is seeking a Database Developer to strengthen our climate modelling toolkit, Destination@Risk, and deliver scalable data solutions for investment decision‑making.

You’ll work with Investments, ESG and climate specialists to develop climate scenarios, analytics and reporting, while building robust SQL databases, data pipelines and AI-enabled workflows. Join a team driving a low‑carbon transition.