Senior Data Engineer (Metadata & Lineage Integration)

Intellias; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

Intellias is assisting a global investment management client headquartered in London. We seek a hands-on senior Python engineer with strong data-engineering skills to design and build catalogue, semantic, entitlement and analytical layers that transform large on-premise data estates into AI-ready assets for safe enterprise use.

You will lead the development of data catalogue foundations, enabling agents to access, interpret, and reason over data with quality and governance baked in.

Qualifications

• 5+ years building production data systems in Python with solid SQL and testing practices.
• Experience building crawlers, harvesters or connectors for inventories, schemas, and lineage.
• Event-driven integration with Kafka and secure producer patterns.
• Search/document stores such as Elasticsearch/OpenSearch/MongoDB.
• Knowledge of data lineage modelling with OpenLineage.
• Experience applying LLMs to metadata work.
• Fluent English in written and spoken communication.

Responsibilities

• Build extraction, enrichment and registration paths that populate domain catalogues from live estates and connect to the central catalogue.
• Extend scraping from bare dataset inventories to full metadata including descriptions and dictionaries.
• Load vendor schema metadata at scale via vendor APIs into a persistent knowledge base for humans and LLMs.
• Seed report and dataset inventories from existing metadata tables and ETL sources with LLM-drafted descriptions.
• Integrate lineage into the client's lineage backend across batch, streaming and cross-system report chains.
• Implement the federation contract with stable identities and ownership exposed by local catalogues.
• Keep metadata current through scheduled and event-driven refresh with staleness detection.

Skills

Python

SQL

Data engineering

Testing & code review

Kafka

OpenLineage

LLM metadata

English

Tools

Elasticsearch

OpenSearch

MongoDB

Kafka tooling

Job description

Our client is a leading global investment management company headquartered in London. It manages over $228 billion in assets and serves institutional investors, pension funds, wealth managers, and other sophisticated clients worldwide. The firm specializes in quantitative investing, alternative investments, systematic trading strategies, and technology-driven asset management. Data science, machine learning, and AI are core components of its investment and research processes.

As part of our collaboration we will focus on two foundational capabilities required to enable safe and scalable AI adoption across the enterprise: Agentic Security and AI-Ready Data Foundations.

We build the data foundations that make AI useful and safe inside regulated financial firms. The value of AI is capped by the data its agents can reach: if an agent cannot find, interpret, trace or be correctly permissioned against data, the capability is useless, or worse, unsafe. Your job is to close that gap.

This is a hands on senior role for an excellent Python engineer with strong data-engineering skills who is genuinely comfortable building with AI agents. You will design and build the catalogue, semantic, entitlement and analytical layers that turn large on-premise data estates into something agents can use.

Requirements

• 5+ years building production data systems in Python, with strong engineering fundamentals (testing, code review, performance) and solid SQL.
• Experience building crawlers, harvesters or connector frameworks that extract inventories, schemas, field dictionaries and lineage from databases, filesystems, message platforms and API surfaces, in addition to conventional data pipelines.
• Event-driven integration with Kafka or similar, including secure producer patterns (mTLS or equivalent) and schema-managed topics.
• Experience with search and document stores that back catalogue platforms (e.g. Elasticsearch, OpenSearch, MongoDB or similar).
• Working knowledge of lineage capture and modelling, with OpenLineage or similar as a reference, and readiness to work with proprietary in-house event models.
• Experience applying LLMs to metadata work, such as drafting descriptions and classifications for human review, including quality evaluation of the generated output.
• Readiness to work inside another team's codebase, complete components that the team has designed, and contribute through its review process.
• Fluent English for written and spoken communication with client teams.

Will be a plus

• Time-series and tick stores (e.g. kdb+ or similar columnar time-series databases), market-data vendor schema APIs, symbology and asset-class concepts (market-data opening).
• MS SQL Server estates, reporting and BI systems, inventory extraction from application metadata tables (reporting opening).
• Columnar and lake formats (Parquet or similar), large object stores, orchestration platforms (Airflow or similar).
• Working-level knowledge of graph databases; data contracts and data quality frameworks; catalogue platforms (DataHub or similar) on the ingestion side.
• Day-to-day use of AI coding agents; building data services consumed by AI agents.
• Experience in financial services or other regulated on-premise environments.

Responsibilities

• Build extraction, enrichment and registration paths that populate domain catalogues from live estates (databases, time-series stores, streaming platforms, filesystems, internal and vendor APIs) and connect them to the client's central catalogue through its existing mechanisms.
• Extend an existing scraping capability from bare dataset and symbol inventories to full metadata: descriptions, field-level dictionaries, date ranges, asset-class and cadence tags, vendor provenance.
• Load vendor schema metadata at scale, through vendor APIs, into a persistent internal knowledge base designed for step-by-step disclosure to humans and LLMs.
• Seed report and dataset inventories from existing application metadata tables and ETL sources; combine them with LLM-drafted descriptions approved by stewards.
• Integrate lineage into the client's lineage backend across batch, streaming and cross-system report chains, completing the client's existing registration designs.
• Implement the federation contract defined by the architect: stable identities, ownership, hierarchy, links and availability state exposed by each local catalogue to the central layer.
• Keep metadata current through scheduled and event-driven refresh, with explicit staleness detection and quality signals.