Software & Data Engineer — Investment Data Platform in London

Osmosis is an asset management business in what we would argue is the most exciting area of the market - sustainable investing. Our mission is to provide investors with investment solutions that target better risk‑adjusted returns while mitigating the environmental impact of their portfolios. Our growth is a testament to the team we have built and the results we have delivered.

About Osmosis

Osmosis launched in 2009 and is majority owned by management and employees. The company is headquartered in London with a presence in the US and a growing presence in Australia. Osmosis, a market leading sustainable asset manager, is rebuilding the investment stack from the ground up. As we scale into a next-generation environmental asset manager, we are designing a proprietary data and AI platform that transforms how sustainability data is captured, validated, and used in real investment decisions.

We are at an inflection point. The firm is evolving from a traditional asset manager into a technology‑enabled investment platform. The systems we build now will define how we scale, differentiate the firm and further develop and protect our IP advantage.

About the Role

We're looking for a technically versatile engineer to join the team that builds and operates our environmental, fundamental, and market data platform — from ingestion and infrastructure through to the applications our analysts, quants, and clients rely on every day. This role sits at the heart of the organisation. You'll work directly with portfolio managers, research analysts, quants, environmental scientists, and leadership to understand what's needed and make it happen. You won't be pigeonholed — you'll own the full journey from raw data landing in a lakehouse through to the web application a researcher uses to act on it.

On any given week you might be tuning a Snowflake warehouse to reduce compute costs, building a dbt model for a new ESG dataset, extending our internal Blazor application, or wiring up an Azure OpenAI pipeline and an AI agent to extract structured data from sustainability reports.

What You'll Build

• ETL/ELT pipelines ingesting market data, ESG datasets, fundamental data, and alternative data from vendors including Bloomberg and FactSet into Snowflake and cloud-based databases.
• A well-structured lakehouse Microsoft Fabric (OneLake, Delta/Parquet) or other database solution alongside curated Snowflake schemas serving analyst and quant workloads.
• dbt transformation models turning raw ingested data into clean, validated, analytics‑ready datasets.
• Processing pipelines that extract structured data from messy real‑world documents — sustainability reports, financial disclosures — using Azure Document Intelligence and Azure OpenAI.
• The internal web application our research team uses daily to manage companies, fields, and extracted data.
• Queue‑based microservices that coordinate work across the platform reliably and at scale.
• Multi‑agentic frameworks connecting quantitative research tools to the platform.
• Automated data quality checks, confidence scoring, reconciliation, and alerting.

Core Responsibilities

Data Infrastructure

• Design and maintain ETL/ELT pipelines across Snowflake and the other cloud-based database.
• Monitor and tune Snowflake warehouse sizing, auto‑suspend settings, and credit consumption across multiple virtual warehouses.
• Maintain lakehouses, warehouses, OneLake structure, Delta table compaction, and partition strategies.
• Implement cost governance using resource monitors, query tagging, and capacity management.
• Design the integration layer between Snowflake and other databases — what lives where and how data moves between them.

Application & Platform

• Build and extend the internal Blazor web application used daily by research analysts.
• Deploy and manage Azure resources using Infrastructure as Code (Bicep), keeping environments reproducible and costs controlled.
• Build and maintain Azure Functions (C# and Python) as queue‑driven microservices.
• Integrate AI/ML services: Azure OpenAI, Document Intelligence, embedding‑based search, LangGraph.
• Maintain CI/CD pipelines via Azure DevOps, with automated testing and trunk‑based development.
• Manage outsourced IT functions and oversee IT security practices.

What We're Looking For

Required:

• Solid professional experience building and shipping software across data and application layers (preferably using Azure Apps or Azure containers).
• Highly proficient in Python; comfortable in C# or willing to learn.
• Strong SQL — complex CTEs, window functions, multi‑table joins — across both Snowflake and potentially Fabric.
• Hands‑on Snowflake experience: warehouse management, clustering, query profiling, cost optimisation.
• Hands‑on Microsoft Fabric or Azure Synapse is highly desirable: lakehouses, warehouses, Delta Lake, OneLake.
• Experience with dbt for data transformation and modelling.
• Experience with AI/ML services, LLM integration, or document processing pipelines.
• Familiarity with financial or market data structures (prices, factors, corporate actions, ESG).
• A DevOps mindset — you care about how code gets built, tested, deployed, and monitored.
• Clear communication in a small team where everyone talks directly to everyone else.

Nice to have:

• Familiarity with Blazor, Django, or FastAPI.
• Experience with LangGraph or multi‑agent frameworks.
• Knowledge of ESG or sustainability reporting frameworks.
• Familiarity with financial data vendors: Bloomberg, FactSet, MSCI.
• Exposure to quant workflows: backtesting pipelines, factor data, time‑series datasets.
• Infrastructure as Code experience (Bicep, Terraform, or similar).
• Microsoft certifications: DP‑600 or DP‑203.

What Good Looks Like

The right person is equally comfortable reasoning about why a Delta table needs repartitioning and why a Blazor component is re‑rendering unnecessarily. They don't wait to be told what to build — they talk to the researchers, understand the problem, and propose the solution. They understand that in a small team, owning what you ship means caring about cost, reliability, and the user experience, not just whether the code runs.

Osmosis recognises the positive value of diversity and aims to promote equality and challenge unfair discrimination. As a champion of equal opportunity employment, we welcome applications from all suitably qualified persons – people of all ages, sexual orientations, backgrounds, religions, and beliefs. We particularly encourage applications from women, disabled, and Black, Asian and minority ethnic candidates as these groups are underrepresented throughout the financial services industry.