Excel Data Reporting Analyst
Posted 3 days ago by ETRA Talent
£60,000 Per year
Fixed-Term
Undetermined
London Area, United Kingdom
Summary: The Client Reporting Analyst role is a 6-month fixed-term contract within a leading investment management firm, focusing on the production of high-quality client reports across various cycles. The position requires experience in investment management reporting, data analysis, and process improvement in a fast-paced environment. The analyst will collaborate with teams to manage complex queries and enhance reporting workflows. This role offers an opportunity to contribute to automation initiatives and improve reporting processes.
Key Responsibilities:
- Produce and deliver accurate, complete, and timely client reports across monthly, quarterly, semi-annual, annual, and ad-hoc reporting cycles.
- Maintain, update, and perform quality assurance (QA) checks on reporting materials including factsheets, commentary, and scheduled client data requests.
- Analyse reporting data to ensure inputs are complete, accurate, and aligned with reporting requirements.
- Validate information and apply analytical techniques to prepare reporting outputs for clients, internal stakeholders, and third parties.
- Ensure reporting processes follow strong governance, controls, and documentation standards.
- Identify opportunities to improve reporting workflows and automate processes, leveraging Excel and tools such as PowerQuery or PowerBI.
- Work collaboratively with teams across the business to manage complex queries, data requests, and reporting changes.
Key Skills:
- 1+ year of experience in Client Reporting or a similar analytical/reporting role within Investment Management.
- Good understanding of investment data, reporting processes, and related systems.
- Knowledge of investment products, particularly pooled fund structures (UCITS and non-UCITS).
- Strong data analysis and data manipulation skills, with experience working with portfolio and fund-level datasets.
- Advanced Excel skills are essential.
- Experience with PowerQuery and PowerBI would be advantageous.
Salary (Rate): £60,000.00 yearly
City: London
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: fixed-term
Seniority Level: Mid-Level
Industry: Other
Client Reporting Analyst (6 Month FTC) We are currently supporting a leading investment management firm in the search for a Client Reporting Analyst to join their team on a 6-month fixed term contract . This role will sit within the reporting function and support the end-to-end production of high-quality client reporting across multiple reporting cycles. It is an excellent opportunity for someone with experience in investment management reporting who enjoys working with data, improving processes, and delivering accurate reporting in a fast-paced environment.
Key Responsibilities
- Produce and deliver accurate, complete, and timely client reports across monthly, quarterly, semi-annual, annual, and ad-hoc reporting cycles.
- Maintain, update, and perform quality assurance (QA) checks on reporting materials including factsheets, commentary, and scheduled client data requests.
- Analyse reporting data to ensure inputs are complete, accurate, and aligned with reporting requirements .
- Validate information and apply analytical techniques to prepare reporting outputs for clients, internal stakeholders, and third parties .
- Ensure reporting processes follow strong governance, controls, and documentation standards .
- Identify opportunities to improve reporting workflows and automate processes , leveraging Excel and tools such as PowerQuery or PowerBI.
- Work collaboratively with teams across the business to manage complex queries, data requests, and reporting changes .
Required Skills & Experience
- 1+ year of experience in Client Reporting or a similar analytical/reporting role within Investment Management .
- Good understanding of investment data, reporting processes, and related systems .
- Knowledge of investment products , particularly pooled fund structures (UCITS and non-UCITS) .
- Strong data analysis and data manipulation skills , with experience working with portfolio and fund-level datasets.
- Advanced Excel skills are essential.
- Experience with PowerQuery and PowerBI would be advantageous.
Why Apply? Opportunity to join a well-established investment management environment . Exposure to complex client reporting and investment data . Collaborative team with opportunities to contribute to process improvements and automation initiatives .