Business Data Analyst

DW Search; Greater London; On-site; GBP 83,000 - 120,000; Full time

Job summary

DW Search is hiring a Front Office Data Business Analyst to bridge front-office investment teams and engineering on a large-scale transformation of its investment data platform.

The role sits between portfolio managers, analysts and data engineers to shape data sourcing, structuring, governance and consumption for self-service analytics.

Qualifications

• Strong Business Analysis experience within front-office investment or capital markets environments.
• Experience working directly with portfolio managers, analysts, traders, quantitative teams or other sophisticated financial-data consumers.
• Strong understanding of investment, market, security, instrument, position, transaction or portfolio data.
• Hands-on data analysis capability, ideally including SQL.
• Experience with modern data platforms and technologies such as Snowflake, Databricks, Microsoft Fabric, Azure Synapse, AWS Redshift, BigQuery or similar cloud data environments.
• Experience working closely with data/software engineering teams.
• Strong requirements gathering, stakeholder management and communication skills.
• Exposure to data modelling, data quality, lineage, metadata, semantic layers, data catalogues or governance would be advantageous.
• Python experience would also be beneficial.

Responsibilities

• Partner with portfolio managers, investment analysts, quantitative teams and other front-office users to understand and challenge complex data requirements.
• Analyse data flows, sources and models and translate requirements into clear user stories, data mappings and technical specifications.
• Work closely with data engineers and architects throughout design and delivery.
• Help prioritise competing requirements across multiple investment teams and use cases.
• Investigate data issues and support improvements across data quality, ownership, lineage, metadata and business definitions.
• Help develop reusable, trusted data products rather than one-off solutions.
• Contribute to the firm's move towards self-service analytics, making investment data easier for front-office users to discover, understand and consume.

Skills

Business Analysis

SQL

Python

Stakeholder Management

Requirements Gathering

Data Modelling

Data Quality

Data Governance

Data Catalogues

Tools

Snowflake

Databricks

Microsoft Fabric

Azure Synapse

AWS Redshift

BigQuery

Job description

We are working with a major financial services firm looking to hire a Front Office Data Business Analyst into a large-scale transformation of its investment data platform.

The role sits directly between front-office investment teams and engineering, helping shape how investment data is sourced, structured, governed and consumed.

The role

• Partner with portfolio managers, investment analysts, quantitative teams and other front-office users to understand and challenge complex data requirements.
• Analyse data flows, sources and models and translate requirements into clear user stories, data mappings and technical specifications.
• Work closely with data engineers and architects throughout design and delivery.
• Help prioritise competing requirements across multiple investment teams and use cases.
• Investigate data issues and support improvements across data quality, ownership, lineage, metadata and business definitions.
• Help develop reusable, trusted data products rather than one-off solutions.
• Contribute to the firm's move towards self-service analytics, making investment data easier for front-office users to discover, understand and consume.

What we're looking for

• Strong Business Analysis experience within front-office investment or capital markets environments.
• Experience working directly with portfolio managers, analysts, traders, quantitative teams or other sophisticated financial-data consumers.
• Strong understanding of investment, market, security, instrument, position, transaction or portfolio data.
• Hands-on data analysis capability, ideally including SQL.
• Experience with modern data platforms and technologies such as Snowflake, Databricks, Microsoft Fabric, Azure Synapse, AWS Redshift, BigQuery or similar cloud data environments.
• Experience working closely with data/software engineering teams.
• Strong requirements gathering, stakeholder management and communication skills.
• Exposure to data modelling, data quality, lineage, metadata, semantic layers, data catalogues or governance would be advantageous.
• Python experience would also be beneficial.

This is an initial 6 month contract but very high likelihood of multiple extensions given the book of work. Rate is negotiable - focus is on getting the right candidate with relevant investment data experience. target start date early October.