Data Analyst, SQL/Python | Investment Management - Trading Platform | London, Hybrid | up to £120k + Bonus, Benefits

VirtueTech Recruitment Group; Greater London; Hybrid; GBP 108,000 - 132,000; Full time

Job summary

VirtueTech Recruitment Group is seeking a Data Analyst with SQL and Python skills for a London-based investment management trading platform. The role sits in a hybrid team focusing on data acquisition, governance and analytics to support investment decision making.

The ideal candidate has 5+ years of financial services experience, strong data modelling and BI development capabilities in Power BI, and hands-on experience with SQL Server and modern data platforms.

Qualifications

• 5+ years of Data Analyst experience in a Financial Services environment, with emphasis on Risk or cross-asset derivatives.
• Strong data modelling, cleansing and enrichment capabilities across conceptual, logical and physical layers.
• Experience with data warehousing and analytical data structures, quality assurance and data lineage.
• Experience building BI models and dashboards, preferably Power BI.
• Proficiency with SQL Server and data integration tools (SSIS, Data Factory).

Responsibilities

• Analyse risk data sourcing, data flows and storage across the organisation.
• Support migration of legacy data warehouse to a strategic data platform.
• Collect and migrate data from multiple systems into the central Data Platform with Data Management Team.
• Analyse normalised transactional and analytic data sources.
• Model data to support reporting structures and dashboards.

Skills

Finance data

Data modelling

Data quality

Power BI

SQL Server

Databricks

SSIS

Jira Software

Python

Risk data

Tools

Databricks

Snowflake

SSIS

Data Factory

Jira Software

Job description

Data Analyst, SQL/Python | Investment Management - Trading Platform | London, Hybrid | up to £120k + Bonus, Benefits

A leading global asset manager, responsible for assets under management across liability driven investment (LDI), cashflow-driven investing (CDI) and longevity hedging, currency management, fixed income, absolute return, multi‑asset and specialist investment strategies. Is looking to add to their Data team, by hiring a Data Analyst, coming from a financial services / Trading House background with knowledge around Risk, regulations, Compliance, Trade Surveillance etc...

The Data Analyst will join the Data Centre of Excellence, encompassing Data Analysis, Data Architecture, Data Intelligence and Machine Learning experts. This Data team helps the Investment Management House make use of their data to help make investment and risk decisions.

As a Data analyst you will be responsible for proactively managing aspects of the data acquisition and commercial lifecycle to create P&L impacting value for the investment business. Specifically within compliance, understanding the data needed from the business to make decisions, bridging the gap between the Business & Data technical experts.

The salary on offer for this Data Analyst Role, is up to £120,000 + Bonus and Benefits package.

The company works a hybrid model, with 3 days per week in the office, close to major tube stations including Liverpool Street.

As a Data Analyst you will:

• Analysing Risk data sourcing, how it flows and is housed in the organisation. You will map how to acquire data from primary and secondary sources and maintain data systems.
• The migration of legacy data warehouse to strategic data platform.
• Identifying, collecting and migrating data to and from a range of systems into the central Data Platform, working closely with the Data Management Team.
• Analysis of normalised transactional data and analytic data sources.
• Analysis of semi structured and file-based data extracts.
• Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models.

Essential Skills for the Data Analyst:

• Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas.
• Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation.
• Familiarity with Data warehousing and analytical data structures.
• Data quality assurance, validation and linkage.
• Experience creating BI models and dashboards, ideally in Power BI.
• Software development methodologies (Sprints/Agile) and project management software (Jira Software).
• SQL Server Database
• Databricks (or Alternative Modern Data Platform such as Snowflake)
• Knowledge of Orchestration Tools and processes (e.g SSIS, ODI, Informatica, Data Factory)
• Power BI Development including the data model, DAX, and visualizations

Data Analyst, SQL/Python | Investment Management - Trading Platform | London, Hybrid | up to £120k + Bonus, Benefits