Data BA / Modeller - Hedge Fund - London

Investigo; Greater London; On-site; GBP 85,000 - 110,000; Full time

Job summary

Investigo is seeking a Senior Data BA/Data Modeller to support a major transformation of a hedge fund's Portfolio Management System. The role focuses on modelling complex legacy datasets, mapping data, and enabling migration into Snowflake.

You will bridge Front Office users with Data Engineering, analyse datasets including derivatives, and define source-to-target mappings for data migration. Strong SQL and financial product knowledge are essential.

Qualifications

• Strong Data BA / Data Modelling experience within financial markets.
• Strong understanding of derivatives and financial products, particularly options and swaps.
• Understanding of how option curves are constructed, including the underlying market data, pricing inputs and data structures.
• Good understanding of how swaps work, their lifecycle and the data required to represent them.
• Experience with data mapping, modelling and migration across complex financial datasets.
• Strong SQL and ability to interrogate data at a field level.

Responsibilities

• Analyse and document complex financial markets datasets, including trade, position, pricing and reference data.
• Acting as the interface between Front Office users and Data Engineering.
• Work dataset-by-dataset and field-by-field to understand existing data structures and relationships.
• Analyse data supporting option curves, including the inputs and structures used for pricing and valuation.
• Define data models and source-to-target mappings for migration into Snowflake.
• Translate financial product and business requirements into data requirements.
• Work closely with data engineers, architects, traders and portfolio managers.
• Design data structures suitable for both internal users and external hedge fund clients.
• Identify data quality issues and dependencies across legacy datasets.

Skills

Data modelling

SQL

Derivatives knowledge

Option curves

Data mapping

Data migration

Stakeholder liaison

Tools

Snowflake

Job description

Senior Data BA / Data Modeller

We are working with a hedge fund technology business looking for a Senior Data BA / Data Modeller to support a major transformation of its Portfolio Management System and underlying data estate. This is a technical BA role, focused on understanding complex legacy financial datasets, modelling and mapping data, and supporting migration into Snowflake.

Key Responsibilities

• Analyse and document complex financial markets datasets, including trade, position, pricing and reference data.
• Acting as the interface between Front Office users and Data Engineering
• Work dataset-by-dataset and field-by-field to understand existing data structures and relationships.
• Analyse data supporting option curves, including the inputs and structures used for pricing and valuation.
• Define data models and source-to-target mappings for migration into Snowflake.
• Translate financial product and business requirements into data requirements.
• Work closely with data engineers, architects, traders and portfolio managers.
• Design data structures suitable for both internal users and external hedge fund clients.
• Identify data quality issues and dependencies across legacy datasets.

Experience Required

• Strong Data BA / Data Modelling experience within financial markets.
• Strong understanding of derivatives and financial products, particularly options and swaps.
• Understanding of how option curves are constructed, including the underlying market data, pricing inputs and data structures.
• Good understanding of how swaps work, their lifecycle and the data required to represent them.
• Experience with data mapping, modelling and migration across complex financial datasets.
• Strong SQL and ability to interrogate data at a field level.
• Snowflake experience desirable.
• Comfortable working directly with traders, portfolio managers and technical teams.
• Hedge fund, asset management or investment banking experience highly desirable.