Senior Data BA & Modeller – Finance Data Migration

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

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.