Senior Data Engineer (Metadata & Lineage Integration)

Intellias; City Of London; On-site; GBP 100,000 - 150,000; Full time

Job summary

Intellias is seeking a hands-on senior Python engineer with strong data-engineering skills to design and build the catalogue, semantic, entitlement and analytical layers that turn large on-premise data estates into usable AI-ready assets.

You will work on safe, scalable AI adoption across the enterprise, building extraction, enrichment and registration paths and extending existing scraping for metadata with LL M drafted descriptions and steward-approved quality controls.

Qualifications

• 5+ years building production data systems in Python with strong engineering fundamentals.
• Experience building crawlers, harvesters or connectors for inventories and metadata.
• Event-driven integration with Kafka and secure patterns (mTLS).
• Experience with search/document stores backing catalogues (Elasticsearch/OpenSearch, MongoDB).
• Knowledge of lineage capture and modelling; OpenLineage or similar reference.
• Experience applying LLMs to metadata work and quality evaluation.
• Able to work in another team's codebase and contribute via reviews.
• Fluent English for written and spoken client communication.

Responsibilities

• Build extraction, enrichment and registration paths from live estates to the central catalogue.
• Extend scraping from datasets to full metadata including descriptions and dictionaries.
• Load vendor schema metadata at scale into a persistent knowledge base.
• Seed inventories from application metadata tables and ETL sources with LL M-drafted descriptions.
• Integrate lineage into the client lineage backend across batch, streaming and reports.
• Implement federation contracts with stable identities, ownership and links.
• Keep metadata current with scheduled and event-driven refresh and quality signals.

Skills

Python

SQL

Data pipelines

Crawler frameworks

Kafka

Elasticsearch/OpenSearch

OpenLineage

LLM for metadata

English communication

Regulated environments

Tools

Elasticsearch

OpenSearch

MongoDB

Kafka

Airflow

Parquet

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.