Free cookie consent management tool by TermsFeed Vacancy - Data & Reporting Analyst | William Rose

Data & Reporting Analyst

Back to Live Roles
  • Permanent

Job Title: Data and Reporting Analyst 

Location: London

Role Overview:

William Rose Associates are working alongside an Asset Management firm based in London which is looking for a Data and Reporting Analyst to join the business. 

General Requirement:

•          Client and Fund reporting experience within asset management side or vendor solution providers (application software or middle office reporting)

•          Cross Product coverage including Equity, Derivatives, Futures and Options

•          Strong understanding of a range of performance measurement, performance attribution and general portfolio reporting (see below)

•          Able to proactively investigate reporting errors and errors in source data sets

•          Attention to detail, organised, self-starter able to run with work streams.

•          Experienced working with multiple teams, able to maintain relationships with front office and other stakeholders.

Legacy BAU Responsibilities:

•          Responsible for data quality of key investment data set, maintaining and ensuring accuracy of multiple data feeds.

•          Daily data validation, able to resolve reference data issues by undertaking analysis of anomalies in reference data and securities classification data.

•          Investigating workflow issues and fixing issues with workflow & dependencies

•          Able to automate and improve processes whilst also looking to make them as intuitive as possible.... including creation of procedures to document workflow/process

•          Able to help team members at month end during heavy reporting cycles to get multiple clients & regulatory reports completed on time.

•          Manage and maintain reference data change requests.

MATRIX Implementation Support & Future Operation:

•          Data Quality: Able to interrogate databases/systems, able to see why different systems have divergence. Problem shooting, able to fix issue.

•          Working with large datasets, able to carry out data cleaning & historical data interrogation.

Reporting types handled by the team:

•          Fund and Benchmark Time Series

•          Fund Exposures

•          Portfolio/Fund Performance

•          Performance Attribution

•          Trade Cost Analysis

•          Fund Expense reporting (TERs)

•          Factsheets

•          AUM

•          Regulatory (MIFID EMT, PRIIPS, AIFMD, Form ADV & PF, MAS)

Systems Skills:

•          MS Excel (advanced), VBA for Excel, advanced formula writing

•          Any BI tool like MS PowerBi (advanced)/Tableau

•          Power Query

•          BBG/BBG Wizard

•          SQL not essential but nice to have

•          Potentially other tools or languages such as OpenAI or Python. 

Take a look at some
of our Latest Roles

Explore a curated selection of opportunities, where your next career move is waiting.

Job Title:

Operations Analyst

 Location: London Role Overview: William Rose Associates is working alongside a highly regarded financial services institution based in London which is looking for an Operations Analyst, to join the firm. Responsibilities: Responsible for timely and accurate competition of reconciliations an

Permanent

Job Title:

Relationship Manager

Job Title: Relationship Manager Location: London Role Overview: William Rose Associates are working alongside a highly regarded Investment Platform and Software providers based in London which is looking for a Relationship Manager, to join the firm. Responsibilities: Taking on high levels of

Permanent

Job Title:

Client Service Administrator

Job Title: Client Service Administrator Location: London Role Overview: William Rose Associates are working alongside a highly regarded Wealth Management Firm based in London which is looking for a Client Services Administrator, to join the firm. Responsibilities: Opening of client accounts D

Permanent

Job Title:

Onboarding Administrator (12 month FTC)

Job Title: Onboarding Administrator (12 months FTC) Location: London Role Overview: William Rose Associates are working alongside a highly regarded Wealth Management Firm based in London which is looking for an Onboarding Administrator, to join the firm on a 12 month Fixed Term Contract. Responsi

Temporary

Job Title:

Transitions Officer

Job Title: Transitions Officer  Location: London Role Overview: William Rose Associates are partnering with a reputable bank based in London, which is recruiting for a Transitions Officer to join the business. Responsibilities Transition Management, ensuring timely receipt of all required docume

Permanent

Job Title:

Senior Investment Analyst

Job Title: Senior Investment Analyst Location: London Role Overview: William Rose Associates are partnering with a Wealth Management Firm based in London, which is recruiting a Senior Investment Analyst to join the business. The job holder will report to the CIO to assist with annual fund due di

Permanent

Job Title:

Operational Risk Management Officer

Job Title: Operational Risk Management Officer  Location: London Role Overview: William Rose Associates are partnering with a reputable bank based in London, which is recruiting an Operational Risk Management Officer to join the business. The job holder will act as the 2nd Line of Defence respon

Permanent

Job Title:

Operations Administrator

Job Title: Operations Administrator Location: London Role Overview: William Rose Associates are working with an exciting Wealth Management firm in London who are seeking a Operations Administrator to join the business. Responsibilities The role will involve supporting the Operations Team with a

Permanent

Job Title:

CASS Reconciliations Lead

Job Title: CASS Reconciliations Lead  Location: London Role Overview: William Rose Associates are working alongside a well-known financial services institution which is looking for a CASS Reconciliations Lead to join them.   You will oversee all reconciliations conducted by the CASS Reconciliati

Permanent

Job Title:

Bond Operations Settlements Analyst (12 month FTC)

Job Title: Bond Operations Settlements Analyst (12-month FTC) Location: London  Role Overview: William Rose Associates is working with a well-known Asset Management firm based in London, which is looking for a Bond Operations Settlement Analyst to join them on a 12-month FTC basis.  Responsibili

Temporary

Job Title:

Senior Bond Operations Settlements (Associate Manager)

Job Title: Bond Operations Settlements (Associate Manager) Location: London  Role Overview: William Rose Associates is working with a well-known Asset Management firm based in London, which is looking for an Associate Manager within Bond Operations Settlements to join them.  Responsibilities:

Permanent

Job Title:

Product Governance Executive

Job Title: Product Governance Executive  Location: London Role Overview: William Rose Associates are working alongside a highly regarded Private Bank based in London which is looking for a Product Governance Executive to join the business.  The objective of the role is to support the Product & P

Permanent

Job Title:

CPI Project Manager (Client Onboarding focus)

Job Title: CPI Project Manager (Client Onboarding focused) Location: London Role Overview: William Rose Associates are working alongside a highly regarded Asset Management firm based in London which is looking for a CPI Project Manager (Client Onboarding focus), to join the firm.  Responsibiliti

Permanent

Job Title:

EMEA Trade Support Lead

Job Title: EMEA Trade Support Lead  Location: London Role Overview: William Rose Associates are working alongside a highly regarded Asset Management firm based in London who are looking for an EMEA Trade Support Lead. This role will manage the regional team in EMEA supporting Trade Support and Co

Permanent

Job Title:

Investment Operations (Fund Accounting)

Job Title: Investment Operations (Fund Accounting) Location: London Role Overview: William Rose Associates are working alongside a well-respected Asset Management firm who are looking to grow their Investment Operations department and welcome an analyst to join the business.  This is a position

Permanent

Get in touch

Looking
for career support?

We invest in you. We take our time to understand you as an individual. Our goal is to support you in your personal and professional aspirations.

William Rose Associates
Max file size 10MB.
Loading...