Data Analyst

About London CIV

London CIV was established as a collective venture to pool LGPS pension assets. London CIV is one of six LGPS investment pools in England and Wales, and supports more than a third of local authority pension funds nationwide. We support our Partner Funds across three core areas: Investment Advice; Investment and Asset Management; and Administration and Pension Support Services.

From day one, you'll have on-the-job learning opportunities across a range of asset classes and exposure to leading managers, with plenty of hands-on experience to support your development.

The role

As a Data Analyst within London CIV, the role holder will conduct data reconciliation and validation activities, ensuring that inbound data flows from suppliers such as our Custodian, Partner Funds & Fund Managers are received in a timely manner and that the data integrity is to the required standard. 

Working under the Chief Technology & Security Officer and the direction of the Data Architect, the role holder will sit at the centre of all of LCIV's data workflows, ensuring that high-quality data underpins wider organisational decision-making. This would suit a graduate or early-career candidate with strong analytical skills and an interest in investments, data and financial markets.

What you'll be doing

Data Flow

Validate that time critical data feeds are received within the correct timeframe and that the data supplied meets the requirements of the Investment and Operations teams, reporting any discrepancies to the Data Architect for guidance.

Monitor inbound data flows from the Custodian, Partner Funds and Fund Managers, identifying delays, data breaks, or anomalies and ensuring swift resolution. 

Maintain oversight of data dependencies across the investment lifecycle, escalating risks or delays that may impact performance reporting, NAV calculations, or downstream processes. 

Supplier Management 

Engage with data suppliers to resolve any issues with the provision or quality of their feeds.

Build strong working relationships with internal Investment, Operations, and Technology teams to align data requirements, share insights, and proactively identify areas for data quality improvement.

Identify data risks, trends, and root cause issues, raising these with the Data Architect and subsequently communicating these clearly to stakeholders at varying levels of technical understanding.

Data Quality Assurance & Issue Resolution 

Perform data validation, integrity checks and exception investigation, ensuring discrepancies are analysed, documented, and resolved in a timely manner.

Take ownership of recurring data issues by supporting the Data Architect to drive root cause analysis, working with service providers and internal teams to implement preventive solutions.

Support the development and embedding of data quality metrics, dashboards, and KPIs to provide visibility of data health across the organisation.

Support the Establishment of a New Data Function 

Contribute to designing and shaping core data management processes as part of the organisation's new data capability, ensuring they are scalable, repeatable, and aligned with best practice.

Provide practical input into workflows, documentation, and controls that reduce operational burden for Investment and Operations teams.

Support the definition and evolution of a data quality framework.

Cross-Team Collaboration & Governance

Collaborate closely with Investment teams to ensure data processes support their analytical, reporting and portfolio management needs.

Bring a proactive, delivery focused mindset, working independently on day to day responsibilities while seeking guidance where needed.

Leadership and Culture

Work closely with senior leaders across the organisation to support the performance of the operations function. This will involve leading by example to inspire colleagues, support talent, and role model what good looks like to your peers. 

Demonstrate the behaviours and standards that contribute to a strong organisational culture.

Act as an internal centre of excellence within your area of specialism, promoting consistent standards, sharing knowledge, and driving continual improvement across the organisation. 

Maintain high standards of professionalism at all times. Adhere to the conduct rules expected of a Conduct employee under the SMCR. 

Proactively lead engagement across all LCIV teams, as well as external stakeholders ensuring clear and timely communication. When it comes to high-priority projects, proactively act as a bridge between stakeholders, and employees, ensuring alignment in objectives, priorities and delivery.

What we're looking for

Essential

Relevant degree in Data Analysis, Mathematics, Statistics or Computer Science preferred.

Excellent analytical skills and strong Excel skills. 

Accuracy and attention to detail.

Strong written and oral communications skills.

Well organised, strong workflow management and problem-solving skills.

Strong desire to work within the evolving field of Data and Artificial Intelligence.

Desirable

Understanding of data quality principles and governance.

Experience with data visualisation tools such as PowerBI.

Experience with AI tools such as CoPilot or Claude.

What we offer

10% employer pension contribution, 26 days' annual leave plus 3 extra days over Christmas, hybrid working, private medical insurance, enhanced family-friendly pay, study sponsorship and more. Ask us for our full benefits summary.

We are committed to building an inclusive team and welcome applications from all backgrounds. If you need any adjustments during the recruitment process, just let us know.