Investment Data Analyst — Python, SQL & Fixed Income

Woodland Partners; Greater London; On-site; GBP 55,000 - 90,000; Full time

Job summary

Woodland Partners are seeking an Investment Data Analyst to join the team supporting investment data platforms across asset managers, credit data and actuarial deliverables. The role reports to the Head of Investment Platform & Analytics and requires hands-on coding in Python (pandas) and SQL, with a strong eye for data quality and controls.

You will build and maintain analytics tools for performance, liquidity and what-if scenarios, perform reconciliations on large datasets, and help migrate to

Qualifications

• Python (including pandas) and SQL used for real work.
• Comfortable with large, messy data sets: joins, reconciliations, and tracing a break to its root cause.
• Understands fixed income basics: bonds, ratings, cashflows, yield, market and book value, accrued interest.
• A control mindset: checks outputs before passing them on, documents changes, and is comfortable with an audit trail.
• Takes ownership: runs a monthly cycle to deadline, chases queries with asset managers, and gets things done.
• Clear written communication with non-technical colleagues.
• Insurance investment or regulatory data (e.g. BSCR, SBA, NAIC, Solvency II), structured credit or private credit.
• Git, testing, packaging and code review.
• Experience with investment management software (e.g. Bloomberg, Aladdin, Clearwater) or other asset manager data feeds.

Responsibilities

• Run and maintain a monthly investment datatape with inputs, overrides, and reporting category review.
• Produce watchlist data and rating verification reports to support credit risk data needs.
• Review analytics, holdings, transactions and cashflows from asset managers and perform reconciliations.
• Deliver EPA cashflow files for actuarial software.
• Build and maintain tools for performance, liquidity and what-if analyses across large data volumes.
• Maintain documentation, tests and version control in line with model risk management policies.
• Support evaluation or migration to an investment data platform.

Skills

Python (pandas)

SQL

Data testing

Git & code review

Documentation & audit trail

Communication with non-technical teams

Fixed income basics

Ownership & accountability

Investment management software (Bloom,

Education

Degree in quantitative subject

Computer Science degree

Finance degree with programming experience

Tools

Bloomberg

Aladdin

Clearwater

Job description

Woodland Partners are seeking an Investment Data Analyst to join the team supporting investment data platforms across asset managers, credit data and actuarial deliverables. The role reports to the Head of Investment Platform & Analytics and requires hands-on coding in Python (pandas) and SQL, with a strong eye for data quality and controls.

You will build and maintain analytics tools for performance, liquidity and what-if scenarios, perform reconciliations on large datasets, and help migrate to