Investment Operations Reporting Analyst

Pension Insurance Corporation; Greater London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

Pension Insurance Corporation seeks an Investment Operations Reporting Analyst to drive high-quality investment reporting and continuous improvement across Investments, IT and Finance. The role covers Aladdin-enabled reporting, IBOR data, and valuation analysis for complex assets, with regular quarterly and monthly reviews for committees and leadership.

Deep Aladdin expertise, Fixed Income and Derivatives knowledge, and advanced Excel/Power BI capabilities are essential, as is the ability to

Qualifications

• Good working knowledge of Aladdin, including Aladdin Explore and dashboard-driven reporting.
• Strong knowledge of Fixed Income and Derivatives.
• Experience using Aladdin Explore and Power BI to create dashboards and support investment reporting.
• Experience delivering change and projects.

Responsibilities

• Act as the team champion for Aladdin, supporting the transition journey and delivering automated and insightful reporting.
• Use Aladdin outputs to support reporting, analysis and controlled production of investment reporting packs.
• Prepare and review internal reporting to the Investment Team and committees on a monthly/ quarterly basis.
• Oversee NAV sign-off and month-end reconciliations; validate IBOR data inputs/outputs.
• Prepare daily Exposure and Spread reporting; compute daily asset P&L attribution and derivative valuations.
• Monitor Traded Risk (DV01 and PV01) and report Liquidity and Collateral metrics weekly/monthly.

Skills

Aladdin

Fixed Income

Derivatives

Strong communication

Organisational skills

Tools

Aladdin Explore

Power BI

MS Excel

VBA

Python

Job description

We are looking for an Investment Operations Reporting Analyst to play a key role in delivering high-quality investment reporting, driving continuous improvement, and collaborating with stakeholders across Investments, IT, and Finance to enhance systems, processes, and technology.

• To apply knowledge and insights concerning Investment Reporting and how this impacts our policyholders.
• To deliver strong business outcomes relating to capital, profitability, the Company brand, and market reputation whilst achieving positive outcomes to our policyholders and shareholders on a consistent basis.
• Our Company values are expected to be reflected in the delivery and performance of every role.

Specific accountabilities assigned to the role of Investment Operations Reporting Analyst within the Investment Operations Function:

• Act as the team champion for Aladdin, supporting the team through the transition journey as part of the wider data change programme, ensuring Aladdin-enabled reporting is understood, adopted, automated and elevated to deliver more efficient, controlled and insightful reporting outcomes.
• Use Aladdin, including Aladdin Explore and related dashboard outputs, to support reporting, analysis and controlled production of investment reporting packs.

• Understand and support workflows into Aladdin reporting dashboards, identifying data dependencies, controls and process improvement opportunities.
• Provide support to PIC’s Investment team by preparing and reviewing internal reporting to the Investment Team and wider audiences, including various internal committees, on a monthly and quarterly basis.
• Oversee the NAV sign-off process and any subsequent queries. Prepare and check month-end accounting reconciliations.
• Support the production of IBOR data through product knowledge, validation of data inputs and outputs, exception investigation and collaboration with relevant teams.
• Preparation of daily Exposure and Spread reporting for the Investment team daily.
• Preparation of daily asset P&L attribution and derivative valuations analysis for the Investment team.
• Traded Risk monitoring, including DV01 and PV01.
• Preparation of Liquidity and Collateral reporting on a weekly and monthly basis to ensure risk metrics are monitored.
• Run in-house pricing and valuation models for non-benchmark credit and ERM assets.
• Prepare and review Equity Release Mortgages trade lifecycle events, including new and redeemed transactions and liquidity management.
• Manage team queries and ensure appropriate, high-quality responses are provided in a timely manner.
• Provide valuation expertise across complex private assets and derivatives, using knowledge of underlying valuation methodologies and assumptions to validate outputs, investigate anomalies and constructively challenge assumptions where required.

• Prepare and review Equity Release Mortgages trade lifecycle events, including new and redeemed transactions and liquidity management.
• Manage team queries and ensure appropriate, high-quality responses are provided in a timely manner.
• Provide valuation expertise across complex private assets and derivatives, using knowledge of underlying valuation methodologies and assumptions to validate outputs, investigate anomalies and constructively challenge assumptions where required.

Knowledge

• Good working knowledge of Aladdin, including Aladdin Explore, dashboard-driven reporting and workflows into Aladdin reporting dashboards.
• Strong technical knowledge of Fixed Income and Derivatives.
• Understanding of risk-metrics and sensitivities Duration, Spread, PV01 and IE01.
• Advanced Microsoft Excel skills, including VBA and PivotTables; the reporting tools are macro driven and require the technical skills to troubleshoot and build upon existing code. Python desirable.
• Product knowledge to support the production of IBOR data, including validation of data inputs and outputs and the operation of valuation models.

Skills

• Strong organisational skills.
• Strong communication skills.
• Ability to persuade and influence both directly and indirectly.
• Ability to organise work to meet deadlines.
• Ability to work within defined procedures as recommended by functional teams.
• Good working knowledge of Aladdin (inc. Explore), MS Excel, MS PowerPoint, MS Word and Power BI.

Experience

• Experience working closely with Investment teams.
• Experience using Aladdin Explore and Power BI to create dashboards and support investment reporting.
• Experience understanding, documenting and improving workflows into Aladdin dashboards and related reporting processes.
• Experience assisting with the production and validation of IBOR data and running valuation models.
• Experience delivering change and projects.
• Experience working in a corporate or consulting environment, the majority in banking, asset management, insurance, or hedge fund.

DEI at PIC

At PIC, we believe that true innovation stems from embracing diverse perspectives, backgrounds and experiences. We are committed to building a workplace where every individual, regardless of race, gender identity, sexual orientation, disability, age, religion, or socio-economic background, feels valued, heard and empowered to succeed. We hold ourselves accountable through ongoing initiatives, such as inclusive hiring practices, and equitable career development opportunities that support belonging and community. While we’re proud of our progress, we recognise there’s work ahead, and we remain dedicated to listening, learning and evolving together.

In addition to a competitive base salary and the opportunity to participate in our annual, performance-related bonus plan, upon joining us here at Pension Insurance Corporation, you will get access to some great benefits, including private medical insurance, 28 days' annual leave (excluding bank holidays), a generous pension scheme and much more.